Q. The concept in normalization of relations which is based on the full functional dependency is classified as

View solution

Q. In the tuples, the interpretation of the values of the attribute is considered as

View solution

Q. The rule which states that set of attributes determines any of its subset is classified as

View solution

Q. The rule that always generate true dependencies is called

View solution

Q. In the __________ normal form, a composite attribute is converted to individual attributes.

View solution

Q. A table on the many side of a one to many or many to many relationship must:

View solution

Q. Tables in second normal form (2NF):

View solution

Q. Which-one ofthe following statements about normal forms is FALSE?

View solution

Q. Functional Dependencies are the types of constraints that are based on______

View solution

Q. Which is a bottom-up approach to database design that design by examining the relationship between attributes:

View solution

Q. Which forms simplifies and ensures that there is minimal data aggregates and repetitive groups:

View solution

Q. Which forms has a relation that possesses data about an individual entity:

View solution

Q. Which forms are based on the concept of functional dependency:

View solution

Q. Empdt1(empcode, name, street, city, state,pincode).

For any pincode, there is only one city and state. Also, for given street, city and state, there is just one pincode. In normalization terms, empdt1 is a relation in

View solution

Q. We can use the following three rules to find logically implied functional dependencies. This collection of rules is called

View solution

Q. Which of the following is not a Armstrong’s Axiom ?

View solution

Q. The relation employee(ID,name,street,Credit,street,city,salary) is decomposed into

employee1 (ID, name)
employee2 (name, street, city, salary)

This type of decomposition is called

View solution

Q. Inst_dept (ID, name, salary, dept name, building, budget) is decomposed into

instructor (ID, name, dept name, salary)
department (dept name, building, budget)

This comes under

View solution

Q. There are two functional dependencies with the same set of attributes on the left side of the arrow:

A->BC
A->B

This can be combined as

View solution

Q. Consider a relation R(A,B,C,D,E) with the following functional dependencies:

ABC -> DE and
D -> AB

The number of superkeys of R is:

View solution