1

Tables (3)

BOOK

  • BOOKID — NUMBER(10)
  • BOOKNAME — VARCHAR2(40)
  • PUBLISHER — VARCHAR2(40)
  • PRICE — NUMBER(10)

CUSTOMER

  • CUSTID — NUMBER(10)
  • NAME — VARCHAR2(40)
  • ADDRESS — VARCHAR2(50)
  • PHONE — VARCHAR2(20)

ORDERS

  • ORDERID — NUMBER(10)
  • CUSTID — NUMBER(10)
  • BOOKID — NUMBER(10)
  • SALEPRICE — NUMBER(10)
  • ORDERDATE — DATE