Consider the following two relational database tables to answer all the below questions.

Smart Phone Table

Sale Table

Phone_ID	Brand	Model	Cost
P-001	Samsung	Galaxy Note 10	180.00 KD
P-002	Samsung	Galaxy S10-Lite	160.00 KD
P-003	Apple	IPhone 12	250.00 KD
P-004	Apple	IPhone 12 Pro	300.00 KD

Sale_ID	Phone_ID	Sale Price	Date of Sale
REC 101	P-003	320.00 KD	4-April-2021
REC 102	P-001	100.00 KD	11-March-2021
REC 103	P-001	120.00 KD	5-March-2021

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

IPhone 12 Pro Max

1-March-2021