Consider the following two relational database tables to answer all the below (1-4) questions.

Employee Table

Employee_ID Department Employee_Name Salary Date_of_Birth

E-001 ACC Ahmad Ali 800 KD 1/12/1990

E-002 ACC Ayman Salem 600 KD 12/10/1992

E-003 MKT Rana Ahmad 500 KD 12/11/1996

E-005 FIN Dina Khaled 900 KD 1/3/1989

Dependent Table

Dependent_ID Employee_ID Relationship Dependent_Full_Name Date_of_Birth

D-001 E-001 Son Ali Ahmad Ali 1/12/2018

D-007 E-001 Daughter Lama Ahmad Ali 17/5/2019

D-012 E-002 Wife Eman Ahmad 15/4/1994

D-005 E-003 Son Hamad Omar 12/7/2018

1) Identify the primary keys and foreign keys for each table. (30 Points)

2) Create a data dictionary for the Employee table. You should use appropriate data types and lengths. (40 Points)

3) Is it possible to add the below record to the Dependent table? Explain why? (15 Points)

D-008 E-003 Son Khaled Omar 16/8/2021

4) Is it possible to add the below record to the Employee table? Explain why? (15 Points)

E-002 MKT Abdullah Hashem 600 KD True