A business case scenario and asked to formulate an appropriate software design solution. Theyshould complete the case and upload the solution. will be required to read the case,identify and document the key issues, problems, and opportunities presented, and then design,and develop an appropriate integrated design solution to the problem. mustdemonstrate good spreadsheet, database, analytical, and word-processing skills whendeveloping solutions. Additionally, must be creative and demonstrate synthesising andapplying Database Management and Data Analytics Principles learned in the course. They willalso need to research some aspects of the assessment. CASE BACKGROUNDMGMT 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. 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.

A business case scenario and asked to formulate an appropriate software design solution. They
should complete the case and upload the solution. will be required to read the case,
identify and document the key issues, problems, and opportunities presented, and then design,
and develop an appropriate integrated design solution to the problem. must
demonstrate good spreadsheet, database, analytical, and word-processing skills when
developing solutions. Additionally, must be creative and demonstrate synthesising and
applying Database Management and Data Analytics Principles learned in the course. They will
also need to research some aspects of the assessment.

CASE BACKGROUND
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 at www.SSDCI.gov. 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.

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.