Improving Electronic Store Database Design Essay

astir(p) Electronic Store Database Design - Essay ExampleImproving 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 pull through 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 dissimilar table is created for every tick off 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 r elated using a foreign key. In trey normal form, all fields depend on the primary key otherwise they should be eliminated.