answersLogoWhite

0

What is overlapping key DBMS?

User Avatar

Sakthif1

Lvl 1
โˆ™ 2008-07-30 12:42:40

Best Answer

Overlapping Key is a type of candidate key which occurs in BCNF (Boyce –Codd Normal Form).In the difference between 3NF and BCNF Example : A 3NF table which does not have multiple overlapping candidate keys is guaranteed to be in BCNF. Depending on what its functional dependencies are, a 3NF table with two or more overlapping candidate keys may or may not be in BCNF.

User Avatar

Wiki User

โˆ™ 2008-07-30 12:42:40
This answer is:
User Avatar
Study guides

What are advantages of Database Approach

What is a network that covers a large geographical area such as a city country or world

What is the worlds largest wan

What is a network server

โžก๏ธ
See all cards
4.17
โ˜†โ˜…โ˜†โ˜…โ˜†โ˜…โ˜†โ˜…โ˜†โ˜…
124 Reviews

Add your answer:

Earn +20 pts
Q: What is overlapping key DBMS?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is a key in dbms?

A key is an attribute that is used to get data from a table


What ensures the value of the foreign key matches another tables primary key?

It is the DBMS that ensures the value of the foreign key matches another table's primary key when referential integrity constraints are enabled within the DBMS


Why primary key is necessary in dbms?

Primary key is used to avoid redundancy in the database.


What is secondary indexes in dbms?

secondary index is a key which is created other than primary key, to speed up processing.


Could DBMS being the key for the billionaires of the future?

k onda k onda


Why relation have key in DBMS?

A software system that facilitates the creation and maintenance and use of an electronic database


Definition of key in dbms?

It is a pool of data through which data are enter into into the table for data management.


What are highlights of DBMS?

NA_ what are highlights of advanced DBMS what are highlights of advanced DBMS what are highlights of advanced DBMS


What are the types of attributes in dbms?

Types of Attributes in Dbms areKey or non key attributesRequired or optional AttributesSimple or composite AttributesSingle-valued and multi-valued AttributesStored, Coded or derived Attributes


Non-prime attribute in DBMS?

Prime attribute are part of any candidate key. Non-prime attribute are not part of any candidate key.


Is SQL DBMS or RDBMS?

dbms


What are events that have one or more outcomes in common?

They are overlapping events.They are overlapping events.They are overlapping events.They are overlapping events.

People also asked