STUDENT$\_$INTERNSHIP

StudentID StudentName EmployerID EmployerName PositionID PositionDescription

$111$ Joe A Axel Alarm $1$ Sales Intern

$222$ Mike A Axel Alarm $2$ IT Help Desk Intern

$333$ Sue B Banex Inc $2$ Sales Intern

$444$ Pat B Banex Inc $1$ Front Desk Intern

$555$ Bob B Banex Inc $1$ Front Desk Intern

$666$ Joe C Calypso Corp $1$ Marketing Intern

The STUDENT INTERNSHIP table reflects these business rules regarding student internships:

Each student has a unique Student ID and a Student Name.

Each employer has a unique Employer ID and an Employer Name.

Within each employer, there are positions available. Each position has a unique Position ID within an employer and a Position Description $($positions from different employers can have the same ID$).$

Each student can work for only one employer and can hold only one position within that employer.

More than one student can work in the same position at the same employer

How many Full Dependencies are in this table?

How many Partial Dependencies are in this table?

How many Transitive Dependencies are in this table?