Bissoy.com
Doctors Medicines MCQs Q&A

A relation is in ____________ if an attribute of a composite key is dependent on an attribute of other composite key.

A relation is in ____________ if an attribute of a composite key is dependent on an attribute of other composite key. Correct Answer 3NF

A relation is in 3 NF if an attribute of a composite key is dependent on an attribute of other composite key. (If an attribute of a composite key is dependent on an attribute of other composite key then the relation is not in BCNF, hence it has to be decomposed.).

Related Questions

Consider the relational schema given below, where eId of the relation dependent is a foreign key referring to empId of the relation employee. Assume that every employee has at least one associated dependent in the dependent relation. Employee (empId, empName, empAge) Dependent(depId, eId, depName, depAge) Consider the following relational algebra query: ΠempId(employee)-ΠempId (employee⋈(empId = eID)∧(empAge ≤ depAge)dependent) The above query evaluates to the set of empIds of employees whose age is greater than that of
If an attribute of a composite key is dependent on an attribute of the other composite key, a normalization called _____ is needed.
An attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation.
The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as a primary key is called ______________
In a given relationship R, if an attribute A uniquely defines all other attributes, then the attribute A is a key attribute which is also known as the _________ key.
Consider the following statements related to composite mortar: 1. Addition of lime to cement mortar improves its workability 2. Composite mortar is obtained by adding 10% by weight of cement and mixing with water. 3. Composite mortar is not preferred in tall buildings 4. Mechanical grinding is essential for developing composite mortar. Which of the above statements are true in this case?
A relation in which every non-key attribute is fully functionally dependent on the primary key and which has no transitive dependencies is said to be in:
If every non-key attribute is functionally dependent primary key, then the relation will be in
A ________ on an attribute of a relation is a data structure that allows the database system to find those tuples in the relation that have a specified value for that attribute efficiently, without scanning through all the tuples of the relation.
Public key encryption uses multiple keys.ne key is used to encrypt data, while another is used to decrypt data.he key used to encrypt data is called the _______ key, while the key used to decrypt data is called the ________ key.