DSU 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
  • order_date
  • sale_price
  • orderid (orderid2) — Foreign key → order.orderid — NOT NULL
  • orderid — Foreign key → order.orderid — NOT NULL
  • orderid (orderid3) — Foreign key → order.orderid — NOT NULL

order (Neworder)

  • orderid — Primary key — NOT NULL
  • cost_name
  • address
  • phone
  • custid — Foreign key → customer.custid — NOT NULL

publisher (NewPublisher)

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