dd
Tables (4)
Course
- Cnum — CHAR(10) — Primary key — NOT NULL
- Cname — VARCHAR(50) — NOT NULL
- Cdesc — TEXT
- Credit — INT
- Level — VARCHAR(10)
- Cdept — CHAR(10)
Department
- Dcode — CHAR(10) — Primary key — NOT NULL
- Dname — VARCHAR(50) — NOT NULL
- Doffice — VARCHAR(20)
- Dphone — VARCHAR(15)
- College — VARCHAR(50)
Section
- Sec_course — CHAR(10)
- Sec_num — INT
- Semester — VARCHAR(10)
- Year — INT
- Instructor_name — VARCHAR(50)
Student
- Ssn — CHAR(11) — Primary key — NOT NULL
- Sname — VARCHAR(50) — NOT NULL
- Snum — CHAR(10) — NOT NULL
- Sc_addr — VARCHAR(100)
- Sc_phone — VARCHAR(15)
- Sp_addr — VARCHAR(100)
- Sp_phone — VARCHAR(15)
- Bdate — DATE
- Sex — CHAR(1)
- Class — VARCHAR(20)
- Major_code — CHAR(10)
- Minor_code — CHAR(10)
- Prog — VARCHAR(10)