Consider the following relation:
Chapter3: Data Representation
Section: Chapter Questions
Problem 3RP
Related questions
Question
![Consider the following relation:
TempID
111
222
333
444
555
666
TempName
Joe
Mike
Sue
Pat
Bob
Joe
TemplD
JobID
J111
J222
J333
J444
J555
J666
TempName
TEMP AGENCY
Job TypelD
T1
T2
T1
JobID
T2
T1
T2
Job TypeDesc
Bookkeepiing
Answering calls
Bookkeepiing
Answering calls
Bookkeepiing
Answering calls
• Each job has one job type, but multiple jobs can have the same job type
• Each job is assigned to one employer. Same employer can have multiple jobs.
5a) In the figure below, indicate functional dependencies by drawing lines with arrows. -|
Some of the requirements that this table is based on are as follows:
• Each temporary worker has a unique TempID, and a non-unique TempName.
• Each employer has a unique EID, and a non-unique EName.
• Each job has a unique JobID, and a job type.
• Each job type has a unique JobTypeID and a non-unique job type description (JobTypeDesc).
• Each temporary worker is assigned to only one job.
EID
E1
E1
E2
E2
E2
E1
Job TypeID Job TypeDesc
Ename
Mid Bank
Mid Bank
EID
Espoo Comm
Espoo Comm
Espoo Comm
Mid Bank
Ename
5b) Normalize the relation TEMP AGENCY to the second normal form (2NF). Show column names
(underline primary keys) and functional dependencies. DRAW THE TABLES
5c) Normalize the relation TEMP AGENCY to the third normal form (3NF). Show column names
(underline primary keys) and functional dependencies. DRAW THE TABLES](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fb0d66dc0-1c3b-42e6-bb49-ccb468aa5922%2F10cd33d7-c4e1-4f61-b166-3ac03d339805%2F60go8xm_processed.png&w=3840&q=75)
Transcribed Image Text:Consider the following relation:
TempID
111
222
333
444
555
666
TempName
Joe
Mike
Sue
Pat
Bob
Joe
TemplD
JobID
J111
J222
J333
J444
J555
J666
TempName
TEMP AGENCY
Job TypelD
T1
T2
T1
JobID
T2
T1
T2
Job TypeDesc
Bookkeepiing
Answering calls
Bookkeepiing
Answering calls
Bookkeepiing
Answering calls
• Each job has one job type, but multiple jobs can have the same job type
• Each job is assigned to one employer. Same employer can have multiple jobs.
5a) In the figure below, indicate functional dependencies by drawing lines with arrows. -|
Some of the requirements that this table is based on are as follows:
• Each temporary worker has a unique TempID, and a non-unique TempName.
• Each employer has a unique EID, and a non-unique EName.
• Each job has a unique JobID, and a job type.
• Each job type has a unique JobTypeID and a non-unique job type description (JobTypeDesc).
• Each temporary worker is assigned to only one job.
EID
E1
E1
E2
E2
E2
E1
Job TypeID Job TypeDesc
Ename
Mid Bank
Mid Bank
EID
Espoo Comm
Espoo Comm
Espoo Comm
Mid Bank
Ename
5b) Normalize the relation TEMP AGENCY to the second normal form (2NF). Show column names
(underline primary keys) and functional dependencies. DRAW THE TABLES
5c) Normalize the relation TEMP AGENCY to the third normal form (3NF). Show column names
(underline primary keys) and functional dependencies. DRAW THE TABLES
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
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 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
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
![Systems Architecture](https://www.bartleby.com/isbn_cover_images/9781305080195/9781305080195_smallCoverImage.gif)
Systems Architecture
Computer Science
ISBN:
9781305080195
Author:
Stephen D. Burd
Publisher:
Cengage Learning
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)
![Systems Architecture](https://www.bartleby.com/isbn_cover_images/9781305080195/9781305080195_smallCoverImage.gif)
Systems Architecture
Computer Science
ISBN:
9781305080195
Author:
Stephen D. Burd
Publisher:
Cengage Learning
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)