Consider the following two relational database tables to all the below questions.
Employee Table
| Employee ID | Employee Name | Address | Phone Number |
| 100 | Ahmad | 10/125 Egaela | 965224455 |
| 110 | Asem | 25/12 Mahboula | 965344954 |
| 116 | Ali | 20/15 Hawali | 965222656 |
Payment Table
| Payment ID | Employee ID | Overtime Payment | Date of Payment |
| 001 | 110 | 220.00 KD | 17/3/2020 |
| 006 | 116 | 100.00 KD | 18/3/2020 |
| 007 | 110 | 120.00 KD | 20/5/2020 |
1. Identify the Primary keys and foreign keys for each table. (30 points)
1. Create the data dictionary for the Payment table. You should use appropriate data types.
(40 points)
1. Is it possible to add the below record to the Employee table? Explain Why? (15 points)
| 106 | Khalid | 215/10 Hawali | 965255891 |
1. Is it possible to add the below record to the Payment table? Explain Why? (15 points)
| 008 | 115 | 300.00 KD | 18/5/2020 |
