Normalization Assignment | Partial Dependency

Added on - 22 Sep 2019

  • 10

    Pages

  • 1592

    Words

  • 296

    Views

  • 0

    Downloads

Trusted by +2 million users,
1000+ happy students everyday
Showing pages 1 to 3 of 10 pages
Student29 September, 2016NORMALIZATION ASSIGNMENT
ContentsTABLE 1..................................................................................................................................................21STNORMAL FORM............................................................................................................................22NDNORMAL FORM...........................................................................................................................23RDNORMAL FORM............................................................................................................................3BCNF..................................................................................................................................................3TABLE 2..................................................................................................................................................31STNORMAL FORM............................................................................................................................42NDNORMAL FORM...........................................................................................................................43RDNORMAL FORM............................................................................................................................4BCNF..................................................................................................................................................5TABLE 3..................................................................................................................................................51STNORMAL FORM............................................................................................................................52NDNORMAL FORM...........................................................................................................................63RDNORMAL FORM............................................................................................................................6BCNF..................................................................................................................................................6TABLE 4..................................................................................................................................................71STNORMAL FORM............................................................................................................................72NDNORMAL FORM...........................................................................................................................73RDNORMAL FORM............................................................................................................................8BCNF..................................................................................................................................................8
TABLE 1(Make, Model) -> LengthBoatName -> (Make, Model, Length, OwnerLastName, OwnerFirstName, OwnerPhone, Address, City,State, ZIP)OwnerPhone -> (OwnerLastName, OwnerFirstName, Address, City, State, ZIP)ZIP -> (City, State)(CharterDate, BoatName, CustomerName) -> Amount1STNORMAL FORMIn 1stnormal the data should be atomic, that is, it is further indivisible. As we see in the table below,the data is atomic and hence already in 1stnormal form.BoatNameMakeModelLengthOwnerLastNameOwnerFirstNameOwnerPhoneAddressCityStateZIPCharterDateCustomerNameAmountFar HorizonCatalinaMorgan38PrincetonDarryl206-543-66772345 15th NESeattleWA9811521-Jun-12Smith, Sally5,000.00$Ebb TideHunter3838TulsaBill503-486-87861324 24th NEPortlandOR9721521-Jun-12Sailors, Mike5,500.00$Far HorizonCatalinaMorgan38PrincetonDarryl206-543-66772345 15th NESeattleWA9811528-Jun-12Tully, Jason5,000.00$Far HorizonCatalinaMorgan38PrincetonDarryl206-543-66772345 15th NESeattleWA981154-Jul-12Atkins, Merle5,000.00$Foreign ShoresHans Christian38 MK II38BerkelyGeorge425-765-44554567 35th WBellevueWA980404-Jul-12Smith, Sally6,000.00$Seafarer VEndeavour3737TulsaBill503-486-87861324 24th NEPortlandOR972154-Jul-12Travis, Chet4,500.00$Seafarer VEndeavour3737TulsaBill503-486-87861324 24th NEPortlandOR9721518-Jul-12Watson, John4,500.00$Midnight on the WaterSabre3232OxfordKelly503-578-75742435 36th SEAstoriaOR9710318-Jul-12Renborn, "Doc"4,000.00$Ebb TideHunter3838TulsaBill503-486-87861324 24th NEPortlandOR9721527-Jul-12Sailors, Mike5,500.00$Foreign ShoresHans Christian38 MK II38BerkelyGeorge425-765-44554567 35th WBellevueWA9804027-Jul-12Tully, Jason6,000.00$2NDNORMAL FORM2ndnormal form deals with removing the partial dependency on the primary key. Thus we need tosplit the table further to remove any partial dependency.Table boatBoatName (primaryKey_) -> Make, Model, LengthTable ownerOwnerPhone (PrimaryKey_) -> (OwnerLastName, OwnerFirstName, Address, City, State, ZIP)Table ZipZIP (PrimaryKey_) -> City, StateTable boat_charter_infoCharterDate, BoatName, CustomerName (PrimaryKey_) -> Amount
desklib-logo
You’re reading a preview
Preview Documents

To View Complete Document

Click the button to download
Subscribe to our plans

Download This Document