Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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 West

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Data And Databases

Authors: Jeff Mapua

1st Edition

1978502257, 978-1978502253

More Books

Students also viewed these Databases questions

Question

Draw a picture consisting parts of monocot leaf

Answered: 1 week ago

Question

2. Are you varying your pitch (to avoid being monotonous)?

Answered: 1 week ago

Question

3. Are you varying your speaking rate and volume?

Answered: 1 week ago