Question: 2 . Given the following scenario create an ERD for the Bookstore. I sell books and would like to create a database for my books

2 .

Given the following scenario create an ERD for the Bookstore.

I sell books and would like to create a database for my books and transactions. Currently, I am not keeping track of supplier information. Many times, customers come in asking what books a special author has written. Other times the customer wants books from a certain publisher or even a particular genre. Some of my books are hard cover and some are soft cover. I do not have any digital books. Make sure your ERD contains attributes as well.

* *

Remember the only foreign keys I should see in the ERD are for the bridges.

Paste screenshot of your ERD here

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Given the following scenario create an ERD for the Bookstore. I sell books and would like to create a database for my books and transactions. Currently, I am not keeping track of supplier...

Question 1 A library service wants to create a database to store details of its libraries, books and borrowers. Details include the following: A book has a unique ISBN number, a title and one or more...

question 1: you own your own estate planning firm and have been hired by kenny. Develop an estate plan for kenny to effectively manage his affairs for himself and his family and to minimize his tax...

See Final Case #2 - Kenny & Melissa.pdf This is a case about estate planning , it contains 25 questions. Estate Planning - Final Case #2 Kenny and Melissa Background Kenny, age 62, and Melissa, age...

Need answers to this as soon as possible... state Planning Final Case #2 Kenny and Melissa Background Kenny, age 62, and Melissa, age 23, have been dating for about a year and a half. Kenny and...

I need some assistance with my project proposal and its overview, my systems analysis and entity-relation diagram(ERD) and overall database creation. I am using Microsoft Visio and MS SQL 2012 as...

In Module Four, submit a systems analysis for your project, including a comprehensive entity-relationship diagram (ERD). Although you may use any tool to complete the ERD, it is strongly recommended...

I have problems understanding this case study for database. can someone help me solve this. Deliverables: 1. Create a list with the main business rules 2. Identify the main Entity types and their...

This assessment addresses the following course outcomes: Differentiate between database systems and file systems by comparing features and functions to determine benefits in data management Analyze...

For an ac circuit with resistance 145 m, capacitance 10.0 F, frequency 72.5 kHz, and E = 7.00 mV: (a) Find the impedance (in ohms), (b) Find the phase angle, (c) Find the current.

Use the values in the matrix to solve the equations given. a. P(A U F) = __________ b. P(E U B) = __________ c. P(B U C) = __________ d. P (E U F) =__________ E F A 10 03 B 04.12 C | .27 | .06 D .31...

ch 2 5 The FBI, under J . Edgar Hoover, contributed to procommunist propaganda through films and television shows such as The Red Menace and My Son John. True False

How would you describe the difference between human resources planning and strategic human resources management? Why is HR planning important to a firm's strategic planning? Explain. Are the firm's...

(Appendices) UNCOLLECTIBLE ACCOUNT EXPENSE: AGING METHOD. Glencoe Supply had the following accounts receivable aging schedule at the end of a recent year: LO6

(Appendices) ALLOWANCE FOR UNCOLLECTIBLE ACCOUNTS. At the beginning of the year, Kullerud Manufacturing had a credit balance in its allowance for uncollectible accounts of $6,307. During the year...

(Appendices) SALES AND PURCHASE DISCOUNTS: GROSS AND NET METHODS. Sims Company regularly sells merchandise to Lauber Supply on terms 3/15, n/20. During a recent month, the two firms engaged in the...