departmentERD
Tables (7)
Address (Untitled4)
- zipcode (Key) — date(5) — Primary key — NOT NULL
- Do (Field) — char(30)
- City (Field2) — char(10)
- gu (Field3) — char(10)
- bungi (Field4) — char(10)
ClassRoom (Untitled6)
- room (Key) — char(5) — Primary key — NOT NULL
- zipcode (Key2) — date(5) — Foreign key → Address.zipcode — NOT NULL
Course (Untitled3)
- cid (Key) — char(6) — Primary key — NOT NULL
- name (Field) — varchar(20)
- grade (Field2) — int
Lab (Untitled5)
- Lname (Key) — varchar(20) — Primary key — NOT NULL
- roomNo (Field) — char(5)
- pid (Key2) — char(4) — Foreign key → Professor.pid — NOT NULL
- zipcode (Key3) — date(5) — Foreign key → Address.zipcode — NOT NULL
Professor (Untitled2)
- pid (Key) — char(4) — Primary key — NOT NULL
- room (Field) — char(5)
- phone (Field2) — char(11)
- zipcode (Key2) — date(5) — Foreign key → Address.zipcode — NOT NULL
Student (Untitled)
- sid (Key) — char(8) — Primary key — NOT NULL
- name (Field) — char(3)
- admission (Field2) — date
- graduate_date (Field3) — date
- gender (Field4) — char(1)
- phone (Field5) — char(11)
- Lname (Key2) — varchar(20) — Foreign key → Lab.Lname — NOT NULL
- zipcode (Key3) — date(5) — Foreign key → Address.zipcode — NOT NULL
Sugang (Untitled7)
- sid (Key) — char(8) — Foreign key → Student.sid — NOT NULL
- cid (Key2) — char(6) — Foreign key → Course.cid — NOT NULL
- Open_date (Field) — date
- score (Field2) — char(2)
- pid (Key3) — char(4) — Foreign key → Professor.pid — NOT NULL
- room (Key4) — char(5) — Foreign key → ClassRoom.room — NOT NULL