Question

ERD Database

Using the CHEN model design the Entity Relationship Diagram (ERD) for this problem.
U can use Microsoft Power Point or Word.

The owner of B&B unlike many people, who need a database, has thought extensively about what he wants and offers a concise summary. “I would like my customer to beable to browse my catalog of books and place orders over the Internet. Currently, I take orders over the phone. I have mostly corporate customers who call me and giveme the ISBN number of a book and a quantity: they often pay by credit card. I then prepare a shipment that contains the books they ordered. If I don’t have enoughcopies in stock, I order additional copies and delay the shipment until the new copies arrive; I want to ship a customer’s entire order together. My catalog includesall the books I sell. For each book the catalog contains the ISBN number, title, author, purchase price, sales price, and the year the book was published. Most of mycustomers are regulars, and I have records with their name and addresses. New customers have to call me first and establish an account before they can use my website.On my new website, customers should first identify themselves by their unique customer identification number. Then they should be able to browse my catalog and toplace orders online. Customer should be able to place multiple orders of the same item in the same day”

Solutions

Expert Solution
No answers


Submit Your Answer