Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started