PPSC FPSC KPPSC BPSC SPSC Lecturer Computer Science Test 48

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

Suppose relation R(A,B) currently has tuples {(1,2), (1,3), (3,4)} and relation S(B,C) currently has {(2,5), (4,6), (7,8)}.

Then the number of tuples in the result of the SQL query:

Select *

From R Natural Outer Join S; is:

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:

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

A data type that creates unique numbers for key columns in Microsoft Access is:

Which forms are based on the concept of functional dependency:

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

R (A,B,C,D) is a relation. Which of the following does not have a lossless join dependency preserving BCNF decomposition.

The algorithm that takes a set of dependencies and adds one schema at a time, instead of decomposing the initial schema repeatedly is:

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

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

Which normal form is considered adequate for normal relational database design?

Which of the following is not a Armstrong‘s Axiom ?

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

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:

Tables in second normal form (2NF):

The functional dependency can be tested easily on the materialized view, using the constraints.............

A dependency exist between two columns when:

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

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

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

Which of the following is not a Armstrong‘s Axiom ?

Functional Dependencies are the types of constraints that are based on:

What are the desirable properties of a decomposition:

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