SQL

using CREATE TABLE make a table called classes with the columns dep, class, name, cred, semester, and year. Type 'TEXT' is best for all of the text columns. The type 'NUMERIC(3,1)' should be used for the cred column.

in the CREATE TABLE statement, include these constraints and defaults:

Add a check constraint on semester to be one of Winter, Fall, or Summer

on dep and class Define a primary key

name and cred dont allow nulls

add a default on year that makes it be the current year

for the name columns issue an ALTER TABLE statement to ensure that it is UNIQUE.