Develop the ERD for a publishing company that wants a database to maintain authors and books....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Develop the ERD for a publishing company that wants a database to maintain authors and books. Each author may write several books. Some authors sign with the publishing company before they write their first book. Each book may have one or more authors. However, some books are approved before any authors are assigned. The business rules are as follows: • Author id, first name, last name, and mobile number are stored for each author • Book id, title, publication year, and page count are stored for each book. The publi- cation year and page count are not known until the book is published • Draw the ERD for the many-to-many relationship(s) • Use ERD language • Resolve the many-to-many relationship between the BOOK and AUTHOR entities • Some books have two or more authors and they want to keep track of the order in which the author names appear on the book cover • Identify identifying and non-identifying relationships • Include ERD language 1:20 BO ● Exercises 9-12 - Saved Company ID Parent NULL C1 C1 C2 C2 C3 C3 NULL C1 C2 C3 C4 C5 C6 C7 C8 FO Question 2 (Ex 10): P03-02 - Nationwide Distribution Company - Recursive • Create an ER diagram called P03-02 based on the requirements analysis below • Export the ER diagram as a PDF file and submit 0 Nationwide Distribution, Inc. is a large distribution company that has purchased several smaller companies. The companies are being grouped based on distribution market, such as produce, ||| appliances, and so on. One company is established as the parent company for each market group and control the companies within that group. Most companies report to one parent company, while some companies continue to operate independently. For each company, store the company id, company name, and city. Company name Nationwide Distribution Inc. Coast-to-Coast Produce Can-Am Appliance Carriers Ontario Produce Distribution Michigan Produce Distribution Southwest Appliances Midwest Appliances National Auto Parts E - ...| || 60% 5 O fo City New York Los Angeles Hints: • The primary key company_id is propagated through the recursive relationship, and appears as a foreign key with the role name parent_id Question 2 P03-04 - Midtown Publishing Create a file called P03-04 3 I Chicago Toronto Grand Rapids San Diego • The foreign key can be NULL because some companies operate independently and have no parent Kansas City Detroit < = 1:20 BⓇO B Student ID 1001 1002 1003 1004 1005 1006 1007 1008 Exercises 9-12 - Saved FO Question 1(Ex 9): P03-01 - Student Tutors - Recursive • Create an ER diagram called P03-01 based on the requirements analysis below • Export the ER diagram as a PDF file and submit Students at the local college are encouraged to volunteer as tutors for other students. Not all students volunteer as tutors. Likewise, not all students request a tutor. Students requesting a tutor can only request one tutor at a time. Usually, a tutor will coach several students at any time. However, if a course is not offered, some tutors will not tutor that term. ● First name Jane Bill Jim Sally Ann Beth John Al ||| 0 E Last name Williams Wiinters Manis Smith Jones Albert Large James - ...| || 60% 5 Tutor ID 1006 NULL 1006 1002 1008 NULL 1002 NULL Hints: • The primary key student_id is propagated through the recursive relationship, and appears as a foreign key with the role name tutor_id • The foreign key can be NULL because some students do not volunteer as tutors O Question 2 (Ex 10): P03-02 - Nationwide Distribution Company - Recursive • Create an ER diagram called P03-02 based on the requirements analysis below Export the ER diagram as a PDF file and submit Nationwide Distribution, Inc. is a large distribution company that has purchased several smaller companies. The companies are being grouped based I U A 1:3 3 Develop the ERD for a publishing company that wants a database to maintain authors and books. Each author may write several books. Some authors sign with the publishing company before they write their first book. Each book may have one or more authors. However, some books are approved before any authors are assigned. The business rules are as follows: • Author id, first name, last name, and mobile number are stored for each author • Book id, title, publication year, and page count are stored for each book. The publi- cation year and page count are not known until the book is published • Draw the ERD for the many-to-many relationship(s) • Use ERD language • Resolve the many-to-many relationship between the BOOK and AUTHOR entities • Some books have two or more authors and they want to keep track of the order in which the author names appear on the book cover • Identify identifying and non-identifying relationships • Include ERD language 1:20 BO ● Exercises 9-12 - Saved Company ID Parent NULL C1 C1 C2 C2 C3 C3 NULL C1 C2 C3 C4 C5 C6 C7 C8 FO Question 2 (Ex 10): P03-02 - Nationwide Distribution Company - Recursive • Create an ER diagram called P03-02 based on the requirements analysis below • Export the ER diagram as a PDF file and submit 0 Nationwide Distribution, Inc. is a large distribution company that has purchased several smaller companies. The companies are being grouped based on distribution market, such as produce, ||| appliances, and so on. One company is established as the parent company for each market group and control the companies within that group. Most companies report to one parent company, while some companies continue to operate independently. For each company, store the company id, company name, and city. Company name Nationwide Distribution Inc. Coast-to-Coast Produce Can-Am Appliance Carriers Ontario Produce Distribution Michigan Produce Distribution Southwest Appliances Midwest Appliances National Auto Parts E - ...| || 60% 5 O fo City New York Los Angeles Hints: • The primary key company_id is propagated through the recursive relationship, and appears as a foreign key with the role name parent_id Question 2 P03-04 - Midtown Publishing Create a file called P03-04 3 I Chicago Toronto Grand Rapids San Diego • The foreign key can be NULL because some companies operate independently and have no parent Kansas City Detroit < = 1:20 BⓇO B Student ID 1001 1002 1003 1004 1005 1006 1007 1008 Exercises 9-12 - Saved FO Question 1(Ex 9): P03-01 - Student Tutors - Recursive • Create an ER diagram called P03-01 based on the requirements analysis below • Export the ER diagram as a PDF file and submit Students at the local college are encouraged to volunteer as tutors for other students. Not all students volunteer as tutors. Likewise, not all students request a tutor. Students requesting a tutor can only request one tutor at a time. Usually, a tutor will coach several students at any time. However, if a course is not offered, some tutors will not tutor that term. ● First name Jane Bill Jim Sally Ann Beth John Al ||| 0 E Last name Williams Wiinters Manis Smith Jones Albert Large James - ...| || 60% 5 Tutor ID 1006 NULL 1006 1002 1008 NULL 1002 NULL Hints: • The primary key student_id is propagated through the recursive relationship, and appears as a foreign key with the role name tutor_id • The foreign key can be NULL because some students do not volunteer as tutors O Question 2 (Ex 10): P03-02 - Nationwide Distribution Company - Recursive • Create an ER diagram called P03-02 based on the requirements analysis below Export the ER diagram as a PDF file and submit Nationwide Distribution, Inc. is a large distribution company that has purchased several smaller companies. The companies are being grouped based I U A 1:3 3
Expert Answer:
Answer rating: 100% (QA)
Since the request involves visual design work which I cannot create Ill provide a conceptual description of how the EntityRelationship Diagram ERD for ... View the full answer
Related Book For
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
Posted Date:
Students also viewed these databases questions
-
land value for 2022 was 110,00 and for 2023 is 104,000. the land was sold with a a gain of 7,400. Calculate amounts to enter in a statement of cash flows for 2023
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Draw an ERD for each of the following situations. (If you believe that you need to make additional assumptions, clearly state them for each situation.) Draw the same situation using the tool you have...
-
For the standard deductions, there are specified contribution tables to be followed as discussed in the previous modules. More examples: 1. Compute for Tita Pau's monthly, semi-monthly, weekly and...
-
Winding 1 in the loudspeaker of Problem 3.25 (Figure) is replaced by a permanent magnet as shown in Figure. The magnet can be represented by the linear characteristic B m = ? R (H m ? H c ). a....
-
In accounting for a Type A lease, how are the lessee's and lessor's income statements affected?
-
Show that, in Figure 7.26, the change in potential energy along a round trip from position \(x_{1}\) to position \(x_{2}\) and then back to \(x_{1}\) is zero. Figure 7.26 (a) Cart moves directly from...
-
Sampson Company operates a manufacturing facility where several products are made. Each product is considered a business segment, and the product managers have the opportunity to receive a bonus...
-
1. Identify products A and B 2. 3. CH3 dil. KMnO4 CrO3 A- B 273 K CH3 CH3 (A) A: OH B: OH OH CH3 CH3 (B) A: OH OH B: (C) A: OHCCH,CH,CH, CCH, B: HOOCCH,CH,CH, CH3 CH3 (D) A: B: OH -CH3 The electrode...
-
A long copper cylinder 0.6 m in diameter and initially at a uniform temperature of 38?C is placed in a water bath at 93?C. Assuming that the heat transfer coefficient between the copper and the water...
-
(20 pts.) Evacuation. A hurricane evacuation order is in effect, but some roads are becoming dangerous in unpredictable ways. To help citizens decide whether it is now safer to evacuate or shelter in...
-
If the project completion time is normally distributed and the due date for the project is greater than the expected completion time, then the probability that the project will be finished by the due...
-
How has Southwest traditionally kept its costs low?
-
What are the assumptions of the single-channel, single- phase queuing model?
-
The idea behind simulation is to a. imitate a real-world situation. b. study the properties and operating characteristics of a real-world situation. c. draw conclusions and make action decisions...
-
When simulating the Monte Carlo experiment, the average simulated demand over the long run should approximate the a. real demand. b. expected demand. c. sample demand. d. daily demand.
-
In order to complete each sentence, click and drag each word or phrase from the left into the appropriate blank on the right. (Some labels may not be used.) Then click and drag each sentence...
-
Making use of the tables of atomic masses, find the velocity with which the products of the reaction B10 (n, ) Li7 come apart; the reaction proceeds via interaction of very slow neutrons with...
-
In the section "Disadvantages of File Processing Systems," the statement is made that the disadvantages of file processing systems can also be limitations of databases, depending on how an...
-
Consider the following normalized relations for a sports league: What recommendations would you make regarding opportunities for denormalization? What additional in-formation would you need to make...
-
For each customer, list the customer ID, the number of orders from that customer, and the ratio of the number of orders from that customer to the total number of orders from all customers combined....
-
Give three specific examples of how Hotel Paris can use HR practices to improve its safety efforts.
-
What would you do now if you were Mr. Fisher?
-
The cost of living in Mexico is substantially below that of where Carter is now located: How would you go about developing a pay plan for your new manager if you decided to send an expatriate to...
Study smarter with the SolutionInn App