(Solved) : 1 Please Build Entity Relationship Diagram Includes Cardinality Foreign Keys Specializatio Q34929210 . . .
1. Please build an Entity Relationship Diagram thatincludes cardinality, foreign keys, specialization and anyattributes. Use the following information:
- A local school needs your help designing a database to keeptrack of books and the students that check the books out. Each bookhas a unique ISBN, as well as a title and year that the schoolwould like to track. The school keeps track of each student nameand email address. In addition, the school keeps track of bookpublishers and authors, and the name and address of each.
- The school also tracks the two types of publishers: academicand fiction. If a publisher is academic, they cannot be fiction andvice versa. The school adds a student to the database after theycheck out a book, and they can check out multiple books at a time.A book can be checked out by multiple students but might never havebeen checked out. When a book is added to the database, its authorand publisher are added as well. A book must have at least oneauthor and if an author is in the database, he or she must beassociated with a book. Each book may be written by multipleauthors and each author may have written many books. A singlepublisher may have published many books, but each book has only onepublisher. If a publisher is in the database, they must beassociated with a book.
Expert Answer
Answer to 1 Please Build Entity Relationship Diagram Includes Cardinality Foreign Keys Specializatio Q34929210 . . .
OR