DSU Bookstore

Tables (4)

Customer (Newcustomer)

  • custid — Primary key — NOT NULL
  • cust_name — varchar(20)
  • address — varchar(50)
  • phone — integer

Order (Neworder)

  • Orderid — integer — Primary key — NOT NULL
  • order_date — integer
  • sale_price — integer
  • custid — Foreign key → Customer.custid — NOT NULL
  • bookid — integer — Foreign key → book.bookid — NOT NULL

Publisher (NewPublisher)

  • publisher_name — varchar(20) — Primary key — NOT NULL
  • contact_name — varchar(20)
  • contact_no — integer

book (Newbook)

  • bookid — integer — Primary key — NOT NULL
  • bookname — varchar(20)
  • price — integer
  • publisher_name — varchar(20) — Foreign key → Publisher.publisher_name — NOT NULL