Please create scripts in SMSS and submit in .sql file .

For Part A, name the tables OWN, OWN_PROP, EMP, SRV, and PROP_SRV respectively

For Part B and C, use the table naming as illustrated in the textbook.

Sample Data for Garden Glory OWNER Table FIGURE 3-39 Sample Data for Garden Glory OWNED_PROPERTY Table Sample Data for Garden Glory EMPLOYEE Table Sample Data for Garden Glory GG_SERVICE Table FIGURE 342 Use data types consistent with the DBMS you are using. If you are not using an actual DBMS, consistently represent data types using either the MySQL, Microsoft SQL Server, or Oracle Database data types shown in Figure 3-5. For each SQL statement you write, show the results based on your data. Write SQL statements and answer questions for this database as follows: A. Write CREATE TABLE statements for each of these tables. Omit foreign keys. B. Write foreign key constraints for the relationships in each of these tables. Make your own assumptions regarding cascading updates and deletions and justify those assumptions. (Hint: You can combine the SQL for your answers to parts A and B. C. Write SQL statements to insert the data into each of the five Garden Glory database tables. Assume that any surrogate key value will be supplied by the DBMS. Use the data in Figure 3-38, Figure 3-39, Figure 3-40, Figure 3-41, and Figure 3-42. Sample Data for Garden Glory OWNER Table FIGURE 3-39 Sample Data for Garden Glory OWNED_PROPERTY Table Sample Data for Garden Glory EMPLOYEE Table Sample Data for Garden Glory GG_SERVICE Table FIGURE 342 Use data types consistent with the DBMS you are using. If you are not using an actual DBMS, consistently represent data types using either the MySQL, Microsoft SQL Server, or Oracle Database data types shown in Figure 3-5. For each SQL statement you write, show the results based on your data. Write SQL statements and answer questions for this database as follows: A. Write CREATE TABLE statements for each of these tables. Omit foreign keys. B. Write foreign key constraints for the relationships in each of these tables. Make your own assumptions regarding cascading updates and deletions and justify those assumptions. (Hint: You can combine the SQL for your answers to parts A and B. C. Write SQL statements to insert the data into each of the five Garden Glory database tables. Assume that any surrogate key value will be supplied by the DBMS. Use the data in Figure 3-38, Figure 3-39, Figure 3-40, Figure 3-41, and Figure 3-42