logo

Normalization Assignment | Database Assignment

12 Pages1435 Words681 Views
   

Added on  2020-05-16

Normalization Assignment | Database Assignment

   Added on 2020-05-16

ShareRelated Documents
Running head: DATABASE NORMALIZATIONDatabase NormalizationName of the StudentName of the University
Normalization Assignment | Database Assignment_1
DATABASE NORMALIZATION1Table of ContentsAnswer to Question 1:.....................................................................................................................21.a Normalise the following relation to 3rd normal form, showing all steps and indicate anyassumption you have made..............................................................................................................21.b Normalize the following table to 3rd Normal form...................................................................3Answer to Question 2:.....................................................................................................................5Answer to Question 3:.....................................................................................................................83.a Selecting the Most Appropriate Solution:..................................................................................83.b Identifying the Normal Form:....................................................................................................8Answer to Question 4:.....................................................................................................................9Bibliography:.................................................................................................................................11
Normalization Assignment | Database Assignment_2
DATABASE NORMALIZATION2Answer to Question 1:1.a Normalise the following relation to 3rd normal form, showing all steps andindicate any assumption you have made1st Normal Form:List of attributes are SuppNO, Supp_Name, Supp_Addr, Part_Num, Part_Desc,Unit_Price, Transfer_Price, CategoryNO, CatName. All the attributes are atomic and uniqueidentifier is present in the table.2nd Normal Form:The non-key attributes have to be dependent on the key-attribute.Functional DependenciesSuppNO → (Supp_Name, Supp_Addr)Part_Num → (Part_Desc, Unit_Price, Transfer_Price)CategoryNO → (CatName)Tables:So the normalized tables up to 2nd Normal Form are as following.Supplier (SuppNO, Supp_Name, Supp_Addr)Part (Part_Num, Part_Desc, Unit_Price, Transfer_Price, CategoryNO)
Normalization Assignment | Database Assignment_3
DATABASE NORMALIZATION3Supplier_Part (SuppNO, Part_Num)Category (CategoryNO, CatName)3rd Normal Form:There must not be any transitive dependency in the table. All the tables are in 3rd Normal form as there is no transitive dependency among theattributes.Final Solution:Supplier (SuppNO, Supp_Name, Supp_Addr)Part (Part_Num, Part_Desc, Unit_Price, Transfer_Price, CategoryNO)Supplier_Part (SuppNO, Part_Num)Category (CategoryNO, CatName)1.b Normalize the following table to 3rd Normal form1st Normal Form:List of attributes are INVOICE (Invoice_No, Cust_No, Cust_Name, Cust_Add,Cust_Phone, Inv_Date, (Product_No, Product_Name, CategoryNO, CategoryName, Unit_Price,Sale_Price Qty_Sold )). All the attributes are atomic and unique identifier is present in the table.2nd Normal Form:The non-key attributes have to be dependent on the key-attribute.Functional Dependencies
Normalization Assignment | Database Assignment_4

End of preview

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

Related Documents
Database Schema Design Using Entity-Relationship Approach
|7
|567
|303

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

SQL Server - Assignment PDF
|8
|2026
|28

The MyLibrary website
|25
|2842
|492

Relational Database Design - Assignment
|8
|517
|271

Assignment On Normalization
|3
|755
|420