Analyze the situation and design the required tables

Central store is a retail supermarket working 24 hours a day; it contains most of food products. It is deemed important to enhance the system. The manager sent a request to IT Company to explain the benefits of a computerized system. Answer the following:

a) Analyze the above scenario and discuss the three-schema architecture for data abstraction. (5 marks 2 pts for definition and 3 pts for different view levels)

b) Based on above scenario, you are required to submit comprehensive report which should contain the Benefits of each Database models. (5 marks)

Do it in a neat paper with your own computer type