$2,$ Entity Relationship Diagram problem $(25$ points$)$:

Prepare an ERD by using

draw.io$.$ Hand$-$drawn diagrams will not be accepted as valid

submissions.

The ERD must have all the maximum and minimum cardinalities identified. State any

assumptions if necessary.

The ERD must be converted to a list of tables $($schema$)$ by using the $4$ conversion rules

discussed in class $($gradings for this part are based on whether you have used all the

applicable conversion rules, and used them correctly$)$

Draw an E$-$R diagram for the following situation: Shi$-$

nyShoesForAll $($SSFA$)$ is a small shoe repair shop located

in a suburban town in the Boston area. SSFA repairs

shoes, bags, wallets, luggage, and other similar items.

Its customers are individuals and small businesses. The

store wants to track the categories to which a customer

belongs. SSFA also needs each customer's name and

phone number. A job at SSFA is initiated when a customer

brings an item or a set of items to be repaired to the shop.

At that time, an SSFA employee evaluates the condition

of the items to be repaired and gives a separate esti$-$

mate of the repair cost for each item. The employee also

estimates the completion date for the entire job. Each

of the items to be repaired will be classified into one of

many item types $($such as shoes, luggage, etc.$)$; it should

be possible and easy to create new item types even before

any item is assigned to a type and to remember previous

item types when no item in the database is currently of

that type. At the time when a repair job is completed, the

system should allow the completion date to be recorded

as well as the date when the order is picked up$.$ If a

customer has comments regarding the job, it should be

possible to capture them in the system.