SQLP_TermProject
Topic: BookStore Database
Work Done:
- Taking Database and create ER diagram
- Created Tables and some dummy data
- Created interface to perform CRUD operations
Tables:
- Authors : Store Authors details along with name
- Books : Storing book price, stock, genre along with name
- Book Store : Stores where these books will be stored
- Customer : storing customer information when there is new purchase
- Orders : keeping order track
Views:
- books_author : to view books detail along with author
- order_placed : Complete view of each order along with books purchased
Procedures:
- AddCustomers - Inserting new customer data in the customer database along with
- DeleteCustomer -
- check_book_by_price - Getting books below the given price
- check_stock_min - To keep check on stock
- disp_price - enter book name to know its price
- getInvoice - insert book name and quantity get total price
- Search_bookAuthor
- Search_bookname
- Search_booktype
- view_available_books