Madang

Tables (3)

Book

  • bookid — NUMBER(2)
  • bookname — VARCHAR2(40)
  • publisher — VARCHAR2(40)
  • price — NUMBER(8)

Customer

  • custid — NUMBER(2)
  • name — VARCHAR2(40)
  • address — VARCHAR2(50)
  • phone — VARCHAR2(20)

Orders

  • custid — NUMBER(2)
  • orderid — NUMBER(2)
  • bookid — NUMBER(2)
  • saleprice — NUMBER(8)
  • orderdate — DATE