Question
2.For each of the descriptions below, develop an EER diagram using draw.io. Dont forget to include entities (including supertypes and subtypes), attributes (including subtype discriminator),
2.For each of the descriptions below, develop an EER diagram using draw.io. Dont forget to include entities (including supertypes and subtypes), attributes (including subtype discriminator), relationships, and completeness/disjointness constraints.
a.The UI Libraries are putting together a database of romantic literature Valentines Day. For poems, they storea unique ID, title, date, language, form (e.g., ode, haiku), and full text.Full text is unavailable for some poems.For books, they record a unique ID, title, date, language, number of pages, and plot summary. Every work in the database is either a poem or book.
b.The UI Libraries want to add more information to the database. First, they want to record more data about authors. For each author, they record a unique ID, name (composed of first, middle, last), birth date, death date (if applicable), and 2country. Some authors go by only a first name. Works of literature can be written by one author, but can also be anonymous. Each author in the database has one or more works. Second, they want to track which poems are published in larger collections/anthologies. A poem may be published in multiple collections over time, but may also be published individually (not in a collection). Each collection in the database has at least one poem. For each collection, the database records unique ID, title, and the full name (first, last) of the editor(s). Copy the entities and relationships you created in part a to a new sheet, then add the necessary entities and relationship described in part b.
Step 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