Answer in the form of Truth and False

a. Both the tables do not meet referential integrity. b. The EMPLOYEE table meets entity integrity, but the DEPARTMENT table does not.

c. The DEPARTMENT table is at the 2NF.

d. The EMPLOYEE table is at the 2NF.

e. There is insertion anomaly in the DEPARTMENT table.

f. There is update anomaly in the EMPLOYEE anomaly.

MANAGER ID 200 DEPARMENT DEPARTMENT ID DEPARTMENT NAME 10 Administration 20 Marketing 30 Purchasing 40 Human Resources 50 Shipping 201 114 LOCATION_ID 1700 1800 1700 2400 203 121 1500 60 103 1400 70 204 145 2700 2500 80 Public Relations Sales Executive Finance 90 100 1700 1700 100 108 EMPLOYEE HIRE DATE DEPARTMENT ID 90 90 90 60 EMPLOYEE ID FIRST NAME LAST NAME EMAR PHONE NUMBER 100 Steven King SKING 515.1234567 101 Neena Kochar NKOCHHAR 515.123 4568 102 Lex De Haan LDEHAAN 515.123 4569 103 Alexander Hunold AHUNOLD 590.423.4567 104 Bruce Emst BERNST 590.423.4568 105 David Austin DAUSTIN 590.423 4569 106 Vali Pataballa VPATABAL 590.423.4560 107 Diana Lorente DLORENTZ 590.423 5567 108 Nancy Greenberg NGREENBE 515.124.4569 109 Daniel Faviet DFAVIET 5151244169 More than 10 rows available. Increase rows selector to view more rows 60 JOB ID SALARY COMMISSION PCT MANAGER ID AD PRES 24000 AD_VP 17000 100 AD_VP 17000 100 IT PROG 9000 102 IT_PROG 6000 103 IT PROG 4800 103 IT_PROG 4800 103 IT PROG 4200 103 FLMGR 12008 101 FLACCOUNT 9000 108 06/17/2003 0921/2005 01/13/2001 01/03/2006 05/21/2007 06/25/2005 02/05/2006 0207/2007 08/17/2002 08/16/2002 60 60 60 100 100