departmentERD
Tables (5)
Lab (Untitled5)
- Lname (Key) — varchar(20) — Primary key — NOT NULL
- room (Field) — char(5)
- Field2
course (Untitled3)
- cid (Key) — char(6) — Primary key — NOT NULL
- name (Field) — varchar(20)
- grade (Field2) — int
office (Untitled4)
- oid (Key) — char(5) — Primary key — NOT NULL
- name (Field) — varchar(20)
- Field2
porfessor (Untitled2)
- pid (Key) — char(4) — Primary key — NOT NULL
- room (Field) — char(5)
- phone (Field2) — char(11)
student (Untitled)
- sid — char(8) — Primary key — NOT NULL
- name — char(3)
- admission — date
- graduate_date — date
- gender — char(1)
- Field (phone) — char(11)
- Field (zipcode) — char(5)
- Field (LName) — varchar(20)
- Field