HomeworkLib
Question

create an ERD for a small book store . The owner would like to database to...

create an ERD for a small book store . The owner would like to database to keep track of Books, Authors, and Publisher only (hint: do these sound like entities?). Create appropriate attributes, keys, relationships, and data types.  

Keep in mind that Many-to-Many relationships should not be implemented in the database. These relationships should be broken into One-to-Many relationships using Associative Entities.  

engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Solution:

ERD Diagram:

Explanation:

From the above diagram, there are 3 entities and one associative entity. The underlined attribute has primary key. The associative entity has 2 foreign keys from the tables. The owner can add more attributes in each entity

0 0
Add a comment
Know the answer?
Add Answer to:
create an ERD for a small book store . The owner would like to database to...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • A small surgery center needs your help to create a database. The office manager has identified...

    A small surgery center needs your help to create a database. The office manager has identified the following types of data (entities): patients, doctors, procedures and appointments. Please identify the attributes and primary keys needed for each of the entities. Identify the data types you would use for each of the attributes. Determine the relationships between the entities and find the one-to-many and many-to-many relationships. Use the ER matrix to determine the relationships. Create an ER diagram using Visio based...

  • Henry's Bookstore Database Henry's Bookstore is a small company with four locations in the city. Henry...

    Henry's Bookstore Database Henry's Bookstore is a small company with four locations in the city. Henry has struggled with MS Excel mainly because he was trying to use spreadsheet software as a database, when in fact he should have been using a database. Requirements Create all of the entities needed for the Physical ERD Specify the columns/attributes needed in each entity along with the data type and size of each attribute. Specify the Primary Key(s) and Foreign Key(s) for the...

  • Draw a Design Class Diagram based on the following database requirements as provided by a book...

    Draw a Design Class Diagram based on the following database requirements as provided by a book publisher A. For each author, the book publisher would like to keep track of the author’s ID number, name, and contact number. i. IC number is unique for each author ii. First Name iii. Last Name iv. email B. For each book, the book publisher would like to keep track of the book’s ISBN (International Standard Book Number) and name i. ISBN is unique...

  • Create an ERD using Lucid Chart for the following description. Be sure to include all necessary...

    Create an ERD using Lucid Chart for the following description. Be sure to include all necessary entities, attributes, and correct cardinality in relationships between entities. Don’t forget foreign keys. You have been asked to build a database for a technology company called TechNow. The company owner needs to keep track of the customers that buy their products, the employees that work at TechNow, the offices that the employees use, the vendors that provide them with products, and the products themselves....

  • c) Write an ER Diagram for the following Library database. Identify all the Entities, Relationships and Attributes. Underline the primary keys and mark the different constraints. You can add an I att...

    c) Write an ER Diagram for the following Library database. Identify all the Entities, Relationships and Attributes. Underline the primary keys and mark the different constraints. You can add an I attribute as a primary key for an entity to make t unique if necessary. Library has a number of branches in the city, each branch having a name, address and librarian. Books have title, authors and publisher. A book can have multiple authors but a single publisher. Note that same...

  • The owner of a small chain of appliance stores wants to build a database to help...

    The owner of a small chain of appliance stores wants to build a database to help track data about its regions, stores, employees and jobs.  The chain has divided the map of where its stores exists into various regions. Each region has a description (of boundaries).  Each store is named, has an average market size (expressed in dollars) and belongs to s specific region. Each store also has an address, city, state, and zip.  The database should...

  • In Module Four, submit a systems analysis for your project, including a comprehensive entity-relationship diagram (ERD)....

    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 that you use Microsoft Visio and then save the diagram into an image format (GIF or JPG) and then copy and paste the image into your systems analysis. All sections of this milestone should be compiled into a single Word document. Furthermore, all of Milestone One should be included in...

  • Question: Draw the ERD for the following situation. Show all entities, attributes, relationships, cardinalities, and modalities....

    Question: Draw the ERD for the following situation. Show all entities, attributes, relationships, cardinalities, and modalities. Each student (with attributes StudentID, StudentName, and StudentMajor) must be assigned one advisor (with attributes AdvisorID, AdvisorName, and AdvisorDepartment). Advisors may advise no students or may advise many students. Each student must register for zero or many courses (with attributes CourseID, CourseTitle, and CourseCredits) with the help of one or more advisers. A course may have at least one student registered, and may have...

  • Show the ERD for the following piece of the problem statements. Show only entities (or dependent...

    Show the ERD for the following piece of the problem statements. Show only entities (or dependent entities), relationships, multiplicities, primary keys and foreign keys. Create an appropriate primary key if necessary. You don’t need to specify other attributes. If a relationship is M:N, then show two diagrams: both the M:N relationship diagram and its decomposition into two 1:N relationships. (a) A book has one or many keywords and one keyword can be used in zero or many books. (b) A...

  • Mr. Bob Dillon is a collector of china pieces. He needs a database is to store...

    Mr. Bob Dillon is a collector of china pieces. He needs a database is to store data about his collection. Each piece in this collection is to be identified by a unique ID value. Bob knows of several agents that work on getting these pieces shown in prestigious exhibitions. Each exhibition has an ID, a name, a venue, a start date and an end date. For all items shown, there is a deadline for returning them to the item owners....

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT