$(10$ marks$)$

Task $2$: Choose any one of the following topics$/$cases given below to solve this task.

IT Service and Maintenance Company

Insurance Company

Airways Company

Food delivery company $($e$.$g$.$: Talabat$)$

$($Total: $40$ marks$)$

a$.$ Identify the data requirements for the selected topic. Data requirements can be collected from different sources like company website, newspapers etc. You are required to analyze the data requirements and give a detailed description of the scenario in not more than $100$ words. The details should clearly state the entities, attributes, and relationships with cardinalities. Give suitable in$-$text citations$/$ references wherever required.

$(10$ Marks$)$

b$.$ Construct Entity Relationship Diagram $($ERD$)$ as per the description provided in Task $2$a$.$

The ERD is expected to have:

i Minimum $3$ Entities with at least $3$ attributes each with appropriate key constraints

$(34=12$ Marks$)$