MGMT SS STATS, an umbrella body that facilitates and serves various Social SecurityOrganizations/Departments within the Caribbean territories, stoodpoised to meet the needs of its stakeholders by launching an onlinedatabase at www.SSDCI.gov. The database will provide membersand 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 ofpublic and/or personal information. Ideally, the database will have basic details of pensionplans recorded in the registry, member plan statistics, and cash inflows and outflows frompension funds.For example, insured persons accumulate contributions. Records for these persons will includeinformation on the insured persons able to acquire various benefits once work is interrupteddue to sickness, death, retirement, and maternity or employment injury. They will also includeinformation on pensions such as invalidity, disability, and survivors that stem from one of theabove.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 directlyinto the database. Visitors to the database can search for products and services, read othercomments or complaints, and view advice provided by MGMT SS STATS.As a new employee of MGMT SS STATS assigned to the Management Information SystemsDepartment, your manager wants you to design, develop, and produce reports related topension plans in preparation for the website's public launch. Database Tables Overview of Key Tables MGMT SS STATS will need to have various tables in their database platform. Three key tables they will need to include are: Members (Insured Persons): This will provide information of individuals who are members of MGMT SS STATS database. Pension Plans: This will show the different categories of pension plans offered by MGMT SS STATS Claims Table: This table will deal will request for all pension benefits offered by MGMT SS STATS such as retirement and survivors’ plan. Justification for Table Selection Each table is essential for MGMT SS STAT database: This is one of the most important tables on the platform. It helps tracks contributions, personal information to differentiate the members on the system. Without this the system wouldn’t be able to function. Some of the fields in this table would be first and last name, date of birth, address, contact information, email etc. Pension Plans: This provides a central location for stored information on each pension plan offered. The type of information that will be stored includes eligibility criteria, benefits and contribution rates. This will make the process of managing pension funds easier. Claims: Each member will qualify for different categories of pension based on certain criteria like age, job, contributions etc. This table will help MGMT SS STAT track the contribution and other criteria’s before approving a claim. It also provides a smooth and fast process in the system. For Each of the tables mentioned above answer this ) List 3–4 data elements that can be stored and explain the role/purpose of each in yourdeveloping database system. Indicate, with a brief explanation, what you would use asthe primary keys.b) As part of your listed data elements, define the following metadata for each: Data/FieldType, Field Size, and any possible constraint/s or needed