Advertisement
Guest User

Untitled

a guest
Feb 26th, 2015
203
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.80 KB | None | 0 0
  1. USE fakedb;
  2.  
  3. #DROP TABLE Professors, Course, Semester;
  4. #DROP TABLE Teaches;
  5.  
  6. CREATE TABLE Professors (
  7. eid INTEGER AUTO_INCREMENT,
  8. CONSTRAINT ProfKey PRIMARY KEY (eid));
  9.  
  10. CREATE TABLE Course (
  11. courseid INTEGER AUTO_INCREMENT,
  12. CONSTRAINT CourseKey PRIMARY KEY (courseid));
  13.  
  14. CREATE TABLE Teaches (
  15. eid INTEGER,
  16. semesterid CHAR(245),
  17. courseid INTEGER,
  18. CONSTRAINT TeachesKey PRIMARY KEY(eid,semesterid,courseid),
  19. FOREIGN KEY (eid) REFERENCES Professors(eid),
  20. FOREIGN KEY (courseid) REFERENCES Course(courseid)
  21. );
  22.  
  23. SHOW TABLES;
  24.  
  25. INSERT INTO Course(courseid)
  26. VALUES(1343);
  27.  
  28. INSERT INTO Professors(eid)
  29. VALUES(53688);
  30.  
  31. INSERT INTO Teaches(eid, courseid)
  32. VALUES(53688, 1343);
  33.  
  34. INSERT INTO Teaches(eid, semesterid, courseid)
  35. VALUES(53688, 1343);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement