5. 2. Challenge

Defining the reference table

A mysql prompt has been opened for you.

Using the college database, complete the following tasks (use either a single-line or a multi-line SQL statement):

Create a courses table with this definition (try using a multi-line SQL statement):

+---------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------+---------------------+------+-----+---------+----------------+ | id | int(3) unsigned | NO | PRI | NULL | auto_increment | | title | varchar(255) | NO | UNI | NULL | | | credits | tinyint(2) unsigned | NO | | 1 | | +---------+---------------------+------+-----+---------+----------------+