_____________ can help us detect poor E-R design.

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

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

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

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

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

Emp(emp code, name, street, city, state, pin code).

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

Which of the following is not an Armstrong’s Axiom?

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_____________.

The result of which operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match?

The union operation is represented by

Foreign key is the one in which the ________ of one relation is referenced in another relation.

Select operation in SQL is equivalent to____________

Consider the join of a relation R with a relation S. If R has m tuples and S has n tuples, then the maximum and minimum sizes of the join respectively are ________________.

The _________ provides a set of operations that take one or more relations as input and return a relation as an output.