1. An employment agency offers the service of finding the employee candidates for their clients. For this purpose, the agency has to keep track of certain particulars of the candidates such as the name, identification card numbers, address, phone numbers, data of birth, and their field of expertise. They also keep the data of their clients which is the future employer for the candidate's employee. The request for employee is forwarded to the agency by future employer along with the information regarding to the job offered. The information includes the type of jobs, offered salary, type of expertise required and the date when the employee is needed. Therefore, as a database designer, you are required to propose a database design prior to its implementation by presenting the following: (a) Identify ALL possible entities that could exist in the organization process (give suitable entity name), complete all the entities with suitable attributes together with assigned primary key. Use your own assumption to determine the attributes. (b) Identify ALL relationships, cardinality, and participation for each related entity. an Entity Relationship Diagram (ERD) by clearly stating the relationships between entities and attributes with correct notation.
1. An employment agency offers the service of finding the employee candidates for their clients. For this purpose, the agency has to keep track of certain particulars of the candidates such as the name, identification card numbers, address, phone numbers, data of birth, and their field of expertise. They also keep the data of their clients which is the future employer for the candidate's employee. The request for employee is forwarded to the agency by future employer along with the information regarding to the job offered. The information includes the type of jobs, offered salary, type of expertise required and the date when the employee is needed. Therefore, as a database designer, you are required to propose a database design prior to its implementation by presenting the following: (a) Identify ALL possible entities that could exist in the organization process (give suitable entity name), complete all the entities with suitable attributes together with assigned primary key. Use your own assumption to determine the attributes. (b) Identify ALL relationships, cardinality, and participation for each related entity. an Entity Relationship Diagram (ERD) by clearly stating the relationships between entities and attributes with correct notation.
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
Question
Transcribed Image Text:An employment agency offers the service of finding the employee candidates for
their clients. For this purpose, the agency has to keep track of certain particulars
of the candidates such as the name, identification card numbers, address, phone
numbers, data of birth, and their field of expertise. They also keep the data of
their clients which is the future employer for the candidate's employee. The
request for employee is forwarded to the agency by future employer along with the
information regarding to the job offered. The information includes the type of jobs,
offered salary, type of expertise required and the date when the employee is
needed.
Therefore, as a database designer, you are required to propose a database design
prior to its implementation by presenting the following:
(a) Identify ALL possible entities that could exist in the organization process (give
suitable entity name), complete all the entities with suitable attributes
together with assigned primary key. Use your own assumption to determine
the attributes.
(b) Identify ALL relationships, cardinality, and participation for each related
entity.
an Entity Relationship Diagram (ERD) by clearly stating the
relationships between entities and attributes with correct notation.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 4 steps with 1 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education