Consider the following two relational database tables to answer all the below questions. Smart Phone Table Sale Table Phone ID Brand Model Cost Date Sale Sale_ID Phone_ID of Galaxy Note Price P-001...

Extracted text: Consider the following two relational database tables to answer all the below questions. Smart Phone Table Sale Table Phone ID Brand Model Cost Date Sale Sale_ID Phone_ID of Galaxy Note Price P-001 Samsung 180.00 Sale KD 10 REC 320.00 4- P-003 Galaxy S10- April- 2021 101 KD P-002 Samsung 160.00 KD Lite REC 100.00 11- P-001 March- 2021 P-003 Apple IPhone 250.00 102 KD 12 KD P-004 IPhone 300.00 REC 120.00 5- Apple P-001 March- 12 Pro KD 103 KD 2021 1) Identify the primary keys and foreign keys for each table. 2) Create a data dictionary for the Smart Phone table. You should use appropriate data types and lengths.