Question: Consider the following two relational database tables to answer all the below questions. Smart Phone Table Sale Table Phone ID Brand Model Cost Sale ID

 Consider the following two relational database tables to answer all the

Consider the following two relational database tables to answer all the below questions. Smart Phone Table Sale Table Phone ID Brand Model Cost Sale ID Phone ID Sale Price Date of Sale P-001 Samsung Galaxy Note 10 180.00 KD REC 101 P-003 320.00 KD 4-April-2021 P-002 Samsung Galaxy S10-Lite 160.00 KD REC 102 P-001 100.00 KD 11-March-2021 P-003 Apple IPhone 12 250.00 KD REC 103 P-001 120.00 KD 5-March-2021 P-004 Apple Whone 12 Pro 300.00 KD 1) Identify the primary keys and foreign keys for each table. (30 Points) 2) Create a data dictionary for the Smart Phone table. You should use appropriate data types and lengths. (40 Points) 3) Is it possible to add the below record to the Sale table? Explain why? (15 Points) REC 104 P-004 385.00 KD 20-April-2021 4) Is it possible to add the below record to the Smart Phone table? Explain why? (15 points) P-003 Apple URhone 12 Pro Max 1-March-2021

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!