SQL:

Thank You.

Part A: 1St Normal Form (1NF Consider the following table: Students: Alpha 080111 072244 Matt Smith 093221 Melinda Black black@usna edu 070112 Tom Johnson Johnson@usna.eduNN204, SI204, IT221 Name Email doe@usna edu smith@usna.edu Courses radePoints 2.3.3 John Doe NN204, SI204, IT221 SM223, EE301 SI204 3 4.2,3 1. Redesign the Students table to be in 1NF, 2NF, & 3NF Part B: Bovce-Codd Normal Form (BCN 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 Customers CustName John Doe Matt Smith ustState PA SC MD MD ustzi 15136 29210 21666 21210 stID CustCi Pittsburgh Columbia 2 3 Melinda Black Stevensville Tom JohnsonAnnapolis Rentals: entallD Title Die Hard The last man standin Wedding Crashers Dodgebal CheckOutDate 3/3/2004 3/3/2004 Director Walter Hill David Dobkin Category Price Old $4.25 Old $4.25 ustl John 3/3/2004 New $5.50 2 2 3/4/2005 Rawson Marshall New $5.50 Thurber James Brooks Robert Zemeckis 2 3 Old $4.25 Old $4.25 Die Hard As good as it ets Forest Gum 2 3 3/4/2005 6/7/2006 John 6/7/2006 Old 4.25