Is this a transitive dependency?
I have this simplified table:
The business states that anyone with a role_id of 3 needs to have a leader_id, while anyone with any other value for role_id should not have a leader_id (null).
By knowing the value of leader_id we now narrow down the possible values for role_id. Have I unwillingly created a transitive dependency between leader_id and role_id?
No it is not a transitive-dependency : the role alone doesn't provide you with enough information to find the leader; also, the leader alone doesn't provide enough information to find the role (for null values).
A transitive-dependency means that you must be able to discover a value X from another value Y with a perfect score.
For exemple, if you know the City, you obviously know the Country as well, you don't have to create two columns (city and country), you only need the city, and by using the transitive-dependency, you will get the country.
- Math.Sin() gives incorrect value
- How to run my python script when the sunOS is start booting
- Express-session: not resetting cookie expiration on each request
- Getting a stack overflow exception when normalizing a vector
- Edit default summary function in R gives error for multiple variables
- What was a For loop? Why isn't it needed in R?
- How to use download button in shiny and save results in various formats (csv, texte, pdf, spss...)?
- Why are there two assignment operators, `<-` and `->` in R?
- lm()$assign: what is it?
- How to get the value of list(...) in R and S functions
- Design matrix for MLM from library(lme4) with fixed and random effects
- how to generate elements not included in my sample
- Create a matrix with gradually changing values without a for loop
- Emacs ESS and S-plus ( S+ ) 8.1 compatability
- How to lag date-index in a time-series in R?
- Nonlinear regression in R / S
- Calling R from S-Plus?