과제

테이블 (4)

고객 (Customer)

  • CustomerId (Customer_id) — varchar2(100) — 기본 키 — NOT NULL
  • CustomerName (Customer_name) — varchar2(100)
  • CustomerEmail (Customer_email) — varchar2(100)
  • CustomerTel (Customer_tel) — int

구매 (Buy)

  • BuyId (Buy_id) — varchar2(100) — 기본 키 — NOT NULL
  • CustomerId (Customer_id) — varchar2(100) — 외래 키 → 고객.CustomerId — NOT NULL
  • BookId (book_id) — varchar2(100) — 외래 키 → 책.BookId — NOT NULL

책 (Book)

  • BookId (book_id) — varchar2(100) — 기본 키 — NOT NULL
  • BookName (book_name) — varchar2(100)
  • BookPrice (book_price) — int
  • PublisherId (Publisher_id) — varchar2(100) — 외래 키 → 출판사.PublisherId — NOT NULL

출판사 (Publisher)

  • PublisherId (Publisher_id) — varchar2(100) — 기본 키 — NOT NULL
  • PublisherName (Publisher_name) — varchar2(100)
  • PublisherAdress (Publisher_address) — varchar2(100)