Design of the Database Schema In this section
Design of the Database Schema In this section we will create the database schema of the application. The application’s data (tables and indices) will be stored in a separate database (shop). Generally all the schema objects related to an application should be stored in a separate database/table space. It helps in easy management of related database objects. For example, to back up the data of the shopping cart application, the database administrator has to back up only one database (shop). Database Tables The following tables will be created in the shop database: . UserProfile . BookShop . MusicShop . Transaction . Session The UserProfile table contains user information: Column Name Description Fname First name of the user Lname Last name of the user UserId Unique user id Password Encrypted password of the user Address Street address City City Country Country ZipCode Zip code Gender Male/Female Age User’s age Emailed User’s e-mail address PhoneNumber Phone number of the user CardNo User’s credit card number ExpiryDate Expiry date of the credit card CardType User’s credit card type Master/Visa AccountBalance Balance in the user’s account The BookShop table contains the description of available book titles: Column Name Description Itemno Unique identifier for the book Itemtype Book type Title Title of the book Page 547
Hint: If you are looking for very good and affordable webspace to host and run your j2ee hosting application check Sandzak.com j2ee web hosting services