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