0
-->non trivial functional dependency is totally opposite to the trivial functional dependency.
--> non trivial dependency means X-->Y that is if Y is not proper subset of X table or relation with X then it said to be non trivial functional dependency.
Add your answer:
Earn +20 pts
Examples of functional dependency in dbms?
a functionaly dependency is an association between two relational attribute of same relational database.one of the attribute is known as determinant and the other one is determined.for the each value of determinant there is only one value associated of determined. graphicaly it can be represented A----->B .
Is 0 a multiple of 3?
Zero is a multiple of any integer. We generally don't list it, using only the non-trivial multiples.
What is trivial set?
The word trivial means "useless". So a trivial set would be a useless set.
What is the square root in radical form of 273?
Since 273 has no non-trivial factor that is a square number, its square root cannot be simplified. It is √273.
Which is grater 5.130 or 5.13?
NEITHER . They are equal 5.13 = 5.130 The zero after then last decimal number is trivial and can be ignored. However, 5.13 & 5.013 the decimal zero is NOT trivial because there are numerical values to its right. Similarly 05.13 & 5.13 The prefix zero is trivial and can be ignored. However, 50.13 & 5.13 , the zero is no longer trivial , because the numbers are fifty and five. Hope that helps!!!!!
What is Trivial and Non Trivial Dependency?
Trivial functional dependencyA trivial functional dependency is a functional dependency of an attribute on a superset of itself. {Employee ID, Employee Address} → {Employee Address} is trivial, as is {Employee Address} → {Employee Address}.
What is non trivial dependency?
A DEPENDENCY X->Y IS SAID TO BE TRIVIAL DEPENDENCY IF Y IS A PROPER SUBSET OF X OTHERWISE NON TRIVIAL DEPENDENCY.
What is trivial dependency?
A DEPENDENCY X->Y IS SAID TO BE TRIVIAL DEPENDENCY IF Y IS A PROPER SUBSET OF X OTHERWISE NON TRIVIAL DEPENDENCY.
What is non dependence?
A DEPENDENCY X->Y IS SAID TO BE TRIVIAL DEPENDENCY IF Y IS A PROPER SUBSET OF X OTHERWISE NON TRIVIAL DEPENDENCY.
Fully functional dependency?
A functional dependency X --> Y is full functional dependency if removal of any attribute 'k' from X means that the dependency does not hold any more.Full functional dependency is minimal in size (contain non-redundant data)In a relation R , attribute B of R is fully functionallydependent on an attribute or set of attributes A of R , if B is functionally dependent on A, but not functionally dependent on any proper subset of A.ORAàB is a fully functionally dependency, if removal of any attribute X from A would result into the cancellation of dependency. i.e. (A-{X})-->B does not hold.
What is functional dependency in oracle?
In Oracle, functional dependency is when the value of one thing is completely determined by another thing. Functional dependency happens when one attribute determines another attribute in a relation.
Difference between partial dependency and fully functional dependency?
The difference is that partial dependency is when a database's attribute is only partially dependent on the primary key. Fully functional dependency is when the attribute is entirely dependent on the key.
Why 4NF is preferable then bcnf .with example?
Normalization is a process to reduce the redundancy by removing function dependencies BCNF (Boyece code normal form) has all functional dependencies A to B are trivial of discriminator should be superkey. To get relation in BCNF, Splitting the relation schema not neccessarily preserve all functional dependency, Loss less decomposition and dependency are main points for the normalization sometime, it is not possible to get a BCNF decomposition that is dependency, preserving. While 4NF has very similar definition as BCNF. A relational Schema is in 4NF, if all multivalued dependencies A to B are trivial and determinate A is superkey of schema. If a relational schema is in 4nf, it is already in BCNF. and 4NF decomposition preserve the all functional dependency. so 4NF is preferable than to have BCNF.
What is Transitive functional dependency?
A functional dependency X->Y is transitive in R, if there exists an attribute Z in R, such that X-> Z, Z-> Y .
What is difference between Partial Functional Dependency and Full Functional Dependency?
A functional dependency is defined as a constraint between two sets of attributes in a relation from a database.Given a relation R, a set of attributes X in R is said to functionally determine another attribute Y, also in R, (written X→ Y) if and only if eachX value is associated with at most oneY value.A functional dependency X --> Y is full functional dependency if removal of any attribute 'k' from X means that the dependency does not hold any more. Full functional dependency is minimal in size.Partial Functional Dependency Indicates that if A and B are attributes of a table, B is partially dependent on A if there is some attribute that can be removed from A and yet the dependency still holds.A key is a set of attributes that uniquely identifies an entire tuple, a function dependency allow us to express constraints that uniquely identify the values of certain attribute.
What is the opposite trivial?
non-trivial
Describe the purpose of normalizing data and also list out the dependencies involved in the process of normalization?
The purpose of normalizing data in DBMS is to reduce the data redundancy and increase the consistency of data. a) Partial dependency: non-prime attribute ( field) depends on other non-prime attributes b) Functional dependency c) Transitive dependency
