Database Home Work1-2 Note Ed CREATE TABLE Student VARCHAR(25 NOT NULL, Name CHA

Question

Database Home Work1-2 Note Ed CREATE TABLE Student VARCHAR(25 NOT NULL, Name CHAR (4) PRIMARY KEY, RAM CHAR (3) NOT NULL ajol CREATE TABLE Instructor VARCHAR (25) NOT NULL, Name CHAR (4) PRIMARY KEY, VARCHAR(3) NOT NULL Dept CREATE TABLE Class CHAR (3) NOT NULL, Dept CHAR (3) NOT NULL Course PRIMARY KEY (Dept, Course, Instructor NOT NULL, FOREIGN KEY (Instructor) REFERENCES Instructor (RAM) CREATE TABLE Enrolment Dept CHAR(3 NOT NULL Course CHAR (3) NOT NULL, PRIMARY KEY (Dept, Course, Student FOREIGN KEY (Dept, Course REFERENCES Class (Dept, Course FOREIGN KEY (Student) REFERENCES Student (RAM) HP https:// 92.168.56.10 My Admin php playdb Instructor Studen Create table mysql "Key column does... -E X Certificate er e 92.168.56.101:12322 ertificate Error: Naviga Structure SQL Export More C nsert Error SQL query: CREATE TABLE Class Dep CHAR(3) NOT NULL Course CHAR( 3) NOT NULL PRIMARY KEY Dept, Course, Instructor) FOREIGN KEY (Instructor FK REFERENCES Instructor RAM MySQL said t1072 Key column 'Instructor' doesn't exist in table Run SQL queryl queries on database playdb: Columns. Dept CHAR(3) NOT NULL, A Name Course CHAR(3) NOT NULL PRIMARY KEY (Dept, Course, Instructor, RAM FOREIGN KEY (Instructor FKOREFERENCES Instructor (RAM) Maio CREATE TABLE Enrolment Dept CHAR(3) NOT NULL Course CHAR(3) NOT NULL, PRIMARY KEY (Dept, Course, Student), FOREIGN KEY (Dept. Course) REFERENCES Class (Dept, Course FOREIGN KEY (Student) REFERENCES Student (RAM) answered Nov 6'12 at 19:2 608 PM

Explanation / Answer

In Table class you are setting primary key as Dept,Course and Instructor but Instructor doen't exist in the that table class.So define Instructor in that table

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.