Question
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
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 databaseStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started