RELATION_DEPT_YEAR(DEPT_NAME,_TOTAL_INST_2007,_TOTAL_INST_2008,_TOTAL_

1.
RELATION_DEPT_YEAR(DEPT_NAME,_TOTAL_INST_2007,_TOTAL_INST_2008,_TOTAL_INST_2009)._HERE_THE_ONLY_FUNCTIONAL_DEPENDENCIES_ARE_FROM_DEPT_NAME_TO_THE_OTHER_ATTRIBUTES._THIS_RELATION_IS_IN?$

A. Fourth NF

B. BCNF

C. Third NF

D. Second NF

Answer» C. Third NF

Discussion

No Comment Found

Related MCQs

RELATION_DEPT_YEAR(DEPT_NAME,_TOTAL_INST_2007,_TOTAL_INST_2008,_TOTAL_INST_2009)._HERE_THE_ONLY_FUNCTIONAL_DEPENDENCIES_ARE_FROM_DEPT_NAME_TO_THE_OTHER_ATTRIBUTES._THIS_RELATION_IS_IN?$

Representations such as the in the dept year relation, with one column for each value of an attribute, are called _______ they are widely used in spreadsheets and reports and in data analysis tools.$

Thus a _______ of course data gives the values of all attributes, such as title and department, of all courses at a particular point in time.$

In the schema (dept name, size) we have relations total inst 2007, total inst 2008. Which dependency have lead to this relation ?

Designers use which of the following to tune the performance of systems to support time-critical operations?

What is the best way to represent the attributes in a large database?

Suppose the user finds the usage of room number and phone number in a relational schema there is confusion.This is reduced by

In which of the following, a separate schema is created consisting of that attribute and the primary key of the entity set.

Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set.

If a multivalued dependency holds and is not implied by the corresponding functional dependency, it usually arises from one of the following sources.

1.	RELATION_DEPT_YEAR(DEPT_NAME,_TOTAL_INST_2007,_TOTAL_INST_2008,_TOTAL_INST_2009)._HERE_THE_ONLY_FUNCTIONAL_DEPENDENCIES_ARE_FROM_DEPT_NAME_TO_THE_OTHER_ATTRIBUTES._THIS_RELATION_IS_IN?$
A.	Fourth NF
B.	BCNF
C.	Third NF
D.	Second NF
Answer» C. Third NF

RELATION_DEPT_YEAR(DEPT_NAME,_TOTAL_INST_2007,_TOTAL_INST_2008,_TOTAL_INST_2009)._HERE_THE_ONLY_FUNCTIONAL_DEPENDENCIES_ARE_FROM_DEPT_NAME_TO_THE_OTHER_ATTRIBUTES._THIS_RELATION_IS_IN?$

Discussion

No Comment Found

Related MCQs

Reply to Comment