Database QuestionsSolution1option AThe dependency of an attr

Database Questions:

Solution

1)option A:The dependency of an attribute on a set of attributes is known as trivial functional dependency if the set of attributes includes that attribute.

option c:

A Functional Dependency in which one or more non key attributes are functionally depending on a part of the primary key is called partial functional dependency. or

where the determinant consists of key attributes, but not the entire primary key, and the determined consist of non-key attributes.

option b:

A functional dependency P Q is full functional dependency if removal of any attribute A from P means that the dependency does not hold any more. or

In a relation R, an attribute Q is said to be fully functional dependent on attribute P, if it is functionally dependent on P and not functionally dependent on any proper subset of P. The dependency P Q is left reduced, their being no extraneous attributes in the left hand side of the dependency.

If AD C, is fully functional dependency, then we cannot remove A or D. i.e. C is fully functional dependent on AD. If we are able to remove A or D, then it is not full functional dependency.

corrct is option b;

2 ans)

A table design is said to be in 3NF if both the following conditions hold:

An attribute that is not part of any candidate key is known as non-prime attribute.

ans in 3rd normal form

3 ans)A Delete Anomaly exists when certain attributes are lost because of the deletion of other attributes. For example, consider what happens if Student 333 is the last student to leave the class - All information about the class is lost.

4 ans) to add, replace, or remove attributes and their values in an existing entry. When you specifychangetype: modify, you must also provide one or more change operations to indicate how the entry is to be modified.

option d