Hit The Order Button To Order A **Custom Paper**

>> CLICK HERE TO ORDER 100% ORIGINAL PAPERS FROM AustralianExpertWriters.com <<

30 Jul
2020

Create the data dictionary for the Payment table. You should use appropriate data types.

Category:ACADEMICIAN

SOLUTION AT Australian Expert Writers

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

Order from Australian Expert Writers
Best Australian Academic Writers

QUALITY: 100% ORIGINAL PAPERNO PLAGIARISM – CUSTOM PAPER

READ ALSO  Descriptive statistics and inferential statistics AssignmentTutorOnline | Good Grade Guarantee!