Question
After examining the table carefully identify the functional dependences Identify the candidate keys Put the previous relation (table) in a normalized Boyce-Codd Normal Form (BCNF)
- After examining the table carefully identify the functional dependences
- Identify the candidate keys
- Put the previous relation (table) in a normalized Boyce-Codd Normal Form (BCNF)
- If you have multiple values for the department phone number what will be the best solution to convert the data into relations.
- Secure the database by creating a third relation (table) for data users identifying the fields needed (you can assume the level of user access as needed) ***PLEASE ANSWER ALL 5 QUESTIONS, MAKING TABLES WOULD HELP TREMENDOUSLY AS WELL***
| Employee ID | First Name | Last Name | | Title | Address | Extension | Department | Department ID | Hiring Date | Department Phone # |
| 0001 | John | Smith | jsmith@yahoo.com | Accountant | 1300 West st | 5775 | Accounting | 2100 | 8/1998 | 407-366-5700 |
| 0002 | Brian | Miller | badams@hotmail.com | Admin Assistant | 1552 Palm dr | 5367 | Human resource | 2300 | 4/1995 | 407-366-5300 |
| 0003 | James | Miller | miller@yahoo.com | Inventory Manager | 2713 Buck rd | 5432 | Production | 2520 | 8/1998 | 407-366-5400 |
| 0004 | John | Jackson | jackson_sam@hotmail.com | Sales Person | 433 tree dr | 5568 | Sales | 2102 | 6/1997 | 407-366-5500 |
| 0005 | Robert | Davis | Davis@yahoo.com | Manager | 713 corner st | 5642 | Production | 2520 | 1/2001 | 407-366-5400 |
| 0006 | Paul | Thompson | thompsonp@yahoo.com | Market Analyst | 205 Bridge dr | 5744 | Marketing | 2101 | 5/2003 | 407-366-5600 |
| 0007 | Sandy | Davis | SDavis@yahoo.com | Manager | 713 Corner st | 5702 | Accounting | 2100 | 11/1999 | 407-366-5700 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started