Question

Create the following table.

Students

Column name	Data type	Size	Constraints
Adno	Integer	3	Primary key
Name	Varchar	20
Average	Integer	3
Sex	Char	1
Scode	Integer	4

Answer 1

CREATE TABLE Students (
    Adno INTEGER(3) PRIMARY KEY,
    Name VARCHAR(20),
    Average INTEGER(3),
    Sex CHAR(1),
    Scode INTEGER(4)
);