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

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