Please use draw.io to do this question.

Il you uboutUIE SUDITIIL YUui sigiCHIL, TIANC SUICU ILICIUUE VULL MCS. 1. (19.5 points) 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). a. 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. b. 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. 2. (20 points) For each of the descriptions below, develop an EER diagram using draw.io. Don't 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 Valentine's Day. For poems, they store a 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 country. 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. Que Bri B24 3. (10.5 points) 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 on ICON. B24 B24 B3: B34 B3 B3: B04 B04 B2: Question 3 Data BrideID Dress ID Purchased Birthdate 1/22/97 Age Likes 23 Classic Wedding Type Traditional Designer Rivini PriceRange Low B2419 R171 No Name Elizabeth Bennet Elizabeth Bennet Elizabeth Bennet B2419 1/22/97 23 Classic Traditional 9609x Allure Low B2419 1/22/97 23 Classic Traditional N4199 Sarah Nouri Low B3561 Juliet Capulet 6/4/01 8 Elopement 25122 Enaura Mid B3561 Juliet Capulet 6/4/01 Elopement 1413N Dennis Basso High No Ruffles, Beading, Embroidery Ruffles, Beading, Embroidery Ruffles, Beading, Embroidery Ruffles, Beading, Embroidery Lace, Classic B3561 Juliet Capulet 6/4/01 Elopement L1004 Lazaro High Yes B3561 18 A1430 High 6/4/01 3/25/93 No Elopement Traditional B0476 26 R171 Low Yes B0476 3/25/93 26 Lace, Classic Traditional 4663 Juliet Capulet Margaret Hale Margaret Hale Josephine March Anna Karenina Mid NO B2511 11/17/97 22 N4199 Low Yes B1049 9/28/90 29 Elopement A1430 High No B1049 Anna Campbell Rivini Pnina Tornai Sarah Nouri Anna Campbell Tony Ward Pnina Tornai Pnina Tornai Dennis Basso Stephen Yearick Anna Karenina 9/28/90 Simple Ruffles, Lace, Beading Ruffles, Lace, Beading Ruffles, Lace, Beading Ruffles, Beading 29 Elopement TW229 High 2 B1049 Anna Karenina 9/28/90 Elopement 4663 Mid 2 B3104 Scarlett O'Hara Destination 4663 Mid 2 B3104 Scarlett O'Hara Ruffles, Beading Destination 1413N High No B3104 Scarlett O'Hara Ruffles, Beading Destination 14260 Highest Yes Il you uboutUIE SUDITIIL YUui sigiCHIL, TIANC SUICU ILICIUUE VULL MCS. 1. (19.5 points) 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). a. 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. b. 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. 2. (20 points) For each of the descriptions below, develop an EER diagram using draw.io. Don't 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 Valentine's Day. For poems, they store a 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 country. 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. Que Bri B24 3. (10.5 points) 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 on ICON. B24 B24 B3: B34 B3 B3: B04 B04 B2: Question 3 Data BrideID Dress ID Purchased Birthdate 1/22/97 Age Likes 23 Classic Wedding Type Traditional Designer Rivini PriceRange Low B2419 R171 No Name Elizabeth Bennet Elizabeth Bennet Elizabeth Bennet B2419 1/22/97 23 Classic Traditional 9609x Allure Low B2419 1/22/97 23 Classic Traditional N4199 Sarah Nouri Low B3561 Juliet Capulet 6/4/01 8 Elopement 25122 Enaura Mid B3561 Juliet Capulet 6/4/01 Elopement 1413N Dennis Basso High No Ruffles, Beading, Embroidery Ruffles, Beading, Embroidery Ruffles, Beading, Embroidery Ruffles, Beading, Embroidery Lace, Classic B3561 Juliet Capulet 6/4/01 Elopement L1004 Lazaro High Yes B3561 18 A1430 High 6/4/01 3/25/93 No Elopement Traditional B0476 26 R171 Low Yes B0476 3/25/93 26 Lace, Classic Traditional 4663 Juliet Capulet Margaret Hale Margaret Hale Josephine March Anna Karenina Mid NO B2511 11/17/97 22 N4199 Low Yes B1049 9/28/90 29 Elopement A1430 High No B1049 Anna Campbell Rivini Pnina Tornai Sarah Nouri Anna Campbell Tony Ward Pnina Tornai Pnina Tornai Dennis Basso Stephen Yearick Anna Karenina 9/28/90 Simple Ruffles, Lace, Beading Ruffles, Lace, Beading Ruffles, Lace, Beading Ruffles, Beading 29 Elopement TW229 High 2 B1049 Anna Karenina 9/28/90 Elopement 4663 Mid 2 B3104 Scarlett O'Hara Destination 4663 Mid 2 B3104 Scarlett O'Hara Ruffles, Beading Destination 1413N High No B3104 Scarlett O'Hara Ruffles, Beading Destination 14260 Highest Yes