MGMT SS STATS, an umbrella body that facilitates and serves various Social Security Organizations/Departments within the Caribbean territories, stood poised to meet the needs of its stakeholders by launching an online database. The database will provide members and the public access to the complete set of services that can (also) be initiated face-to-face, and it will provide managed, private, secure access to a repository of public and/or personal information. Ideally, the database will have basic details of pension plans recorded in the registry, member plan statistics, and cash inflows and outflows from pension funds.For example, insured persons accumulate contributions. Records for these persons will include information on the insured persons able to acquire various benefits once work is interrupted due to sickness, death, retirement, and maternity or employment injury. They will also include information on pensions such as invalidity, disability, and survivors that stem from one of the above.Members of the umbrella body, who are required to sign in, can submit requests for services, review active requests, or post comments/complaints on past or current requests online directly into the database. Visitors to the database can search for products and services, read other comments or complaints, and view advice provided by MGMT SS STATS.As a new employee of MGMT SS STATS assigned to the Management Information Systems Department, your manager wants you to design, develop, and produce reports related to pension plans in preparation for the website's public launch. Tasks:1. TABLES (Data Sets / Entities / Relations)a) Identify three (3) primary Tables you would want to have based on the case background.b) Justify why each table is necessary for the developing system.2. For EACH of the tables identified at (#1) abovea) List 3–4 data elements that can be stored and explain the role/purpose of each in your developing database system. Indicate, with a brief explanation, what you would use as the primary keys.b) As part of your listed data elements, define the following metadata for each: Data/Field Type, Field Size, and any possible constraint/s or neededc) Identify and describe the relationship/s among the tables. Please provide an example to illustrate Referential Integrity and explain why it is essential for data credibility.3. Since your manager desires several business reports, justify with an explanation three (3) queries you will likely make regarding the reports' creation. For one (1) report, indicate what type of business report it is (NB! Research Types of Business Reports), outline the layout and possible content relevant to the case scenario and which Management level and Functional area, with justification, would be best served by this report.4. Design diagrammatically a Form layout with a Subform that facilitates data entry for your database system. Provide a brief description of the form's purpose and functionality.5. Identify a feature of MS Access to ensure end-users have a centralised area for accessing and completing tasks. Explain how this feature enhances usability and efficiency.6. Design and draw a high-level "as-is" process diagram that illustrates a current process related to a product or service offered.7. Data Analytics:a) design a Dashboard with three (3) elements that you think would be useful to the company in providing prudent system analytics. Justify the selection of the three (3) elements and how they contribute to decision-making.