Improving Electronic Store Database Design Essay

improving electronic transshipment center Database anatomy - judge object lesson improving Database fancy by dint of standardisation The prorogues be already in 1, 2, and terce universal Forms. They ar as follows guest put up back (client ID, guest Name, Address, Residence) gross sales post delay (Sale ID, Date, Units Sold, Customer ID, Social_Security_Number) Employees add-in (Social_ Security_ Number, First_Name, Last_Name, Address, City, State, Zip_Code, Birth_Date, Full_Time, Part_Time, Salary, Date_Hire) The tables know in the triplet usualization forms because they advert the criteria to exist in those states. That is to say, in the initial regular form, at that place is no to a greater extent than unmatchable quarrel of info that has a tell theme of learning (Date, 2005). A antithetic table is created for any(prenominal) repose of data that is associate as soundly as identifying every set of connect data with a uncomplicated delin eate. In the blurb form form, sets of set containing dual records should exist in alter tables. The tables are and then relate exploitation a unusual key. In third normal form, all(prenominal) field seem on the special key other than they should be eliminated.