YOU CAN POST A PICTURE OF THE ANSWER IF YOU WANT: A large corporation sends its
ID: 3677819 • Letter: Y
Question
YOU CAN POST A PICTURE OF THE ANSWER IF YOU WANT:
A large corporation sends its Human Resource personnel to outside vendors for training in specific employee-oriented skills. Because the corporation is spread out geographically, it uses vendors in different locations. Some of those vendors offer trainings in the same skill areas. The Human Resources Department of the company has the information on the trainers in the following relation with this data:
Training ID
Description
Vendor
Vndr_Location
Session Price
SUP20
Employee Supervision
WeManage
NYC, NY
$595
SUP20
Employee Supervision
People Power
Stamford, CT
$525
EMP90
Employment Law
Visionary Resources
NYC, NY
$600
EMP90
Employment Law
WeManage
NYC, NY
$695
EMP90
Employment Law
Labor League
Hoboken, NJ
$595
LAN40
Labor Negotiation
WeManage
NYC, NY
$495
1) List the functional dependencies of this relation;
2) Normalize this relation to Third Normal Form
Training ID
Description
Vendor
Vndr_Location
Session Price
SUP20
Employee Supervision
WeManage
NYC, NY
$595
SUP20
Employee Supervision
People Power
Stamford, CT
$525
EMP90
Employment Law
Visionary Resources
NYC, NY
$600
EMP90
Employment Law
WeManage
NYC, NY
$695
EMP90
Employment Law
Labor League
Hoboken, NJ
$595
LAN40
Labor Negotiation
WeManage
NYC, NY
$495
Explanation / Answer
Please find the answers below :
1) The functional dependency in this relation are :
{Vendor}{Vndr_Location},{Traning id}{Description}
2) In Third Normal Form
Vendor
Training
Training Vendor_id Session Price 1 1 $595 1 2 $525 2 3 $600 2 1 $695 2 4 $595 3 1 $495Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.