Question
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
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