Question
Below is a schema (a relationship schema named dept_advisor) on which some functional dependencies (FDs) must hold: i_ID ? dept_name s_ID , dept_name ? i_ID?
Below is a schema (a relationship schema named dept_advisor) on which some functional dependencies (FDs) must hold:
i_ID ? dept_name s_ID , dept_name ? i_ID?
For these FDs to hold, we may need to use decomposition. So, first try with Boyce-Codd Normal Form (BCNF) decomposition to break down the relationship (dept_advisor) into two. If your BCNF decomposition does not satisfy the given FDs, use Third Normal Form (3NF) decomposition to break down it into two. Your results should be like: ( , , ) & ( , , ). Show me the results and explain why you use what you have used.
I am honestly lost on how to begin. I'm not sure how to break down dept-advisor into two. Any help to the above problem is appreciated.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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