Answered step by step
Verified Expert Solution
Question
1 Approved Answer
For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None. FIGURE P3.1 THE
For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None. FIGURE P3.1 THE CHO3 STORECO DATABASE TABLES N 0 6 Mr. N Table name: EMPLOYEE Database name: Cho3_StoreCo EMP_CODE EMP_TITLE EMP_LNAME EMP_FNAME EMP_INITIAL EMP_DOB STORE_CODE 1 Mr Williamson John W 21-May-84 3 2 Ms. Ratula Nancy 09-Feb-89 2 3 Ms. Greenboro Lottie R 02-Oct-81 4 4 Mrs. Rumperstro Jennie S 01-Jun-91 5 5 Mr. Smith Robert 23-Nov-79 3 Renselaer Cary A 25-Dec-85 1 7 Mr. Ogallo Roberto S 31-Jul-82 3 8 Ms. Johnsson Elizabeth 1 10-Sep-88 1 9 Mr Eindsmar Jack w 19-Apr-75 10 Mrs. Jones Rose R 06-Mar-86 4 11 Mr Broderick Tom 21-Oct-92 3 12 Mr. Washington Alan Y 08-Sep-94 13 Mr Smith Peter N 25-Aug-84 3 14 Ms. Smith Sherry H 25-May-86 4 15 Mr. Olenko Howard U 24-May-84 S 16 Mr Archialo Barry V 03-Sep-80 5 17 Ms. Grimaldo Jeanine 12-Nov-90 18 Mr Rosenberg Andrew D 24-Jan-91 19 Mr. Rosten Peter F 03-Oct-88 20 Mr. Mckee Robert s 06-Mar-90 1 21 Ms. Baumann Jennifer A 11-Dec-94 3 ++ + Table name: STORE STORE_CODE STORE_NAME 1 Access Junction 2 Database Corner 3 Tuple Charge 4 Attribute Alley 5 Primary Key Point STORE_YTD_SALES REGION_CODE EMP_CODE 1003455.76 2 8 1421987.39 2 12 986783.22 1 7 944568.56 2 3 2930098.45 15 Table name: REGION REGION_CODE REGION_DESCRIPT 1 East 2 West
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started