Designing a Database for Argosy Books: ERD, Flowchart, Data Dictionary

Requirement 1: ERD Design

Using the business case included in this assignment, complete the following requirements:

1.Draw the ERD of the database that could be used to support the operations of the business described in the case. The ERD should identify:

Primary keys and Foreign keys;
Entities and Attributes;
Relationships and Cardinalities (e.g. one-to-one, one-to-many).

Next to the ERD in your submission, list the assumptions made when designing the ERD. If an element of the business case does not provide the information necessary to know for certain whether one design choice should be made over another, the choice you make will be accepted if it correctly reflects your assumptions.

2.Draw a flowchart diagram.
Draw a Flowchart diagram depicting processes in the case.
Your diagrams must depict the following:

Main actions / processes
Main decisions
Actors (departments) with dedicated swimlanes

3.Create the data dictionary for your database.

To do this, you can use the template given with this assignment (datadictionaryTemplate.xls) :
4.Implement the ERD Microsoft Access 2010/2013/2016 or LibreOffice (4 marks)
Microsoft Access is installed in the SCBTM lab located in MB 12.314.  LibreOffice can be downloaded from the link below (Windows or Mac):

Business Case : Argosy Books.

Argosy Books is New York City’s oldest independent bookstore, The Argosy was founded in 1925 by Louis Cohen, who picked the name, in part, because it started with the letter “A” and would be listed early in telephone directories. Argosy is making an effort to make minor changes in the functionality of their website to ensure that they can better manage their business. In order to do so, Argosy Books has been cleaning their data in an effort to reduce the amount of duplicate data as well as ensure their database only contains relevant information. You have been hired to categorize these different sets of data as well as map out the basis of Argosy Books’s ordering process.

Argosy Books houses many different variety of books a customer can buy. Each book has a time, a short to medium description of what it is, the author(s) name, price, publisher, and a rating of 1 to 5. A book can have been written by many authors and one author can have written many books. In an effort to better organize themselves, Argosy Books registers each author by keeping track of their name (first and last), total number of published works, and the country they are from.

In addition, books can be published by only one publisher, but a publisher can publish many books. Argosy Books would track these publishers by keeping records of the publisher’s name, website URL, the name and contact information of the publisher’s representative (first name, last name, email, and phone number),

In order to buy books from Argosy Books, a customer must create an account and are required to provide their first name, last name, address (including city, state/province, country, and postal code), email address, and date of birth. Once created, the customer can now begin ordering the books they wants. As many as they want and as often as they want.

Once the customer selected their product(s), they go to their shopping kart before they continue with order. It is here that the customer may decide whether to modify (remove or change the quantity), delete the order or proceed with the order.

If the customer decides to modify the order, they remain in the shopping cart to modify their order, after which they proceed with the order. If the customer choose it delete the order, the process ends. If the customer chooses to proceed with the order, they are displayed a confirmation screen with the order’s details. If they agree with the order, they proceed to pay the order. If not, the order is cancelled and the process ends.

A customer can have many orders, but only one order can attributed to a single customer. An order can have multiple books and a book can be part of multiple orders. For each order, there contains unique data that identifies it such as the date when the order was created, shipping address (customer’s default address or other), shipping price, and total price.

Once the order has been processed, Argosy Books then ships the order to the buyer. Once it is received, the customer may leave a write a review of the book(s) if they wish to do so. Not all books on Argosy Books contain reviews.