Question: Use the database below to answer Database name: Ch03_StoreCo EMP Table name: EMPLOYEE EMP CODE EMP TITLE EMP STORE CODE 1 M 2 Ms 21-May-6

Use the database below to answer Database name: Ch03_StoreCo EMP Table name: EMPLOYEE EMP CODE EMP TITLE EMP STORE CODE 1 M 2 Ms 21-May-6 09-Feb-69 Greenboro Lotie 4 Ms 5 M 6 M 7 M Rumperstro Jernie Renselser Cary JohnssonEzabeth 01-Jun-71 31-14-62 19-Apr-55 21-Od-72 9 M 10 Ms 11 M 12 M 13 M 14 Ms 15 M 16 M 7 Ms 18 M 19 M 20 M 21 Ms Broderick Tom Washington l 12-Nov-70 Roserberg Andrew 06-Ma-70 11-Dec-74 Table name: STORE STORE CODE STORE STORE YTD REGION CODEEMP CODE 1000455 76 421987 39 966783 22 944568 56 2930098 45 1 Access Junction Datsbase Corne 3 Tuple Charge 4 ASrbute Aley 5 Primary Key Poirt 12 Table name: REGION 1 East (Questions) 1. For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None in the space provided 2. Create the ERD to show the relationship between STORE and REGION
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
