MySQL

/* Query 3.

Write one DDL statement to add a new table Project into exam1. It contains

the following

three columns:

-ProjNum of char(3) type, which is the primary key of Project.

-Pname of varchar(30) type, which could be null. If it has a value,

its first three

characters must be 'UH2' or 'UB5'.

-Budget of smallmoney type, which cannot be null and must have a

minimum of $1,500.

*/

E EEE dbo.ProjAssignment Columns o Pno (PK, char(3), not null) StulD (PK, FK, char(3), not null) E EEE dbo.Student Columns StulD (PK, char(3), not null) GPA (decimal(3,2), nul)