Chapter $11$ Homework

How to create and maintain databases, tables, and sequences with SQL statements

Before you start the exercises:

For each exercise you are expected to provide one or more screen captures, immediately below the exercise question, that show successful completion of the requirement. Unless otherwise stated, use the explicit join syntax.

Exercises

Write a script that implements the following design in a database named MyBookDB:

In the Downloads table, the UserID and BookID columns are the foreign keys.

Include statements to create and select the database.

Define the BookName column so its value is unique.

Include indexes for the two foreign keys.