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

Q. Suppose we wish to find the ID’s of the employees that are managed by people who are managed by the employee with ID 123. Here are two possible queries:

I.SELECT ee.empID

FROM Emps ee, Emps ff

WHERE ee.mgrID = ff.empID AND ff.mgrID = 123;

II.SELECT empID

FROM Emps

WHERE mgrID IN

(SELECT empID FROM Emps WHERE mgrID = 123);

Which, if any, of the two queries above will correctly (in SQL2) get the desired set of employee ID’s?

View solution

Q. 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;

View solution

Q. Suppose now that R(A,B) and S(A,B) are two relations with r and s tuples, respectively (again, not necessarily distinct). If m is the number of (not necessarily distinct) tuples in the result of the SQL query:

R intersect S;

Then which of the following is the most restrictive, correct condition on the value of m?

View solution

Q. Suppose relation R(A,B,C,D,E) has the following functional dependencies:
A -> B

B -> C

BC -> A

A -> D

E -> A

D -> E

Which of the following is not a key?

View solution

Q. The normal form which satisfies multivalued dependencies and which is in BCNF is

View solution

Q. Which of the following is a tuple-generating dependencies ?

View solution

Q. The main task carried out in the __________ is to remove repeating attributes to separate tables.

View solution

Q. Which of the normal form is based on multivalued dependencies ?

View solution

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

View solution

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

View solution

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

View solution

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

View solution

Q. Fifth Normal form is concerned with

View solution

Q. In 2NF

View solution

Q. _____________ can help us detect poor E-R design.

View solution

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

View solution