Question

Write the SQL statement to create a five-field table to contain sample student information. The constraints that need to be satisfied by the attributes of this table are as follows:

1. the attribute First_Name is mandatory and can have up to 16 characters,
2. the attribute Last_Name is mandatory and can have up to 16 characters,
3. the attribute Date_Of_Birth is of type date is required,
4. the StarID field identifies each student and is 8 characters long
5. the GPA field is numeric that can be 2 digits with 1 decimal place.

Be sure to select column names, types, and constraints that are appropriate based on the description above.

Answer 1

CREATE TABLE Student_Information (
First_Name VARCHAR(16) NOT NULL,
Last_Name VARCHAR(16) NOT NULL,
Date_Of_Birth DATE,
StarID VARCHAR(8) PRIMARY KEY,
GPA FLOAT(3,1)
);

NOTE:-

Since StarID field identifies each student uniquely so it is a primary key of the Table.

Float(3,1) means 2 digit before decimal and 1 digit after decimal.

VARCHAR(16) means A variable-length string up to 16 character.

DATE Format: YYYY-MM-DD