Aliendreamer

many to many sql

Jun 10th, 2018
438
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.71 KB | None | 0 0
  1. CREATE TABLE Students(
  2. StudentID INT PRIMARY KEY,
  3. Name NVARCHAR(50)
  4. )
  5.  
  6. CREATE TABLE Exams(
  7. ExamID INT PRIMARY KEY,
  8. Name NVARCHAR(255)
  9. )
  10.  
  11. CREATE TABLE StudentsExams(
  12. StudentID INT,
  13. ExamID INT,
  14. CONSTRAINT PK_StudentID_ExamID PRIMARY KEY(StudentID, ExamID),
  15. CONSTRAINT FK_StudentsExams_Students FOREIGN KEY(StudentID) REFERENCES Students(StudentID),
  16. CONSTRAINT FK_StudentsExams_ExamID FOREIGN KEY(ExamID) REFERENCES Exams(ExamID)
  17. )
  18.  
  19. INSERT INTO Students VALUES
  20.     (1, 'Mila'),
  21.     (2, 'Toni'),
  22.     (3, 'Ron')
  23.  
  24. INSERT INTO Exams VALUES
  25.     (101, 'SpringMVC'),
  26.     (102, 'Neo4j'),
  27.     (103, 'Oracle 11g')
  28.  
  29. INSERT INTO StudentsExams VALUES
  30.   (1, 101),
  31.   (1, 102),
  32.   (2, 101),
  33.   (3, 103),
  34.   (2, 102),
  35.   (2, 103)
Advertisement
Add Comment
Please, Sign In to add comment