Based on the description provided below produce an E$-$R diagram $($chens diagram$)$ and schema. You need to decide which attributes are

appropriate and include them in your relational schema. Also, be sure to include cardinality and optionalities in yourERD. Do not include any attributes on your ERD, they should all be in the relational schema.

Summary

A local grocery store chain uses a loyalty$/$customer card system to track customers$$ purchasing patterns

including what products they buy from what store locations. They would like to use an information system to support strategic decisions regarding stocking levels, budgeting for store improvements, etc. The grocery store considers all members of a household as a single $$customer$.$ Similarly, the store sells products to businesses.

Each business is considered a single $$customer$$ as well.

Business Rules

Each customer $($each household or business$)$ is issued a customer ID card. This allows the company to maintain a list of demographic information including primary address and phone number. For $$Household Customers,$$ the store needs to know the number of adults in the household as well as the family income level and whether they own or rent the residence. $$Household customers$$ may opt to select a preferred store location that can be used for marketing$/$pickup purposes. For $$Business Customers,$$ the store maintains the current credit limit and

a main contact name. Also, Business Customers are grouped by industry for marketing purposes.

Business customers sometimes make purchases for specific events. If provided by the customer, the grocery store tracks basic information about these events, such as the event name, date, and number of attendees. This information helps the store prepare the orders for the events. Businesses may also make general purchases

unrelated to any particular event. Businesses are added to the system prior to their first purchase to ensure good customer service.

If the customer has their ID card with them, the card is scanned as part of the sale. It is possible for a sale to occur even if the customer has forgotten or chooses not to use an ID card. Each sale is identified by a Sale# and

also has the processing cashier$$s employee number and the time the sale begins. Since the grocery chain has a number of locations, each sale also records in which store location the sale occurred. If the sale is for a business event, then the event identifier is also stored with the sale information. Once the sale is initiated, the cashier

begins scanning the items in the customer$$s order. A customer can purchase any number of items on a single

order.

The available grocery items are broken down, logically$,$ into categories. For example, oranges, bananas and

apples are in the $$fruits$$ category. Each item is associated with only one $($primary$)$ category.

draw ER using chens diagram, create schema and show which are primary key and foreign keys.