Build a context diagram for the system using Lucidchart or any other diagramming app, such as app.diagrams.net.

show a level 0 data flow diagram (DFD) which includes the high-level processes of the system and their relationships.

Decompose 2 number of processes from the level 0 DFD into more detailed level 1 DFD processes.

Identify the entities and their relationships in the system and document these relationships in an entity relationship diagram for the system.

Convert the entity relationship diagram into a relational database design, including database tables and their relationships to the third normal form.

Case study:

Tajevon Pvt Ltd, a business in Morocco produces a variety of organic products such as jams, pickles, vinegars, olive oils, seed and oil nuts and much more. Adam is the prime share holder of this business and is also the CEO. Lately Adam has been realising that the company's sales are increasing exponentially. Basic marketing research suggests that there is also a huge overseas market. Adam feels that with the kind of resources that they have, this clearly is the time to go international. Oscar Sage is a business development lead at SysAgr Pvt Ltd which produces information systems for the agriculture industry. Oscar met Adam a few days back and Adam discussed with Oscar that he wants not only an information system for supply chain management for his international and national clients but also needs some software that can help optimise production. What Adam needs broadly is employee work hour management, management of medicines that are used at the farm for the plants, plant treatment tracking, plant management, inventory management, fertilizers management and life stock management. Some other things that he needs are order processing, warehouse management, supplier management, demand forecasting and an information system that supports analytics and reporting. Oscar clearly knows that Adam needs two information systems in one. He knows that Adam wants a customised system that is partly an agriculture information system and partly helps with supply chain management. Adam had requested Oscar to provide a detailed proposal that presents business requirements and the detailed solution. Oscar has agreed to provide this to Adam but knows that before providing the prototype and business requirements to the client he needs to conduct a detailed system analysis and have a preliminary design in place. Adam is not very sure about who will use the system and how? Oscar will also be doing requirement development on top of business analysis, requirement gathering and system analysis and design.