Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Employee (Note: Attribute names are abbreviated to fit into the table columns) Emp_ID E_LName E_Fname E_St_Addr E_St_Nm E_City E509 Jones George 123 West Elm Greeley

Employee (Note: Attribute names are abbreviated to fit into the table columns)

Emp_ID

E_LName

E_Fname

E_St_Addr

E_St_Nm

E_City

E509

Jones

George

123

West Elm

Greeley

E302

Hayes

Marilyn

456

S Main

Newark

E244

Walker

Shondra

789

35th Ave

San Diego

E651

James

LaBron

321

123rd Street

Cleveland

E804

Your_Last_Name

Your_First_Name

Your_St_addr

Your_St_Num

Your_City

E002

Instr_Last_Name

Instr_First_Name

453

Spruce St

Denver

Employee (Cont.)

E_St

E_Zip

E_Job_Cd

E_Pay_Rate

E_St_Date

Warehouse_ID

CO

81001

100

45000

05/20/2020

10

NJ

12003

200

95000

04/15/2017

10

CA

90121

400

85000

08/09/2015

20

OH

34508

400

120000

11/11/2020

20

Your_St

Your_Zip

400

105000

Todays_Date

10

CO

80230

600

105000

1/15/2011

20

Complete the following tasks:

An appropriate and detailed list of tables, attributes and constraints based on the provided requirements. There are no errors.

A thorough and detailed list of all tables linked by one-to-many relationships. There are no errors.

A thorough, detailed description of how the attributes meet the data requirements. There are no errors.

A thorough and detailed explanation of why each table is in 3NF. Several sources and examples support thinking.

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_2

Step: 3

blur-text-image_3

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

Database Design Application And Administration

Authors: Michael Mannino, Michael V. Mannino

2nd Edition

0072880678, 9780072880670

More Books

Students also viewed these Databases questions