과제
테이블 (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)