Column Name

Primary key

Data type

NOT NULL

AUTO INC

ID

Course code

Course title

Units

Level

Semester

Yes

INTEGER

VARCHAR (45)

VARCHAR (4500)

INTEGER

INTEGER

VARCHAR (45)

Yes

Yes

Yes

Yes

Yes

Yes

Yes