malook 4
Weekly Assessment 3 Spring-2 2020
Management Information Systems MIS300 – Spring-2 2020
Weekly Assessment 3 (15%) - Chapter 3
Start Date: 16 July 2020- 8:00 pm
Due Date: 21 July 2020- 11:59 pm
(Note: please upload your answer on Moodle using weekly assessment 3 submission Link)
Student Name:
Student ID:
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 |