My project is about online Book Store. It requires database operations and a front end web page which can interact with the database.
Web Pages are required for :-
a) Admin - update his profile, add books, update books and delete books
b) User - who can update his profile, view books , give ratings, comments to the books and place order if necessary.
c) Registration login for the new user is needed.
I have an ER model, based on the attributes, relations and tables we can develop the website.
The website can be basic, we need to use stored procedures to access and perform operations on the the data base.
Example for screens:-
There should be screens for data validation, data entry (add and update), search for books and list books.
Operations performed on database:-
selects, updates, deletes, Joins, Stored Procedures , triggers, etc
I need stored procedure to validate login, update member profile, update books, add books,deletes books, order a book, give ratings and comments to the book,etc
If you want I can give a clear explanation about the project. I have attached my ER model