Database Management

Question Description

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).
1. Hy-Vee Floral maintains an order information database. For each order, theyrecord the ID, date needed, whether the order is delivery or pick-up, and totalprice (based on the price of items ordered). Orders are placed by customers, andeach has an ID, full name (first, last), and payment information. Some customersdo not have payment information on file. A customer can have multiple orders,but may be entered into the system before placing any orders. Each orderbelongs to a single customer. Orders contain one or more items. An item belongsto 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 databasealso tracks the type of each item (e.g., bouquet, boutonniere) and its price.
2. 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 specificemployee for fulfillment. To ensure that work is distributed, each employee canhave at most 5 orders at a given time, but employees may be entered into thedatabase before they have been assigned any orders. Copy the entities andrelationships you created in part a to a new sheet, then add the necessaryentities and relationship described in part b. 2.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 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. 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 anER 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.



^{Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."}

Our Service Charter

1. Professional & Expert Writers: Eminence Papers only hires the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.

2. Top Quality Papers: Our customers are always guaranteed of papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.

3. Plagiarism-Free Papers: All papers provided by Eminence Papers are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.

4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. Eminence Papers are known for the timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.

5. Affordable Prices: Our prices are fairly structured to fit in all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses.

6. 24/7 Customer Support: At Eminence Papers, we have put in place a team of experts who answer all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.