Question

Create a database for Book Sales System consisting of the following two tables:

Book (ISBNnumber, Title, FirstAuthor, YearOfPublication, Copies Acquired) Sales (ISBNnumber, PersonName, Numberof Copies Sold)

Develop and deploy a web based "Book Sales System" using JSP, a database backend and a web server (you may select DBMS and web server, as per your choice). Your system should use JDBC for input of information to both the tables. The system should output list of all the sales made for a Book whose ISBNnumber is given.

Submit the JSP program, screens and database of the system. You must demonstrate this system at the time of viva voce.

Make and state suitable assumptions, if any.

28 May 2025
Answer :
Word Count : 448
Questions (with respect to Web Programming): 1. What are the names and attributes of the tables created for the Book Sales System? 2. Which DBMS did you choose for storing the Book and Sales table data? Why? 3. Which web server did you deploy your JSP application on? 4. What JDBC driver did you use for database connectivity, and how was it configured? 5. What is the structure of your `Book` table in the database? 6. What is the structure of your `Sales` table in the database? 7. How does your JSP page accept input data for inserting into the `Book` table? 8. How does your JSP page accept input data for inserting into the `Sales` table? 9. How did you validate the input from the user on the JSP form? 10. What SQL queries were used to insert data into the `Book` and `Sales` tables using JDBC? 11. How did you fetch and display all sales for a given ISBN number using JSP and JDBC? 12. What exception handling
________ _______ __________ _________ __________.
___ __________ _____ __________ __________ _________ __________ _____ ______ _____.
_____ _________ _______ _____ ________ _______ _______ ____ _______ ______ _____.
________ _____ _____ __________ ___ ____ _____ ________ _________.
___ ________ ______ ____ ________ _________ ___ _________ _______ ___.
____ _________ _______ _________ ________ ____ _________.
_____ ____ ________ __________ ____ ___ ___ ______.
__________ _____ ____ ________ _______.
_________ _______ ___ ______ ________.
_____ _________ ____ ______ ______ __________ ____.
_______ _______ _______ __________ ____ ______.
__________ ___ ________ _________ _____ __________ ____.
__________ __________ ____ ___ ___.
_______ __________ ___ __________ _________ ___ _______ _______ ____ ___.
___ ___ _________ ______ ______ ________ _____ _______.
_______ ______ ____ _________ ______ _______.
_____ ______ ______ _________ _________ _____.
____ _________ ______ _________ _________ ____ _________ _______ _________.
________ ________ ______ ________ ____ _______ ______ ____.
_____ ______ ______ _____ ____.
_____ ___ ________ ______ _________ __________ __________ _________ __________.
____ _________ _______ _________ __________ _______ ______ __________ __________ __________ _________.
__________ ________ __________ ______ _______ ____ _____.
_______ __________ ______ ___ ___.
________ ______ ____ ________ _________.
____ ____ ________ _______ _________ ___ _________ ____ _____ ___ _________ ____.
__________ __________ _____ ____ ____ __________ _____.
__________ _______ ___ ________ ___ _________.
____ _______ _____ _____ _________ _____ _____ ________ _______ __________.
_________ ___ _______ _________ _____ _____ ___ _____ ____.
_________ _____ ______ __________ _____ _________ ____ _______ _______ _______ ____.
_________ __________ ___ ___ _______ _________ ____ ________ ________ _______ _________ ____.
_________ ________ ______ _________ ______ ______.
____ ___ ___ ______ ___ ____ _____.
_______ _____ _______ __________ _______ _____ __________ _____ ______ __________ _________.
___ __________ __________.
IGNOU ACADEMY
Your IGNOU journey, made easier.
  • Solved Assignments
  • Study Notes
  • Guess Papers
  • Question Papers
Skip in 10
Top
📞
Call Support Instant phone assistance IGNOU BCS 53 2024 2025 - Create a database for Book Sales System consisting of the following tw | IGNOU Academy
→
🟢
WhatsApp Chat Fast live messaging
→
Email Us Business enquiries & support
→