Convert ERDs into relational models:

Be sure to convert each many-to-many relationship into a table.

Do not convert (0,1)-to-many relationship to a table. That is, do not convert optional 1-to-many relationships.

Note: The result of conversion is a collection of CREATE TABLE commands or simplified commands (Please show both ways for learning expirence)

1 Student StdID Name Gender DOB AdmitDate D,C UndStudent Major Minor Class GradStudent Advisor ThesisTitle AsstStatus 2. Project ProiNo ProjName rojectNeeds Specialty as ulFills-SpecNo SpecName ProvidedBy Contractor>o.Supplies ContrNo ContrName