I need help Converting a ER Diagram into mySQL schema. I have made some progress but it is a little overwhelming and was hoping i could get some corrections on my mistakes and maybe go a little further.

this is what i have so far. i don't need the whole thing done for me but pointing out what i did wrong so far and how to fix it would be of great help.

CREATE TABLE Person ( Ssn INTEGER, Fname VARCHAR(20), Lname VARCHAR(20), Sex VARCHAR(20), Address VARCHAR(20), Bdate VARCHAR(20), Primary key (Ssn) );

CREATE TABLE Student ( Ssn INTEGER, Dname VARCHAR(30), Class VARCHAR(30), Foreign Key (Ssn) References Person(Ssn), Foreign Key (Dname) References Department(Dname) ); CREATE TABLE Major ( Ssn INTEGER, Dname VARCHAR(30), Foreign Key (Ssn) references Student(Ssn), Foreign Key (Dname) references Department(Dname)

);

CREATE TABLE GradStudent ( ); CREATE TABLE Degree ( Year DATE, Degree VARCHAR(30), College VARCHAR(30) ); CREATE TABLE Faculty ( Ssn INTEGER, Dname VARCHAR(30), Rank VARCHAR(20), Foffice VARCHAR(20), Fphone VARCHAR(20), Salary VARCHAR(20), Foreign Key (Ssn) References Person(Ssn), Foreign Key (Dname) References Department(Dname) );

CREATE TABLE Department ( Dname VARCHAR(30), Dphone INTEGER, Office VARCHAR(30), Primary Key (Dname) );

CREATE TABLE Grant ( St_date DATE, Title VARCHAR(30), Num INTEGER, Agency VARCHAR(30) );

CREATE TABLE Support ( Start DATE, End DATE, Time INTEGER );

CREATE TABLE Section ( SecNum INTEGER, Year INTEGER, Qtr VARCHAR(20), Primary Key (SecNum) );

CREATE TABLE Course ( Cname VARCHAR(30), Cnum INTEGER, Cdesc VARCHAR(30) );

Address Nairne) PERSON Cuss Police STUOENT Degrees GRAD STUDENT COMMITTE MINOR 2KN Star MAJOR SUPPO End BELON REGISTERED M NSTRUCTORRESEARCHE CHARS TEACH CURRENT SECTION Year Corrent, Risar DEPARTMENT CS Dphane CD COLLEGE COURSE Figure 8.9 Coffie An EER conceptual schems Chisme for a UNNERSITY database