Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Conceptual modeling ERD Question 1: ERD - Conceptual Modeling A conglomerate of several publishing companies is planning to integrate all databases to store publishing materials.
Conceptual modeling ERD
Question 1: ERD - Conceptual Modeling A conglomerate of several publishing companies is planning to integrate all databases to store publishing materials. The prototype database will store each publisher's address and phone. Some publishers have locations in the US and internationally. Publishers print multiple books written in different topics. Some books may be published by many of the publishers available in the database, while other books are published by a single publisher. A book is identified by its ISBN, title, price and date of publication. Each book is written by one or more authors; an author writes one or more books, potentially for different publishers in the database. Some published books have a lead author each and some are only written by one author. The database stores each author by name, address and writing specialty. For each book written by an author, regardless if he/she is a lead author or not, the author receives a book royalty percentage. The royalty potentially varies for each book, per author and per publisher. Royalty is identified by a reference number, date and amount. Design a prototype conceptual model using the ERD method as follows: Include entities, attributes, identifiers, relationships with min and max cardinality Break down many to many relationships using associative entities with proper attributes including associative entity identifiers Do not model foreign keys; you will lose credit if you do Do not use EERD method in this question; your answer will not be accepted and you will receive 0 in this question regardless of how complete the answer is Question 1: ERD - Conceptual Modeling A conglomerate of several publishing companies is planning to integrate all databases to store publishing materials. The prototype database will store each publisher's address and phone. Some publishers have locations in the US and internationally. Publishers print multiple books written in different topics. Some books may be published by many of the publishers available in the database, while other books are published by a single publisher. A book is identified by its ISBN, title, price and date of publication. Each book is written by one or more authors; an author writes one or more books, potentially for different publishers in the database. Some published books have a lead author each and some are only written by one author. The database stores each author by name, address and writing specialty. For each book written by an author, regardless if he/she is a lead author or not, the author receives a book royalty percentage. The royalty potentially varies for each book, per author and per publisher. Royalty is identified by a reference number, date and amount. Design a prototype conceptual model using the ERD method as follows: Include entities, attributes, identifiers, relationships with min and max cardinality Break down many to many relationships using associative entities with proper attributes including associative entity identifiers Do not model foreign keys; you will lose credit if you do Do not use EERD method in this question; your answer will not be accepted and you will receive 0 in this question regardless of how complete the answer isStep 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