Problem 2. Develop and E-R Diagram based on the following information about the clients small business documents.

Heather Sweeney is an interior designer who specializes in home kitchen design. She offers variety of seminars at home shows, kitchen and appliance stores, and other public locations. The seminars are free; she offers them as a way of building her customer base. She earns revenue by selling books and 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. Figure below shows the seminar customer list form that Heather or her assistant fills out at seminars. This includes basic data about seminar as well as name, phone, and email address of each seminar attendee. Each of her seminar has at least more than 10 customers. This gives two Entities, one SEMINAR and the other CUSTOMER. 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 items 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 PaymentType value 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.

Based on the information above, please help Heather to construct an ER Diagram using the Crows Foot notation. You can draw the ER diagram offline and paste a picture below. [10 Marks]

Problem 2. Develop and E-R Diagram based on the following information about the client's small business documents Heather Sweeney is an interior designer who specializes in home kitchen design She offers variety of seminars at home shows, kitchen and appliance stores, and other public locations The seminars are free, she offers them as a way of building her customer base. She earns revenue by selling books and 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 Figure below shows the seminar customer list form that Heather or her assistant fills out at seminars This includes basic data about seminar as well as name, phone, and email address of each seminar attendee. Each 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 Location: San Antonio Convention Center Title: Kitchen on a Budget Time: 11 AM Name Phone Email Address 817-871-8123 Nancy Jacobs Nancy.Jacobs@somewhere.com Chantel.Jacobs@somewhere.com Chantel Jacobs 817-871-8234 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 items 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 PaymentTyre value 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. I Invoice No. 35000 Heather Swooney Dosigns 122450 Rockoway Rood Dallas, Toxas 75227 INVOICE Misc Customer 10/15/18 Name Address City Phone Ralph Able 123 Elm Street San Antonio 210-281-7987 Date Order No. Rep FOB Stale TX ZIP 78214 Description TOTAL Unit Price Qty 14.95 7.99 1 $14.95 S S 7.99 $ Kitchen Remodeling Basics - Video Kitchen Remodeling Basics - Video Companion Involce No. Heather Sweeney Designs 122450 Rockaway Road Danas, Toxos 75227 35000 INVOICE Customer Misc Date 10/15/18 Name Address City Phone Ralph Able 123 Elm Street San Antonio 210-281-7987 State TX ZIP 78214 Order No Rep FOB Qty Description Unit Price TOTAL 1 1 Kitchen Remodeling Basics - Video Kitchen Remodeling Basics - Video Companion us 14.95 S 7.99 S 14.95 7.99 S 22.94 Subtotal s Shipping S 5.70% $ 5.95 Payment Credit Tax Rate(s) 1.31 TOTAL S 30.20 Comments Visa Name Ralph J. Able f oxoxx xxx xox ooooox Expires May-13 Office Use Only 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] Problem 2. Develop and E-R Diagram based on the following information about the client's small business documents Heather Sweeney is an interior designer who specializes in home kitchen design She offers variety of seminars at home shows, kitchen and appliance stores, and other public locations The seminars are free, she offers them as a way of building her customer base. She earns revenue by selling books and 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 Figure below shows the seminar customer list form that Heather or her assistant fills out at seminars This includes basic data about seminar as well as name, phone, and email address of each seminar attendee. Each 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 Location: San Antonio Convention Center Title: Kitchen on a Budget Time: 11 AM Name Phone Email Address 817-871-8123 Nancy Jacobs Nancy.Jacobs@somewhere.com Chantel.Jacobs@somewhere.com Chantel Jacobs 817-871-8234 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 items 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 PaymentTyre value 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. I Invoice No. 35000 Heather Swooney Dosigns 122450 Rockoway Rood Dallas, Toxas 75227 INVOICE Misc Customer 10/15/18 Name Address City Phone Ralph Able 123 Elm Street San Antonio 210-281-7987 Date Order No. Rep FOB Stale TX ZIP 78214 Description TOTAL Unit Price Qty 14.95 7.99 1 $14.95 S S 7.99 $ Kitchen Remodeling Basics - Video Kitchen Remodeling Basics - Video Companion Involce No. Heather Sweeney Designs 122450 Rockaway Road Danas, Toxos 75227 35000 INVOICE Customer Misc Date 10/15/18 Name Address City Phone Ralph Able 123 Elm Street San Antonio 210-281-7987 State TX ZIP 78214 Order No Rep FOB Qty Description Unit Price TOTAL 1 1 Kitchen Remodeling Basics - Video Kitchen Remodeling Basics - Video Companion us 14.95 S 7.99 S 14.95 7.99 S 22.94 Subtotal s Shipping S 5.70% $ 5.95 Payment Credit Tax Rate(s) 1.31 TOTAL S 30.20 Comments Visa Name Ralph J. Able f oxoxx xxx xox ooooox Expires May-13 Office Use Only 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]