Tuesday, August 13, 2019
Improving Electronic Store Database Design Essay
Improving Electronic Store Database Design - Essay Example Improving Database Design through Normalization The tables are already in 1, 2, and 3rd Normal Forms. They are as follows: Customer Table (Customer ID, Customer Name, Address, Residence) Sales Order Table (Sale ID, Date, Units Sold, Customer ID, Social_Security_Number) Employees Table (Social_ Security_ Number, First_Name, Last_Name, Address, City, State, Zip_Code, Birth_Date, Full_Time, Part_Time, Salary, Date_Hire) The tables exist in the three normalization forms because they meet the criteria to existing in those states. That is to say, in the first normal form, there is no more than one row of data that has a repeating group of information (Date, 2005). A different table is created for every set of data that is related as well as identifying every set of related data with a primary key. In the second normal form, sets of values containing multiple records should exist in varied tables. The tables are then related using a foreign key. In third normal form, all fields depend on th e primary key otherwise they should be eliminated.