PRIMARY KEY, AUTOINCREMENT, NOT NULL, FOREIGN KEY(deptID) REFERENCES Department(deptID), NOT NULL CHECK (deptName IN ('ICT','History','Mathematics','English')), CHECK (deptBudget >=0 AND deptBudget<=500).

AH DDD SQL Create Table 3

Leaderboard

Visual style

Options

Switch template

Continue editing: ?