Database Management System:

Tyler Book Store

Problem Definition:

The owner of Tyler Book Store has hired a database engineer to help him with designing a new relational database management system that would assist in implementing an online web-based bookstore. The bookstore will allow web customers to search for books, make purchases by adding items to the store shopping cart and checkout books by paying credit card payments. The proposed system should be able to show a list of available books as well as show books currently out of stock. Customers should be provided with an option to register and create an account on the website. No account is needed to search for available books for the website, but they would need an account before purchasing any books.

Administrators of the online web-based bookstore should be able to manage the inventory of all books as well as update customer information when receiving help desk calls.

The online web-based system should provide all relevant book information for customers including, but not limited to book title, author, ISBN and price. Customers should be able to search for books by this information.

Based on the above problem definition, create the following using Lucidchart and submit to Blackboard. At a minimum, each student should:

• A use case diagram with 3 use cases, including actor (stick figure) and process (bubble). Each bubble should include an identifying phrase.
• A description/definition for each use case, keyed to the identifying phrase in the process bubble.
• A class diagram (data model) with 3 classes and minimum 3 relationships. Label the classes and relationships.
• List at a minimum 3 attributes for each of the identified classes. Indicate which is the primary key and foreign key in each class.
• List cardinalities on both ends of each relationship (0..1, 1..*, 1..1) - minimum 6 (2 for each relationship identified between classes)