Question
Attribute Name Sample Value Sample Value Sample Value Sample Value EMP_NUM 1003 1018 1019 1023 EMP_LNAME Willaker Smith McGuire McGuire EMP_EDUCATION BBA, MBA BBA BS,
| Attribute Name | Sample Value | Sample Value | Sample Value | Sample Value |
| EMP_NUM | 1003 | 1018 | 1019 | 1023 |
| EMP_LNAME | Willaker | Smith | McGuire | McGuire |
| EMP_EDUCATION | BBA, MBA | BBA |
| BS, MS, Ph.D. |
| JOB_CLASS | SLS | SLS | JNT | DBA |
| EMP_DEPENDENTS | Gerald (spouse), Mary (daughter), John (son) |
| JoAnne (spouse) | George (spouse) Jill (daughter) |
| DEPT_CODE | MKTG | MKTG | SVC | INFS |
| DEPT_NAME | Marketing | Marketing | General Service | Info. Systems |
| DEPT_MANAGER | Jill H. Martin | Jill H. Martin | Hank B. Jones | Carlos G. Ortez |
| EMP_TITLE | Sales Agent | Sales Agent | Janitor | DB Admin |
| EMP_DOB | 23-Dec-1978 | 28-Mar-1979 | 18-May-1982 | 20-Jul-1959 |
| EMP_HIRE_DATE | 14-Oct-2007 | 15-Jan-2006 | 21-Apr-2013 | 15-Jul-1999 |
| EMP_TRAINING | L1, L2 |
| L1 | L1, L3, L8, L15 |
| EMP_BASE_SALARY | $58,255.00 | $60,500.00 | $49.750.00 | $127,900.00 |
| EMP_COMMISSION_RATE | 0.015 | 0.010 |
|
|
- Is this in 1NF? Why or why not? If it isnt, then what change(s) need to be made to ensure its in 1NF?
- Break this down to 2NF, and eventually 3NF by clearly working through the functional dependencies, partial dependencies and any transient dependencies to arrive at your final tables.
- Show the new tables with at least 3 rows of sample data for each
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
Database In Depth Relational Theory For Practitioners
Authors: C.J. Date
1st Edition
0596100124, 978-0596100124
