Question

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 | | --------- --------------------- ------ ----- --------- ---------------- Once you have completed these tasks press the Check It! button to have your solution assessed.

Answer 1

Answer:

See Explanation

Explanation:

Given

See attachment 1 for proper table definition

To answer this question, one of the basic sql commands (the "create" command) will be used to create the required table, followed by the fields of the table.

I could not submit my answer directly. So, I added two additional attachments which represent the answer section and the explanation section, respectively.