STUDENT ADVISOR PK StudentlD PK AdvisorlD StuName AdvName St

STUDENT ADVISOR PK StudentlD PK AdvisorlD StuName AdvName StuMajor AdvOffice StuPhone AdvPhone

Solution

CREATE TABLE Student
(
StudentID int NOT NULL,
StuName varchar NOT NULL,
StuMajor char,
StuPhone int

PRIMARY KEY (StudentID),
FOREIGN KEY (P_Id) REFERENCES Persons(P_Id)
)

CREATE TABLE Advisor
(
AdvisorID int NOT NULL,
AdvName varchar NOT NULL,
AdvOffice varchar,
AdvPhone int

PRIMARY KEY (AdvisorID),
FOREIGN KEY (P_Id) REFERENCES Persons(P_Id)
)

CREATE TABLE Advisor_student(

RelID int NOT NULL,

PRIMARY KEY (RelID),

FOREIGN KEY (stdID) REFERENCES Student(StudentID),

FOREIGN KEY (AdvID) REFERENCES Advisor(AdvisorID)

)