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