Question: make a ER daigram 10 - A A Aar Po Arial BIUab x, x AAA Font Paragraph Problem 2. Develop and ER Diagram based on


make a ER daigram
10 - A A Aar Po Arial BIUab x, x AAA Font Paragraph Problem 2. Develop and ER Diagram based on the following information about the dient's small business documents Heather Sweeney is an interior designer who specializes in home kitchen design. She offers variety of seminars al home shows, kitchen and appliance stores, and other public locations. The seminars are free she offers then as a way of building her customer base. She sans revenue by selling books and videos that instruct people on kitchen design. She also offers custom design consulting services Afler someone atlencs a seminar, Heather wants to leave no stone unturned in attempting to sell that person one of her products or services. She would therefore like to develop a database to keep track of customers the seminars they have attended, the contacts she has made with them, and the purchases they have made. She wants to use this database to continue to contact her customers and offer them products and SerVIORS Figure below shows the seminar customer list form that Heather or her assistants out at seminars The includes basic data about seminar as well as name, phone, and email address of each seminar attendee Fach of her seminar has at least more than 10 customers. This gives two Entities, one SEMINAR and the other CUSTOMER Heather Sweeney Designs Seminar Customer List Date: October 12, 2018 LocationSan Antonio Convention Center Time: 11 AM Title: Kitchen on a Budget Name Phone Email Address Nancy Jacobs Chantel Jacobs Ralph Able 817-871-8123 817-871-8234 210-281-7987 Nancy Jacobs somewhere.com Chantel.Jacobs somewhere.com Ralph.Ablesomewhore.com Etc. 27 names in all The sales invoice that Heather uses to sell books and videos is shown in Figure below, SALES INVOICE itself needs to be an entity, and because the sales invoice has customer data it has a relationship back to CUSTOMER. (Note that we do not duplicate the customer data because we can obtain data items via the relationship;if data tems are missing, we add them to CUSTOMER Because Heather runs her computer with minimal security, she decided that she did not want to record credit card numbers in her computer Instead, she records only the betty value in the English India 1 No Spac... Heading 1 Heading 2 Title Normal KI Styles my INVOICE M OTT roe We TH TO SU IN TUL Com OCTO Er Based on the information above, please help Heather to construct an ER Diagram using the Crow's Foot notation. You can draw the ER diagram offline and paste a picture below. [10 Marks]
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
