Every time attribute A appears, it is matched with the same value of attribute B, but not the same value of attribute C. Therefore, it is true that:

Related MCQs

• The attribute name could be structured as an attribute consisting of first name, middle initial, and last name. This type of attribute is called
• The attribute name could be structured as an attribute consisting of first name, middle initial, and last name. This type of attribute is called
• Department (dept name, building, budget) and Employee (employee_id, name, dept name, salary) Here the dept_name attribute appears in both the relations. Here using common attributes in relation schema is one way of relating ___________ relations.
• Department (dept name, building, budget) and Employee (employee_id , name, deptname,salary) Here the dept_name attribute appears in both the relations .Here using common attributes in relation schema is one way of relating ___________ relations.
• 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.
• If every non-key attribute is functionally dependent on the primary key, the relation will be in
• If every non-key attribute is functionally dependent on the primary key, the relation will be in
• If every non-key attribute is functionally dependent primary key, then the relation will be in
• Which forms every non-prime attribute is fully dependent functionally on the candidate key of a relational schema:
• If every non-key attribute is functionally dependent on the primary key, then the relation will be in: