Assignment 4 (10 points).
Added on -2019-09-16
| 2 pages
| 288 words
| 116 views
Trusted by 2+ million users,
1000+ happy students everyday
Showing pages 1 to 1 of 2 pages
Assignment 4 (10 points)Your Name: Srikar ChintalaYour ZID: Z1788560(1)State the normal form and then normalize. Primary key is ProductIDProductIDProductNameStateCodePriceStateTaxPercent1TelevisionIL5008.52CameraIN20073CameraIL3008.54PhoneIN65075Dish WasherWA45006DryerWA45007TelevisionIN4807 (2) State the normal form and then normalize. Primary Key is (title, year)(3) State thenormal form andthen normalize.Primary key is SupplierIDSupplierIDSupplierNameLocationPartSuppliedPrice1ABC IncIllinoisValve852ABC IncIndianaValve853Cummins IncIndianaPump1854Cummins IncWashingtonValve855ABC IncIllinoisPump1856Europump IncOklahomaPump185titleyearlengthfilmTypestudioNamestarNameStar Wars1977124colorFoxFisherStar Wars1977124colorFoxHamillStar Wars1977124colorFoxFordMighty Ducks1991104colorDisneyEstevesWayne’sWorld199295colorParamountCarveyWayne’sWorld199295colorParamountMeyers
Found this document preview useful?
You are reading a preview
Upload your documents to download
or
Become a Desklib member to get accesss
Paid Plans
Free Plan
Single Unlock
Monthly Plan
Yearly Plan