Consider the following two relational database tables to answer all the below questions. Smart Phone 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 Table 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