SQL:

Decompose the Rentals table into BCNF (Give the table name, column names, primary keys and foreign keys for each of the resulting tables). Rentals: entallD Title Die Hard The last man standin Wedding Crashers Dodgebal Director Walter Hill David Dobkin, CheckOutDate 3/3/2004 3/3/2004 Category Price Old $4.25 Old $4.25 ustl John 3/3/2004 Ne $5.50 2 2 3/4/2005 Rawson MarshalNew $5.50 Thurber James Brooks Robert Zemeckis Old $4.25 Old $4.25 2 Die Hard As good as it ets Forest Gum 2 3/4/2005 John 6/7/2006 6/7/2006 The primary key of the Customers table is CustID. The primary key of the Rentals table is 4 Old $4.25 the composite key (RentallD, Title) For a table to be in Boyce-Codd normal form, all the determinants of the functional dependencies in that table must be candidate keys (either primary key or alternate key) Below are two tables created for a video store Decompose the Rentals table into BCNF (Give the table name, column names, primary keys and foreign keys for each of the resulting tables). Rentals: entallD Title Die Hard The last man standin Wedding Crashers Dodgebal Director Walter Hill David Dobkin, CheckOutDate 3/3/2004 3/3/2004 Category Price Old $4.25 Old $4.25 ustl John 3/3/2004 Ne $5.50 2 2 3/4/2005 Rawson MarshalNew $5.50 Thurber James Brooks Robert Zemeckis Old $4.25 Old $4.25 2 Die Hard As good as it ets Forest Gum 2 3/4/2005 John 6/7/2006 6/7/2006 The primary key of the Customers table is CustID. The primary key of the Rentals table is 4 Old $4.25 the composite key (RentallD, Title) For a table to be in Boyce-Codd normal form, all the determinants of the functional dependencies in that table must be candidate keys (either primary key or alternate key) Below are two tables created for a video store