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 BO 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