ERD
Tables (5)
Customer (고객)
Dept (부서)
- DeptID (Key) — varchar(5) — Primary key — NOT NULL
- Field
Employe (사원)
- EmpNo (사원번호) — not null — Primary key — NOT NULL
- DeptID (Key) — varchar(5) — Foreign key → Dept.DeptID — NOT NULL
- Name (이름) — not null
- Sex (성별)
Order (주문)
- Key — Primary key — NOT NULL
- Field