Question

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

Answer 1

CREATE TABLE `classrooms` (
`id` int(3) unsigned NOT NULL AUTO_INCREMENT,
`room_num` int(4) unsigned DEFAULT NULL,
`course_id` int(3) unsigned DEFAULT NULL,
UNIQUE KEY(`room_num`),
PRIMARY KEY (`id`)
);