Prove that if r is in 3nf and everyn


1.Give an algorithm for testing whether a relation scheme is in BCNF. The algorithm should be polynomial in the size of the set of given FDs. (The size is the sum over all FDs of the number of attributes that appear in the FD.) Is there a polynomial algorithm for testing whether a relation scheme is in 3NF?

2.Prove that, if R is in 3NF and every key is simple, then R is in BCNF.

Solution Preview :

Prepared by a verified Expert
Database Management System: Prove that if r is in 3nf and everyn
Reference No:- TGS0777264

Now Priced at $15 (50% Discount)

Recommended (92%)

Rated (4.4/5)