Reference no: EM132454640

Question: 1. For each of the descriptions below, develop an ER diagram using draw.io. Don't forget to include entities, attributes (including attribute type), and relationships (including cardinality and modality).

Hy-Vee Floral maintains an order information database. For each order, they record the ID, date needed, whether the order is delivery or pick-up, and total price (based on the price of items ordered). Orders are placed by customers, and each has an ID, full name (first, last), and payment information. Some customers do not have payment information on file. A customer can have multiple orders, but may be entered into the system before placing any orders. Each order belongs to a single customer. Orders contain one or more items. An item belongs to one specific order. Within each order, individual items have a number (e.g., "Item 1", "Item 2", ...), but this is not unique across different orders. The database also tracks the type of each item (e.g., bouquet, boutonniere) and its price.

Hy-Vee also records information about employees, including their ID, full name (first, last), and special skills (if applicable). Each order is assigned to a specific employee for fulfillment. To ensure that work is distributed, each employee can have at most 5 orders at a given time, but employees may be entered into the database before they have been assigned any orders. 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.

Question: 2. For each of the descriptions below, develop an ER diagram using draw.io. Don't forget to include entities (including supertypes and subtypes), attributes (including subtype discriminator), relationships, and completeness/disjointness constraints.

i.The UI Libraries are putting together a database of romantic literature Valentine's 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.

ii.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.

Question: 3. Kleinfeld Bridal Salon is building a database to store information on brides and the dresses that they try on in the store. From the data provided on the next page, develop an ER diagram using draw.io.

Don't forget to include entities, attributes (including attribute type), and relationships (including cardinality and modality). The raw data file ("Homework_1(data).xlsx") is also available.

Attachment:- homework data.rar