Q1. Consider the following two relational database tables to answer all the below (a-c) questions.

Phone Table Sale Table

Phone ID Brand Model Cost

001 Samsung Galaxy S5 180.00

002 Samsung K Zoom 160.00

003 Iphone 11 250.00

004 Iphone 12 450.00

Sale ID Phone ID Sale Price Date of Sale 101 003 220.00 4-August-20 102 002 100.00 11-July-20 103 001 120.00 5-August-20

a) Identify the primary keys and foreign keys for each table.

b) Create a data dictionary for the Phone table. You should use appropriate data types.

c) Is it possible to add the below record to the Sale table? Explain why?

102 007 120.00 16-June-20

please make sure the answer is correct 100%