Question: The table structure below contains many unsatisfactory components and characteristics. For example, there are several multivalued attributes and some attributes are not atomic. Table: Sample
The table structure below contains many unsatisfactory components and characteristics. For example, there are several multivalued attributes and some attributes are not atomic.
Table: Sample EMPLOYEE Records
| 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 |
| JOB_TITLE | Sales Agent | Sales Agent | Janitor | DB Admin |
| EMP_DOB | 23-Dec-1968 | 28-Mar-1979 | 18-May-1982 | 20-Jul-1959 |
| EMP_HIRE_DATE | 14-Oct-1997 | 15-Jan-2006 | 21-Apr-2003 | 15-Jul-1999 |
| EMP_TRAINING | L1, L2 |
| L1 | L1, L3, L8, L15 |
| EMP_SALARY | $38,255.00 | $30,500.00 | $19.750.00 | $127,900.00 |
b. Draw the dependency diagrams that are in 3NF. (Hint: You might have to create some new tables and columns. Also make sure that the new dependency diagrams contain attributes that meet proper design criteria, e.g., there are no multivalued attributes)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
