Question $1(1$ point$)$

Consider again the clothing sale example $($from Week $6)$ and suppose you were given

a variation of this problem.

You have been hired to develop a database to support a clothing store. The store is

part of a larger franchise, so you will want to collect some data on the franchise itself

$($e$.$g$.,$ year it was established, where the headquarters is located, etc$).$ For your own

store, you want to keep track of your customers and whether they are frequent

customers $($e$.$g$.,$ have a loyalty program card$)$ and your employees. Your employees

may be full time or part time. They can receive a discount which is calculated based

on the length of time they have worked for the company. Of course, you need to

keep track of the clothing that you sell and who supplies the clothing. You do not

need to include the retailer or distributor. Just use "supplier" as an entity. Nor do you

need to distinguish sporting goods as items.

Write down the entities and relationships for this application. Indicate the $mi\frac{n}{m}ax$

cardinalities for the relationships.

Write Question $1$

Consider again the clothing sale example $($from Week $6)$ and suppose you were given a variation of this

problem.

You have been hired to develop a database to support a clothing store. The store is part of a larger

franchise, so you will want to collect some data on the franchise itself $($e$.$g$.,$ the year it was established,

where the headquarters is located, etc$).$ For your store, you want to keep track of your customers and

whether they are frequent customers $($e$.$g$.,$ have a loyalty program card$)$ and your employees. Your

employees may be full$-$time or part$-$time. They can receive a discount which is calculated based on the

length of time they have worked for the company. Of course, you need to keep track of the clothing that

you sell and who supplies the clothing. You do not need to include the retailer or distributor. Just use

"supplier" as an entity. Nor do you need to distinguish sporting goods as items.

Write down the entities and relationships for this application. Indicate the $mi\frac{n}{m}ax$ cardinalities for the

relationships.

Draw a conceptual model using Crow's Feet Notation