데이터입출력구현_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