How do I create table called 1 Engineers that contains

How do I create table called 1 Engineers that contains, Primary key:EID
columns: Lastname, Firstname, Email, Graddate using SQL ?

2 Table Faculty, Primary key: FID,

columns: Lastname, Firstname, Email, Hiredate

3 Table Classes, Primary key: CID

columns: Subject (e.g. SDEV), Catalognbr (e.g. 350), Title (e.g. Database Security)

Also, another table called

4 Classenrollments, with primary key: EnID,

foreign key: CID Cfrom classes), FID (from Faculty), EID (from Engineers) ?

15 Engineers

3 Faculty

3 Classes

15 ClassEnrollments

Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"