$1.)(45$ POINTS$)$ Assume that you are hired to design an automated system for a florist which

currently uses a manual system to perform business. For the florist, there are three storage

components with the following details:

$-$ Flower component that with properties ItemID, ItemName, NumberOfItems, UnitPrice,

Date brought in to the florist, and the maximumLifeTime of the flower.

$-$ Price component to store the ItemID and the corresponding price for this item, where item

is a flower.

$-$ Sales component with properties ItemID, NumberOfItemsSold, and the Unit Price.

The florist uses these storage units to maintain its inventory, and also calculate its daily

income.

$1.$A$.)(10$ POINTS$)$ How would you design an automated system for this florist by using files

only for a simple programming language? Please explain your design in detail $($what type of

programming components $$ structures, variables, data types, etc. $-$ you will use, what

programming language you would choose, why, etc.$)$

$1.$B$.)(25$ POINTS$)$ How would you design an automated system for this florist by using a

database? Please describe your ER model describing entities, relationships, attributes on

each, and the constraints on each relationship $($cardinality ratios, and participation

constraints$).$

$1.$C$.)(10$ POINTS$)$ Compare your design in A and B and specify which one is a better design

and why.