Using the table below, identify the functional dependences and cnd candidate key
ID: 3687220 • Letter: U
Question
Using the table below, identify the functional dependences and cnd candidate keys
Put the table in a Boyce-Codd Normal Form (BCNF)
Secure the database by creating a third relation for data users identifying the different level of access for each user (you can assume the level of user access as needed)
Employee ID
First Name
Last Name
Extension
Department
Department ID
Hiring Date
Department Phone #
0001
John
Smith
jsmith@yahoo.com
5775
Accounting
2100
8/1998
407-366-5700
0002
Brian
Miller
badams@gmail.com
5367
Human resource
2300
4/1995
407-366-5300
0003
James
Miller
miller@yahoo.com
5432
Sales
2520
8/1998
407-366-5400
0004
John
Jackson
jackson_sam@gmail.com
5568
Marketing
2002
6/1997
407-366-5500
0005
Robert
Davis
Davis@yahoo.com
5642
Production
2890
1/2001
407-366-5600
0006
Paul
Thompson
thompsonp@yahoo.com
5744
Accounting
2100
5/2003
407-366-5700
Employee ID
First Name
Last Name
Extension
Department
Department ID
Hiring Date
Department Phone #
0001
John
Smith
jsmith@yahoo.com
5775
Accounting
2100
8/1998
407-366-5700
0002
Brian
Miller
badams@gmail.com
5367
Human resource
2300
4/1995
407-366-5300
0003
James
Miller
miller@yahoo.com
5432
Sales
2520
8/1998
407-366-5400
0004
John
Jackson
jackson_sam@gmail.com
5568
Marketing
2002
6/1997
407-366-5500
0005
Robert
Davis
Davis@yahoo.com
5642
Production
2890
1/2001
407-366-5600
0006
Paul
Thompson
thompsonp@yahoo.com
5744
Accounting
2100
5/2003
407-366-5700
Explanation / Answer
The following attributes can be the candidate key of this relation:
1. (Employee ID)
2. (First Name, Last Name, email)
The functionl dependences are as follows:
{First Name}---->{email}
{Last Name}----->{email}
{Department}----->{Extension}
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.