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.
Important - Read this before proceeding
These instructions reflect a task our writers previously completed for another student. Should you require assistance with the same assignment, please submit your homework details to our writers’ platform. This will ensure you receive an original paper, you can submit as your own. For further guidance, visit our ‘How It Works’ page.