Reference no: EM13500845

Create Tables using SQL DDL

The following questions are based on the Bicycle Rental ERD as shown below:

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)

You are required to submit:

1. The appropriate SQL command which should be copied from your source code in MySQL and pasted into your submission file; and
2. The resultant tables, which must be screenshots to show the change due to the execution of the SQL commands.

Typing or manually drawing the results will NOT be accepted.