Tasks:

1.Write the SQL DDL to create the database that contains each of the relations shown in the above ERD. You will need to provide:

1.Your DDL code for each table that you create; (20 marks)

2.A screenshot showing each table that is created. (10 marks)

2.Write and execute SQL definition commands for each of the following queries:

1.Add the attributes Email, Comments and Send Newsletter to the Renters table. Give those attributes an appropriate size and data type (3 marks).

2.Change the attribute Renters.renterDOB from type Varchar(15) to type DATE. (2 marks)

3.Write and execute SQL commands for the following:

1.Add the following customers  to the Renters table. (3 marks)

2.Write a command that will remove the Jones that lives in Orange from the Renters table (2 marks)

Read less