Learning Outcomes

1. Learn about data Normalization. 2. Demonstrate the differences between different normalization forms.

description :

The newly established STORECO inc. stored the data about its employees and stores in a Database with single table (provided in the last page of this document). The database involves data anomalies and requires normalization.

Given the database, in this practice, your responsibility is to improve the data modeling by implementing the concept of normalization. This can be done by creating a database whose tables are at least in 3NF.

The requirements are: A. Create a normalized data model (in the 3NF). B. For each model describe the PKs and their dependencies.

STORECO Inc. database ID STORE_Name Region_Code Region_Description EMP_CODE EMP_TITLE EMP_LNAME EMP_FNAME EMP_INITIAL 1 Access Junction 2 2 West 1 Mr. Williamson John w W EMP_DOB EMP_age STORE_CODE 21-May- 55 1 64 09-Feb- 51 1 69 2 Access Junction 2 2 West 2 2 Ms. Ratula Nancy 3 1 East 3 Ms. Greenboro Lottie R 02-Oct-61 59 2 Database Corner Tuple Charge 4 1 East 4 Mrs. Rumpersfro Jennie S 49 3 5 Tuple Charge 1 1 East 5 Mr. Smith Robert L 60 3 1 East 6 Mr. Renselaer Cary A 55 2 Database 6 Corner 7 Access Junction 2 West 7 7 Mr. Ogallo Roberto S 58 1 01-Jun-71 23-Nov- 59 25-Dec- 65 31-Jul-62 10-Sep- 68 19-Apr- 55 06-Mar- 66 8 Access Junction 2 West 8 Ms. Johnsson Elizabeth 1 52 1 9 Tuple Charge 1 East 9 Mr. Eindsmar Jack w 65 3 10 Database Corner 1 East 10 Mrs. Jones Rose R 54 2