Use the Image attached below to answer the questions. (these are two different modules so please provide the answers seperately) so it is easy for me to turn in.
1st.
Individually, using the physical ER model, write the SQL to create the database. Share your physical ER model and the SQL with the group. The SQL should
Create the database
Tables with all columns
Primary and foreign keys
Any unique constrain
——————————————————————————————————————–
2nd question.
Individually, write the SQL to insert the sample data from Module 1.
Identify hypothetical scenarios that would require updates and deletes on your records and write SQL appropriately. For example: phone number for a contact changes; someone is no longer your contact.