Question
Homework Help!!

1. Draw an ERD for the following situation. Be sure to show: entity information, attributes, identifier(s), relationships and relationship names, and cardinality Each publisher has a unique name; a mailing address and telephone number are also kept on each publisher. A publisher may publish one or more books; a book is published by exactly one publisher. A book is identified by its ISBN, and other attributes are title, price, and number of pages. Each book is written by one or more authors; an author may write one or more books, potentially for different publishers. Each author is uniquely described by an author ID, and we know each authors name and address. As you develop the ERD for this problem, follow good data naming guidelines.
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Assumption: There are many authors under one publisher.

The Enities are Written in Blue Filled Boxed

The Attributes are written in White Boxes and the Identifier Attribute has been underlined

The Relationship Name is written in Red font

The Relationship is written in Blue Italic font

The cardinality is drawn with blue thin line.

Book Publisher ISBN Book Title Publisher_Name Publisher_MailingAddress Publisher_TelphoneNo 1:M PublishBook_Price Book_Pages

Please Like and provide your reviews in comments. :-)

Add a comment
Know the answer?
Add Answer to:
Homework Help!! 1. Draw an ERD for the following situation. Be sure to show: entity information,...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

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
  • 1. Draw an ERD for the following situation. Be sure to show: entity information, attributes, identifier(s),...

    1. Draw an ERD for the following situation. Be sure to show: entity information, attributes, identifier(s), relationships and relationship names, and cardinality Each publisher has a unique name; a mailing address and telephone number are also kept on each publisher. A publisher may publish one or more books; a book is published by exactly one publisher. A book is identified by its ISBN, and other attributes are title, price, and number of pages. Each book is written by one or...

  • Consider an ABC digital library that manages technical books, the data requirements are summarized as follows:...

    Consider an ABC digital library that manages technical books, the data requirements are summarized as follows: A book is identified by its ISBN number, and it has a title, a price, and a date of publication. It is published by a publisher, which has its own ID number and a name. Each book has exactly one publisher, but one publisher typically publishes multiple books over time. A book is written by one or multiple authors. Each author is identified by...

  • Design an E/R diagram for the following situation about books, authors, book publishers, book sellers, and...

    Design an E/R diagram for the following situation about books, authors, book publishers, book sellers, and book stores. Books have an ISBN number (the key), a name, ant type of printing (e.g. hardcover or soft cover). A book can be written by many authors and one author can write many books. Authors have an NSSF number (key) and a name. Publishers are the companies that manage the printing and production of books (e.g. ‘Prentice hall’). Publishers have a name (key),...

  • 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...

  • Consider the following relation tables (fields with underline is primary keys): Author(Name, Country) Book(ISBN, Title, Publisher,...

    Consider the following relation tables (fields with underline is primary keys): Author(Name, Country) Book(ISBN, Title, Publisher, Subject) Writes(Name, ISBN) Write the relational algebra for the following query: a. (2 points) Give the titles of all books with "Art" subject Solution: b. (2 points) Give the name of all authors who publish with "Harding" Solution: (2 points) Give the name of all authors who have written books with "Science" subject Solution: c. d. (3 points) Give the titles of all books...

  • 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...

  • Author(name, address, URL) Book(ISBN, title, year, price,         publisher_Name) WrittenBy(name, address, ISBN) Publisher(name, address, phone, URL)...

    Author(name, address, URL) Book(ISBN, title, year, price,         publisher_Name) WrittenBy(name, address, ISBN) Publisher(name, address, phone, URL) Warehouse(code, phone, address) Stocks(ISBN, WH_code, number) Shopping-Basket(basketID, email) basketContains(ISBN, basketID, number) Customer(email, name, address, phone) Referring to the relational model in slide 15 in"ER-mapping" (about author, publisher, shopping-basket, provide the algebraic pressing for the following queries Q1: Report the book title, and year for the books that have been written by exactly 2 authors, one of them is Mark Smith" Q2: For each customer,...

  • The primary keys are underlined. The foreign keys are denoted by asterisks (*). Description of the...

    The primary keys are underlined. The foreign keys are denoted by asterisks (*). Description of the schema: • person — keeps track of the people who borrow books from the library. The attributes contain personal and contact information. • author — keeps track of personal information about authors. • publisher — keeps track of the publisher information. To keep it simple, most of the attributes have been truncated in the sample database. 1 trivial dependencies are things like X→X or...

  • Make an ERD including all entities, attributes, relations, and constraints. Please upload as a doc based...

    Make an ERD including all entities, attributes, relations, and constraints. Please upload as a doc based on everything listed below University Bookstore •University Bookstore has several branches throughout Bloomington, and employees may be assigned to work at any of the branches. •Employees are identified by an ID and have a full name, date of birth, SSN, address, multiple phone numbers, a gender, and a hire date. •A Manager runs a branch and is responsible for all operations at that branch....

  • Use MySQL Workbench to create a simple ER model and use the Forward Engineering functionality of...

    Use MySQL Workbench to create a simple ER model and use the Forward Engineering functionality of Workbench to create a simple DB (specs follow). This focuses on how MySQL Workbench is used to create a model and then a DB from it, rather than on ER modeling. The sample model you are to create is on books, authors, and publishers - a model that could be part of a larger ER model for a library. A book has an ISBN...

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
ADVERTISEMENT