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