Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Database Systems Assume that you are required to design and develop a computatio

ID: 662924 • Letter: D

Question

Database Systems

Assume that you are required to design and develop a computational system for a florist inventory that is already executed manually. In this system, there are three storage units with the following content: A Flower unit that is used to define the flowers being sold with the properties as ItemID, ItemName, NumberOfItems, UnitPrice, Date brought in to the florist, and the maximumLifeTime of the flower. Another storage unit called Price is used to store the ItemID and the corresponding price for this item. The last storage unit is called the Sales unit, which contains the 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 the described scheme if you use a simple programming language and files only? Please explain your design in detail (what type of programming components

Explanation / Answer

==================================================================================
1. A.) (10 POINTS) How would you design the described scheme if you use a simple
programming language and files only? Please explain your design in detail
(what type of programming components