Guide me through how to create this using SQL$.$

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.