Chapter 24, Problem 6RE

Explanation of Solution

Create a Car table using SQL commands:

Query 1:

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

/* Create a table named Car*/

CREATE TABLE Car

(

vehicle_ID INTEGER,

manufacturer VARCHAR(40),

model VARCHAR(30),

year INTEGER

);

Explanation:

In the above query,

• A table “Car” has been created using “CREATE TABLE” statement.
• The “Car” table contains four columns, such as, “vehicle_ID”, “manufacturer”, “model”, and “year”.
  • Here, the columns “vehicle_ID” and “year” are “INTEGER” datatype which means it can hold only integer values.
  • Other columns, such as, “manufacturer” and “model” are “VARCHAR” datatype which means it provides character value depending on specified size...