Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE students (
- sid CHAR(20),
- name CHAR(30),
- login CHAR(20),
- age INTEGER,
- gpa REAL,
- PRIMARY KEY(sid)
- );
- CREATE TABLE enrolled (
- studid CHAR(20),
- cid CHAR(20),
- grade CHAR(10),
- PRIMARY KEY (studid,cid),
- FOREIGN KEY (studid) REFERENCES students
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement