Bookstore

Tables (4)

Book (NewBook)

  • bookid — Primary key — NOT NULL
  • bookname
  • price
  • publisher_name — Foreign key → Publisher.publisher_name — NOT NULL

Customer (NewCustomer)

  • custid — Primary key — NOT NULL
  • cust_name
  • Sale_price
  • orderid — Foreign key → Order.orderid — NOT NULL
  • bookid — Foreign key → Book.bookid — NOT NULL

Order (Neworder)

  • orderid — Primary key — NOT NULL
  • order_date
  • sale_price

Publisher (NewPublisher)

  • publisher_name — Primary key — NOT NULL
  • contact_name
  • contact_no