assignment 209
Delp10
MIS300_All_Fa20_Homework-Ch.3.docx
2020 – 2021
Fall 2020
Management Information Systems (MIS300)
Individual Assignment 1 - Homework (10%) - Chapter 3
Start Date: 11 January 2021 - 17:00
Due Date: 17 January 2021 - 23:59
( Please upload your assessment on Moodle using Individual Assignment 1 submission link )
Student Name and ID:
Section:
Faculty Name:
Total Earned Points: /100
Individual Assignment 1-Homework Fall 2020 2
Consider the following two relational database tables to all the below questions.
Employee Table
|
EmployeeID |
EmployeeName |
Address |
Phone |
|
100 |
Ali |
10/125 Egaela |
965224413 |
|
110 |
Samar |
25/12 Mahboula |
965344917 |
|
116 |
Noura |
20/15 Hawali |
965222614 |
Payment Table
|
PaymentID |
EmployeeID |
OvertimePayment |
DateOfPayment |
|
001 |
110 |
220 KD |
17/12/2021 |
|
006 |
116 |
100 KD |
10/01/2021 |
|
007 |
110 |
120 KD |
11/01/2021 |
1) Identify the Primary keys and foreign keys for each table. (30 points)
2) What are the data types for “PaymentID” and “OvertimePayment” in the Payment table? You should use appropriate data type and length. (20 points)
3) Is it possible to add the below record to the Employee table? Explain Why? (15 points)
|
106 |
Khalid |
215/10 Hawali |
965255891 |
4) Is it possible to add the below record to the Employee table? Explain Why? (10 points)
|
116 |
Ali |
215/10 Hawali |
965356841 |
5) Is it possible to add the below record to the Payment table? Explain Why? (10 points)
|
008 |
115 |
300 KD |
13/01/2021 |
6) Is it possible to add the below record to the Payment table? Explain Why? (15 points)
|
009 |
110 |
120 KD |
14/01/2021 |
Individual Assignment 1-Homework Fall 2020 1
