Roland UDVARLAKI
Unit 3 - Information Systems
P6 - select information to support a business decision-making process
Roland UDVARLAKI – Unit 3 – Assignment 3 – P6, P7, M3, D2 – Page 1 of 20
, Roland UDVARLAKI
Information Systems:
Information systems are basically databases. They store a wide variety of records in a most logical,
organised way that can be searched and filtered to find, understand information that is stored within
the system. A big advantage of using electronic information system is that it can be available at any
time at any place around the world. By having it available in an electronic format, it lets employees
maintain it and keep it up to date more easily and with less effort.
Databases can be manipulated and used with many other software tools helping companies better
organise and understand the way they operate and manage their various departments, employees,
clients etc.
Information required (What information is needed for the IS?)
For the database that I have created for NWEA, I have used the 8 most important titles: Job Vacancy,
Consultant, Client, Placement, Applicant, Time Sheet, Performance report, CV. All of these tables
have their own primary keys linked to each other’s tables (where required) to help each other and to
get better results by representing data on one table and from the original one.
To make the information system a working database, it needs different information about people and
companies. It needs information about job titles, their requirements, hourly rates, shift types and
preferably a job description to explain what the job is about for the applicant, this is so they can
decide if it’s suitable for them or not.
Consultants would have their own unique Consultant ID. They would contain first and surnames,
addresses, city/town details, county, postcodes and Date of Birth information. This is so they can be
manageable in an easier way and their information can be looked up at any time and can be
contacted easily.
The Client module would hold information about the company name, recruiter or contact’s person, a
phone number, an address, job sector for easier filtering, an email address where the company can
be reached and business hours so they can be contacted at times when they are fully functional and
operating normally.
The placement module would contain a Placement ID, Applicant’s ID, the client’s information and the
job where the applicant would work at. Placement date, start and end dates as well as
temporary/permanent section would be dedicated to make decisions and to see through the many
type of data more easily.
The CV module would store information about the Applicant’s CV. This would include information
such as: Their names, their addresses, town/cities they are currently living in, county where their
cities/town is placed, postcode, applicant details to identify them easier, qualifications to see if they
are suitable for jobs, experience to see if they are suitable for certain jobs that may require previous
experience in a certain job role/type and skills to identify their skillset and to put them into the right
job roles where they would be the most suitable.
The performance report would only contain the Applicant’s ID to make it easier to identify them. The
Placement ID would be used for the same, identification. Comments on work performance would
also be added in order to track the applicant’s performance from time to time, this would let
managers and clients decide if they want the person to come to work or not.
The Time sheet would hold information of the Applicant’s ID, Placement ID and Client ID. All of these
combined would give a short but valuable identification and details to managers and responsible
Roland UDVARLAKI – Unit 3 – Assignment 3 – P6, P7, M3, D2 – Page 2 of 20
Unit 3 - Information Systems
P6 - select information to support a business decision-making process
Roland UDVARLAKI – Unit 3 – Assignment 3 – P6, P7, M3, D2 – Page 1 of 20
, Roland UDVARLAKI
Information Systems:
Information systems are basically databases. They store a wide variety of records in a most logical,
organised way that can be searched and filtered to find, understand information that is stored within
the system. A big advantage of using electronic information system is that it can be available at any
time at any place around the world. By having it available in an electronic format, it lets employees
maintain it and keep it up to date more easily and with less effort.
Databases can be manipulated and used with many other software tools helping companies better
organise and understand the way they operate and manage their various departments, employees,
clients etc.
Information required (What information is needed for the IS?)
For the database that I have created for NWEA, I have used the 8 most important titles: Job Vacancy,
Consultant, Client, Placement, Applicant, Time Sheet, Performance report, CV. All of these tables
have their own primary keys linked to each other’s tables (where required) to help each other and to
get better results by representing data on one table and from the original one.
To make the information system a working database, it needs different information about people and
companies. It needs information about job titles, their requirements, hourly rates, shift types and
preferably a job description to explain what the job is about for the applicant, this is so they can
decide if it’s suitable for them or not.
Consultants would have their own unique Consultant ID. They would contain first and surnames,
addresses, city/town details, county, postcodes and Date of Birth information. This is so they can be
manageable in an easier way and their information can be looked up at any time and can be
contacted easily.
The Client module would hold information about the company name, recruiter or contact’s person, a
phone number, an address, job sector for easier filtering, an email address where the company can
be reached and business hours so they can be contacted at times when they are fully functional and
operating normally.
The placement module would contain a Placement ID, Applicant’s ID, the client’s information and the
job where the applicant would work at. Placement date, start and end dates as well as
temporary/permanent section would be dedicated to make decisions and to see through the many
type of data more easily.
The CV module would store information about the Applicant’s CV. This would include information
such as: Their names, their addresses, town/cities they are currently living in, county where their
cities/town is placed, postcode, applicant details to identify them easier, qualifications to see if they
are suitable for jobs, experience to see if they are suitable for certain jobs that may require previous
experience in a certain job role/type and skills to identify their skillset and to put them into the right
job roles where they would be the most suitable.
The performance report would only contain the Applicant’s ID to make it easier to identify them. The
Placement ID would be used for the same, identification. Comments on work performance would
also be added in order to track the applicant’s performance from time to time, this would let
managers and clients decide if they want the person to come to work or not.
The Time sheet would hold information of the Applicant’s ID, Placement ID and Client ID. All of these
combined would give a short but valuable identification and details to managers and responsible
Roland UDVARLAKI – Unit 3 – Assignment 3 – P6, P7, M3, D2 – Page 2 of 20
