2

Tables (4)

book (newbook)

  • bookid — INTEGER — Primary key — NOT NULL
  • bookname — VARCHAR(30)
  • price — INTEGER
  • publisher_name — varchar(40) — Foreign key → publisher.publisher_name — NOT NULL

customer (Newcustomer)

  • custid — integer — Primary key — NOT NULL
  • cust_name — varchar(30)
  • address — varchar(60)
  • phone — varchar(25)

order (neworder)

  • orderid — INTEGER — Primary key — NOT NULL
  • order_date — DATE
  • Sale_price (sale_price) — INTEGER
  • custid — integer — Foreign key → book.bookid — NOT NULL
  • bookid — integer — Foreign key → customer.custid — NOT NULL

publisher (newPublisher)

  • publisher_name — VARCHAR(30) — Primary key — NOT NULL
  • contact_name — VARCHAR30)
  • contact_no — INTEGER