데이터입출력구현_200908_요구사항분석서
테이블 (3)
BOOK (Untitled)
- Key (Book_No) — 기본 키 — NOT NULL
- Field (Book_Name)
- Field2 (Book_Writer)
- Field3 (Book_Price)
- Field4 (publisher)
- Field5 (genre)
CUSTOMER (Untitled2)
- Key (User_Id) — 기본 키 — NOT NULL
- Field (User_No)
- Field2 (User_Name)
- Field3 (User_Age)
- Field4 (Addr)
- Field (Gender)
- Field2 (Enroll_Date)
LIBRARY (Untitled3)
- Key (Lease_No) — 기본 키 — NOT NULL
- Field (Lease_Date)
- Field4 (Return_Date)
- Key (Book_No) — 외래 키 → BOOK.Key — NOT NULL
- Key (User_Id) — 외래 키 → CUSTOMER.Key — NOT NULL