5. 3. Challenge

A mysql prompt has been opened for you.

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

Create a classroomstable 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 | | room_num | int(4) unsigned | NO | UNI | NULL | | | course_id | int(3) unsigned | YES | MUL | NULL | | +----------+-----------------