MUSIC ONLINE

IMPLEMENTATION PLAN

We have formulated how we will accomplish this application, which main modules needs to exist and how they will interact with the other modules of the application. Also which pages will be associated with which interfaces, the level of abstraction for different users and also access previleges which should be given to different kinds of users.

The following diagram will throw some light on the same.


FIGURE - Shows the schematic diagram of how this application can be implemented.

HIGH LEVEL DESIGN PHASE


 The Visitor Interface category will have the following pages:

  • The Home Page
  • The Chart Toppers Page
  • The Search Page
  • The Rating Page
  • The New Releases Page
  • The Register Page
  • The Login Page
  • The Help Page
    •

    The User Interface category will have the following pages:-

  • The User Home Page
  • The Shopping Cart Page
  • The Wishlist Page
  • The Review Page
  • The Buy Page
  • The Logout Page
    •

    The Administrator Interface category will have the following pages:-

  • The Delete User Page
  • The Add Item Page
  • The Modify Item Page
  • The Report's Page, which includes sales reports for a specified day, previous week, and previous month
  • The View Wishlist Page
  • The View Messages Page
    •

    DATABASE DESIGN

    Names of the tables And Their Utility


    tbl_item
    The tbl_item table will hold the details of the items in the inventory such as Item code, Title , Rate , Item description, Singer, Date of Release , Types such as CD , VCD and CASSETTES.

    tbl_userinfo
    The tbl_userinfo table will hold the details of user information such as user id, name, date of birth, email address , home address and credit card information. This table will be updated when a user registers to this music application.

    tbl_logininfo
    The tbl_logininfo table will hold the login information of the users such as username, password, secret question, and secret answer.

    tbl_sales
    The tbl_sales table will hold the details of the sales transactions such as Date of sales, Item sold, Quantity, customer info.

    tbl_wishlist
    The tbl_wishlist table will store the wishlist items of the users such as favorite music item stored by the customer.

    tbl_review
    The tbl_review table will store the feedback and reviews of the users such as messages given ,date of message. A user can select a product and write a review about it which is stored in this table.

    tbl_rate
    The tbl_rate table will store the number of ratings/votes for a favorite song. Users can select a product and see the previous reviews also.

    OTHER SPECIFICATION

    1. Language - J2EE ( JSP,Servlet,Java Beans etc)
    2. Tool- Eclipse IDE
    3. Database - MySql
    4. Time needed - 4 weeks
    5. Current status - 20% is finished
    6. Expected time line for rest of the implementation - 3 weeks
    Go To Home Page