Chapter 23, Problem 4RE

Explanation of Solution

Database table design for storing students, classes, professors, and classrooms:

Query 1:

The SQL command to create a table named “Students” with columns is as follows:

/* Create a table named students */

CREATE TABLE Students

(

Student_ID INTEGER,

Student_Name VARCHAR(50)

);

Explanation:

In the above query,

• A table “Students” has been created using “CREATE TABLE” statement.
• The “Students” table contains two columns:
  • The “Student_ID” column is a unique ID for identifying each student; the datatype of this column is “INTEGER”.
  • The “Student_Name” column is used to save the names of all students in the classroom; the datatype of this column is “VARCHAR” and the size is “50”.

Query 2:

The SQL command to create a table named “Classes” with columns is as follows:

/* Create a table named Classes */

CREATE TABLE Classes

(

Class_ID INTEGER,

Classroom_ID INTEGER,

Professor_ID INTEGER,

Title VARCHAR(60)

);

Explanation:

In the above query,

• A table “Classes” has been created using “CREATE TABLE” statement.
• The “Classes” table contains four columns, such as, “Class_ID”, “Classroom_ID”, “Professor_ID” and “Title”.
  • Here, the columns “Class_ID”, “Classroom_ID”, and “Professor_ID” are “INTEGER” datatype which means it can hold only integer values.
  • Other column like “Title” is “VARCHAR” datatype which means it provides character value depending on specified size.

Query 3:

The SQL command to create a table named “Professors” with columns is as follows:

/* Create a table named Professors */

CREATE TABLE Professors

(

Professor_ID INTEGER,

Professor_Name VARCHAR(50)

);

Explanation:

In the above query,

• A table “Professors” has been created using “CREATE TABLE” statement...