Ask a question from expert

Ask now

Normalization Assignment | Partial Dependency

10 Pages1592 Words472 Views
   

Added on  2019-09-22

Normalization Assignment | Partial Dependency

   Added on 2019-09-22

BookmarkShareRelated Documents
Student 29 September, 2016NORMALIZATION ASSIGNMENT
Normalization Assignment | Partial Dependency_1
ContentsTABLE 1..................................................................................................................................................21ST NORMAL FORM............................................................................................................................22ND NORMAL FORM...........................................................................................................................23RD NORMAL FORM............................................................................................................................3BCNF..................................................................................................................................................3TABLE 2..................................................................................................................................................31ST NORMAL FORM............................................................................................................................42ND NORMAL FORM...........................................................................................................................43RD NORMAL FORM............................................................................................................................4BCNF..................................................................................................................................................5TABLE 3..................................................................................................................................................51ST NORMAL FORM............................................................................................................................52ND NORMAL FORM...........................................................................................................................63RD NORMAL FORM............................................................................................................................6BCNF..................................................................................................................................................6TABLE 4..................................................................................................................................................71ST NORMAL FORM............................................................................................................................72ND NORMAL FORM...........................................................................................................................73RD NORMAL FORM............................................................................................................................8BCNF..................................................................................................................................................8
Normalization Assignment | Partial Dependency_2
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) -> Amount1ST NORMAL FORMIn 1st normal 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 1st normal 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$ 2ND NORMAL FORM2nd normal form deals with removing the partial dependency on the primary key. Thus we need to split 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
Normalization Assignment | Partial Dependency_3

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Please normalize the following tables into BCNF.
|5
|290
|692

Normalization Health History Report
|4
|534
|4977

The MyLibrary website
|25
|2842
|492

Database Management System: Case Study of BigM System
|12
|1280
|412

Normalization of Charity and Customer Supply Databases
|6
|818
|226

Assignment On Normalization
|3
|755
|420