The table structure shown in Table P6.6 contains many unsatisfactory components and characteristics. For example, there are several multivalued attributes, naming conventions are violated, and some attributes are not atomic.

a. Given the structure shown in Table P6.6, write the relational schema and draw its dependency diagram. Label all transitive and/or partial dependencies.
b. Draw the dependency diagrams that are in 3NF.
c. Draw the relational diagram.
d. Draw the Crow’s FootERD.

Transcribed Image Text:

Attribute Name Sample Value Sample Value Sample Value Sample Value 1023 McGuire BS, MS, Ph.D DBA 1003 Willaker BBA, MBA SLS Gerald (spouse), Mary (daughter), John (son) MKTG Marketing Jll H. Martin 1019 EMP NUM EMP LNAME EMP EDUCATION JOB CLASS EMP DEPENDENTS Smith BBA SLS McGuire NT JoAnne (spouse) George (spouse) Jil (daughter) INFS DEPT CODE DEPT NAME DEPT MANAGER MKTG Marketing Jill H. Martin Hank B. Jone SVC General Service | Info. Systems Tix: Carlos G. Ortez EMP TITLE EMP DOB EMP HIRE DATE EMP TRAINING EMP BASE SALARY EMP COMMISSION RATE0:015 Sales Agent 23-Dec-1968 14-Oct-1997 Li,L2 $38,255.00 Sales Agent Janitor 28-Mar-1979 18-May-1982 20-Jul-1959 15-Jan-2006 21-Apr-2003 15-Jul-1999 DB Admin L1 L1 , L3,し8. LIS $30,500.00 19.750.00 0.010 $127,900.00