Introduction

The case study is about the analysis of the students understanding in analyzing a given scenario and practical skills to apply concepts and build diagrams studied in IT242 (Software Engineering). The case study consists of five parts. Students are required to answer all of these parts based on the below scenario.

The transformation from traditional commerce to E-commerce has several advantages such as less cost, process time and mistakes. MyBook, a bookstore that sells used books, is in the process of expanding its business. In order to achieve this plan, the MyBook administration would like to start developing a Website (as a virtual bookstore) with the following scenario:

The MyBook administration wishes to have a responsive website that renders well on desktop and mobile devices. The Website visitors would be able to view the available used books and if they would like to buy books, they have to register in the system and become customers for this bookstore. When a customer creates his/her account, the customers username and password must be selected. After logging to the system, customers can search for available used books, view the table of contents, order books and pay online after providing the credit card details. Additionally, customers can submit complaints. The system should verify the customers user name and password. The system also verifies the credit card details, if approved, the customers order is finalized, and the system sends a confirmation email to the customer.

The MyBook employee is responsible for handling the customer orders, adding used books, and updating the customer details. The employee will be able to do such tasks only after logged into the system. The MyBook manager can check the status of the online customers orders, check the list of available used books, withdraw old or damaged books, and update employees details. In addition, the manager can announce special or seasonal discount offers, for example, discount offers on purchases on the Saudi National Day. The manager will be able to do all such tasks only after logged into the system. A delivery employee can login to the system and view and deliver the book orders that are ready for delivery. The MyBook administration would like to have a system that allows the customers to pay by credit card or upon delivery (Cash on delivery COD). The system should be available for use 24 hours per day, 365 days per year.

Deliverables

The parts of this case study yields many outputs. These outputs will be the means of evaluation of each part of the case study. On or before the due date, the group leader (selected by the students group) must upload only one Word-format document to the Blackboard.

Based on the given scenario, answer the following parts.

Part Three

Questions of this part analyze the students understanding in analyzing the given scenario and practical skills to build Class diagrams studied in chapters 8, 10 and 12 of IT242.

The MyBook administration would desire to have a database system to keep track of its employees, books, customers and online orders. Read the following paragraph to answer the given questions.

The system maintains employees information. For each employee, the system keeps a unique employee ID, name, address, contact number and salary. The system also stores customers information. Each customer has a customer ID, name, title, contact number, and address. Each customer can make zero or more orders. Each order has an order ID, date and method of payment. A single order is associated with one or more used books. The used books are stored in the bookstore inventory. The book details to be stored are ISBN, title, author, publisher, publication year, quantity and unit price. An order is processed by one or two employees. A single order is also associated with zero or one discount. A discount has a discount ID, discount percent, discount code, start date and end date. A discount is managed by one employee only. A customer can file zero or more complaints. Each complaint has a complaint ID, title, body and date. A complaint is handled by one or more employees.

Identify the classes and their attributes from the given paragraph. (6 Marks)

Draw a Class diagram for the given database. The diagram must show all classes, relationships between classes, and multiplicities. (8 Marks)