Define the boyce-codd normal form, Database Management System

Assignment Help:

Define the Boyce-Codd Normal Form with instance and also Compare BCNF and 3NF.

Ans: BCNF: For each functional dependency X->Y in a set F of functional dependencies over relation R, either:

Y is a subset of X or,
X is a superkey of R

While

3NF: For each functional dependency X->Y in a set F of functional dependencies over relation R, either:

Y is a subset of X or,
X is a superkey of R, or
Y is a subset of K for few key K of R

a. there is no subset of a key is a key

Related Discussions:- Define the boyce-codd normal form

What is index, What is Index? An index is a physical structure having p...

What is Index? An index is a physical structure having pointers to the data. Indices are created in an existing table to locate rows more quickly and efficiently. It is possibl

Relational algebra and calculus, Q. What is relational algebra and calcul...

Q. What is relational algebra and calculus? Explain the relational algebra operators :- Selection and predicate, set operation, joins and division. Sol. Relational Algebra

Which model is record based logical model, Which model is record based logi...

Which model is record based logical model? Network Modelis basically known as record based logical model.

What is trigger, What is trigger? Triggers are statements that are exe...

What is trigger? Triggers are statements that are executed automatically by the system as the side effect of a modification to the database.

An Apriori algorithm, Submission Requirements All answers must be co...

Submission Requirements All answers must be computer generated (including text and diagrams). The hand-in version must include a header page (or with sufficient space)

In e-r diagram how generalization is represented, In E-R diagram how genera...

In E-R diagram how generalization is represented? in E-R diagram generalization is represented by Triangle shape.

ERD, A student entity type has the following attributes,name..

A student entity type has the following attributes,name..

Relationship for college database, Using the concepts defined previous, we ...

Using the concepts defined previous, we have identified that strong entities in COLLEGE database are FACULTY, STUDENT, COURSE and DEPARTMENT. This database also has one weak entity

Describe the basic steps involved in recovery, Question: One of the tas...

Question: One of the tasks a database management system must perform is to ensure that the data is still intact in the face of software and hardware failure. This task is known

Cascading, what is cascading? what is rollback cascading? please explain in...

what is cascading? what is rollback cascading? please explain in detail

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages