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