Managing Books in Sheridan College Book Stores

We want to create a program that will allow us to manage the books in the Sheridan College Book Stores.  Sheridan college has 3 stores (Oakville, Brampton, and Mississauga).  Each store will have an inventory that needs to be managed.

Each book has the following information that needs to be tracked.

• ID: Auto generated when added into the database
• Title
• Author
• Price
• Inventory Quantity
• List of courses the book is related to.

Note that the books may be related to multiple courses, so we will have to manage a list of them.  This can be done as a long string

You should be able to add a book into one of the 3 book stores.  Read in the information for title, author, price, quantity, and related courses.  The Id should be generated by the SQL database.  Create an appropriate HTML page to add the information.

The following command will increment the database.

id INT NOT NULL Primary Key AUTO_INCREMENT

Create a “generate dummy records” button that will generate a variety of books in each of the stores.  There should be at least 30 books in each of the stores.  You may want to use ENUM to randomly generate some of these values, or you may write out the code for all the books.  This must be done with methods in your code.  You will not be awarded marks if this is done in the .sql file.

Create an HTML page that lists all the books separated by book store.  It should display all the information from each book well organized in a table.

Design

Your project should have nicely designed HTML pages. Make use of CSS to make the pages appealing to read.  Make use of Sheridan College images and logo's throughout your application to make it well themed.  You may create as many HTML pages as you wish to complete each task.  Your program should have an index page mapping for localhost:8080/Assignment1_FirstName_LastName.  Your index directory should link to each part of the assignment that is going to be marked.  I should be able to navigate to parts 1-3 from your root mapping, and each page should be able to link back to your root directory.  You have a lot of freedom with the layout of your assignment, however it should be easy to navigate and to enter information.

Note that the second and third assignments will build off of this assignment.

Use of New Material

You are expected to use the material that is taught in class and in the notes.  If you use libraries and code that is not done in class you are required to discuss it with me prior to using it in your assignment.  If you do not discuss it with me you may face deductions in your assignment.

Use of JavaScript and Other Languages

Your code is expected to be functional using Servlets, JSP's, and MySQL.  JavaScript should not be used to add any primary functionality, only design and style.

DAO Setup

As part of your assignment, you will be required to create a "FirstName_LastName_setup.sql" file that will create all necessary databases and tables for your assignment. This will be similar to your SQL exercise from Monday of Week 8. This file will be run through the MySQL terminal, and should be tested that way before submitted.  Make sure to follow the template of the exercise.