cs348/a2/database.sql

 DROP TABLE student;
 DROP TABLE faculty;
 DROP TABLE class;
 DROP TABLE enrolled;
--
CREATE TABLE student
  (
     snum     DECIMAL(9, 0) NOT NULL PRIMARY KEY,
     sname    VARCHAR(30),
     major    VARCHAR(25),
     standing VARCHAR(2),
     age      DECIMAL(3, 0)
  );

CREATE TABLE faculty
  (
     fid    DECIMAL(9, 0) NOT NULL PRIMARY KEY,
     fname  VARCHAR(30),
     deptid DECIMAL(2, 0)
  );

CREATE TABLE class
  (
     name     VARCHAR(40) NOT NULL PRIMARY KEY,
     meets_at VARCHAR(20),
     room     VARCHAR(10),
     fid      DECIMAL(9, 0),
     FOREIGN KEY(fid) REFERENCES faculty
  );

CREATE TABLE enrolled
  (
     snum  DECIMAL(9, 0) NOT NULL,
     cname VARCHAR(40) NOT NULL,
     PRIMARY KEY(snum, cname),
     FOREIGN KEY(snum) REFERENCES student,
     FOREIGN KEY(cname) REFERENCES class(name)
  );
--
import from student.txt of del insert into student;
import from faculty.txt of del insert into faculty;
import from class.txt of del insert into class;
import from enrolled.txt of del insert into enrolled;