Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1. List all the names of the entities in this database and their associated attributes. 2. For each table in Figure above, identify its keys
1. List all the names of the entities in this database and their associated attributes.
2. For each table in Figure above, identify its keys and explain the reason for your identification. If a table does not have a particular key, write None and explain.
Table name: EMPLOYEE EMP CODE EMP TITLE EMP LNAME EMP FNAME EMP NTIAL EMP DOB STORE CODE 21-May-64 09-Feb-69 02-Oct-61 01-Jun-71 23-Nov-59 1 Mr 2 Ms 3 Ms 4 Mrs. 5 Mr 6 Mr 7 Mr 8 Ms. 9 Mr 10 Mrs. 11 Mr Wliamson John Ratula Greenboro Lottie Rumpersfro Jennie Smith Renselaer Cary Roberto Elizabeth Jack 31-Jul-62 10-Sep-68 19-Apr-55 06-Mar-66 21-Oct-72 08-Sep-74 Johnssor Eindsmar Broderick Tom Washington Alan Smith Smith Olenko Archialo 25-May-66 24-May-64 14 Ms 15 Mr 16 Mr 17 Ms 18 Mr 19 Mr 20 Mr 21 Ms Sherry Howard Barry 5 Rosenberg Andrew Rosten Mckee Baumann Jennifer 12-Nov-70 24-Jan-71 03-Oct-68 06-Mar-70 11-Dec-74 Peter Table name: STORE STORE-CODE STORE-NAME STORE-YTD-SALES REGION-CODE| EMP-CODE 1 Access Junction 2 Datebase Corner 3 Tuple Charge 003455.76 421987 39 986783.22 944568 56 2930098.45 12 Attribute Alley 5 Primary Key Point 3 15 Table name: REGION REGION-CODE | REGOON-DESCRPT 1 East 2 WestStep 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