Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create an Er Diagram based on the statements below: A. A customer of the store should register to purchase a book. To register, customers should

Create an Er Diagram based on the statements below:

A. A customer of the store should register to purchase a book. To register, customers should provide information of full name, gender, birth date, email address, delivery address, contact phone number(s). The customer also should provide one or more payment methods, such as debit card(s), credit card(s), bank account(s). Debit card and credit card should have information of card holder, card number, expiration date, contact phone number, and billing address. Each bank account should have account holder info, account type (checking or saving), account number and bank name. After registration, each customer will have a unique customerid, username and password.

B. The books of the store are divided into several sections, such as Sciences, Arts, Children, and so on. Each book belongs to a section, has a title, author(s), ISBN, price, edition, year and publisher. For each book, keep track of its current inventory. Every author has full name and an author could have written one or more books.

C. Customer can purchase one or more books in different quantities, and all books the customer purchases are put into his/her shopping cart. Based on the quantity and price of books in the shopping cart of that day, the bill will be generated when the customer checks out. Each bill belongs to a customer and associates with a shopping cart and a payment method is required to settle the bill.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Database Management

Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi

13th Edition Global Edition

1292263350, 978-1292263359

More Books

Students also viewed these Databases questions

Question

What does Processing of an OLAP Cube accomplish?

Answered: 1 week ago