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. Requirements Given the database, in this practice your responsibility is to improve the data modeling by implement the concept of normalization. This can be done by create 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 2 2 West 1 Mr. Williamson John W 1 Access Junction EMP_DOB EMP_age STORE_CODE 21-May- 55 1 64 09-Feb- 51 1 69 2 Access Junction 2 West 2 2 Ms. Ratula Nancy 1 East 3 Ms. Greenboro Lottie R 02-Oct-61 59 2 1 East 4 Mrs. Rumpersfro Jennie S S 49 3 Database 3 Corner 4 Tuple Charge 5 Tuple Charge Database 6 Corner 7 Access Junction 1 East 5 Mr. Smith Robert L L 60 3 1 East 6 Mr. Renselaer Cary A 55 2 2 West 7 Mr. Ogallo Roberto S 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