Question : Figure two tables: environments and branches. Their relationship is: one environment has many branches. This is easy with […]
Tag: dependencies
list of views that depend on a given table and column
Question : I need a script to check if a given column in a given table is used in any […]
If A and B are candidate keys, then AB is candidate key or not ?
Question : If R{abc} is a relation, f{ a->b b->a a->c b->c }, then a and b are candidate keys. […]
Apply Definition of MVD (multivalued dependency) to Example?
Question : Supposedly this multivalued dependency (MVD) and this functional dependency (FD): {W} ↠ {N,D} and {W} → {N} hold […]
What permissions are needed to view dependencies?
Question : My company is moving to a much more restrictive security model in the near future. As part of […]
Can you determine a functional dependency on a single attribute table?
Question : If an attribute is independent is it possible for it to still have a functional dependency? For example, […]
What exactly is overlapping candidate key?
Question : Can some one please explain to me in simple terms what is overlapping candidate key ? What is […]
Converted ERD into Dependency Diagram 1NF, 3NF
Question : Thats the ERD. I’m studying for an upcoming test and having trouble getting my head around converting this […]
Question concerning minimal/cannonical cover
Question : For the question above, I am confused with how to approach simplifying the left hand side of BDCE->A. […]
Find the functional dependencies that hold in a relation
Question : There is a question in my book that asks the following: Suppose we have relation R ( A […]