primary and secondary keys
for the attached unfinished
physical database design.
Ensure your submission addresses each of these components:
Explain the process to create a physical database.
Body: The attached DDL statements are used to create the physical database “State_Capitals” that consists of four tables: “Country,” “Region,” “State,” and “Capital.” However, the statements to create the appropriate primary and foreign keys for the tables are missing.
Complete the “State_Capitals” physical database by creating the appropriate primary and foreign keys for them.
Summarize how DDL is used to create a physical database objects
and the use of primary and foreign keys in relational database.