Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Informix Database Administrators Survival Guide

Authors: Joe Lumbley

1st Edition

0131243144, 978-0131243149

More Books

Students also viewed these Databases questions

Question

Acceptance of the key role of people in this process of adaptation.

Answered: 1 week ago

Question

preference for well defined job functions;

Answered: 1 week ago