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

    Product (상품)