Question
Consider the following employee record in an organization
Employee (ID, name, date of joining, age, address, department, manager, ID’s of projects working on, role in the project, project name, project team leader, duration of project, dependent names)
An employee works in one department. Each department is managed by one manager. An employee can work on many projects. A projects has team leader. An employee can have many departments, however, one department can be related to only one employee.
Identify the functional dependencies in the relation given above. Normalize the relational up to BCNF. Make suitable assumptions, if any
Answer :
Word Count : 34
________ ____ _____ __________ _______ ___.
____ ______ _______ ________ ____.
_____ _________ ___ ______ _____ ____ ______ _______ ____.
_________ ____ ____ ______ _____ ____ __________.
Skip in 10
Some relations schemas, even
____ ______ _______ ________ ____.
_____ _________ ___ ______ _____ ____ ______ _______ ____.
_________ ____ ____ ______ _____ ____ __________.
IGNOU ACADEMY
Your IGNOU journey, made easier.
- Solved Assignments
- Study Notes
- Guess Papers
- Question Papers
Continue Reading — It's Free
Sign in with Google to unlock more of this answer.
✓ Free access
✓ Unlock up to 60% of the answer
✓ No payment required
✓ Unlock up to 60% of the answer
✓ No payment required
Quick Google sign-in. No separate registration form.