Q1. Consider the following two relational database tables to answer all the below (a-c) questions. (40 points) Phone Table Phone ID Brand Model 001 Samsung Galaxy S5 002 Samsung K Zoom 003 Iphone 11 Iphone 12 Cost 180.00 160.00 250.00 450.00 Sale Table 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 004 a) Identify the primary keys and foreign keys for each table. (10 points) b) Create a data dictionary for the Phone table. You should use appropriate data types. (20 points) c) Is it possible to add the below record to the Sale table? Explain why? (10 points) 102 007 120.00 16-June-20