Problem 2. Develop an E-R Diagram and business documents based on the following information about the client's small seminars at home shows, kitchen and appliance stores, and other public locations. The seminars are videos that instruct people on kitchen design. She also offers custom-design consulting services.
After someone attends 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 services.
The figure below shows the seminar customer list form that Heather or her assistant fills out at seminars. This includes basic data about the seminar as well as the name, phone, and email address of each seminar attendee. Each of her seminars 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
Location: San Antonio Convention Center
Time: 11 AM
Kitchen on a Budget
Name
Phone
Email Address
Nancy Jacobs
817-871-8123
Nancy.Jacobs@somewhere.com
Chantel.Jacobs@somewhere.com
Ralph.Able@somewhere.com
Chantel Jacobs
Ralph Able
Etc. 27 names in all
210-281-7987
The sales invoice that Heather uses to sell books and videos is shown in the figure below. The 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 record credit card numbers in her computer. Instead, she records only the Rtvalue in the database and does not record the rest. Product details are stored in a separate entity PRODUCT with a productid and is related to the INVOICE.
INVOICE
ZPINH
Based on the information above, please help Heather construct an ER Diagram using the Crow's Foot notation. You can draw the ER diagram offline and paste a picture below. (10 Marks)