Question: Consider the following two relational database tables to all the below questions. Employee Table Employeeld EmployeeName Address Phone 100 110 jack marry jacob 10/125 virginia

Consider the following two relational database
Consider the following two relational database
Consider the following two relational database
Consider the following two relational database
Consider the following two relational database tables to all the below questions. Employee Table Employeeld EmployeeName Address Phone 100 110 jack marry jacob 10/125 virginia 25/12 california 20/15 washington +1 (804) 965 - 2244 +1 (800) 965 - 3449 +1 (202)965 - 2226 116 Payment Table PaymentID EmployeeID OvertimePayment DateOfPayment 001 006 007 110 116 110 220 $ 100 $ 120 $ 17/12/2021 10/01/2021 11/01/2021 1) Identify the Primary keys and foreign keys for each table. (30 points) Ac GO tes) Focus Font Voice ti 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 Angelina 215/10 virginia +1 (804) 965 - 5589 Activate W Go to Settings 4) Is it possible to add the below record to the Employee table? Explain why? (10 points) 116 david 215/10 +1 (800) 965 - 3568 california wwwwwww 5) Is it possible to add the below record to the Payment table? Explain why? (10 points) 008 115 300 $ 13/01/2021 Activa 5) Is it possible to add the below record to the Payment table? Explain Why? (10 points) 008 115 300 $ 13/01/2021 6) Is it possible to add the below record to the Payment table? Explain Why? (15 points) 009 110 120 $ 14/01/2021 Activa

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!