Advertisement
Sirallens

Untitled

Nov 1st, 2017
135
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.26 KB | None | 0 0
  1. CREATE TABLE students (
  2. sid CHAR(20),
  3. name CHAR(30),
  4. login CHAR(20),
  5. age INTEGER,
  6. gpa REAL,
  7. PRIMARY KEY(sid)
  8. );
  9. CREATE TABLE enrolled (
  10. studid CHAR(20),
  11. cid CHAR(20),
  12. grade CHAR(10),
  13. PRIMARY KEY (studid,cid),
  14. FOREIGN KEY (studid) REFERENCES students
  15. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement