Q. State true or false: If a relational schema is in _______ NF and A is a subset of R and B is also a subset of R then it is that A is a superkey is a trivial multi values dependency.

View solution

Q. Which of the following normal forms does not exist?

View solution

Q. Choose the correct statement regarding superkeys

View solution

Q. What is an Instance of a Database?

View solution

Q. What is a foreign key?

View solution

Q. What action does ⋈ operator perform in relational algebra

View solution

Q. What does the “x” operator do in relational algebra?

View solution

Q. An attribute is a __________ in a relation.

View solution

Q. What is the method of specifying a primary key in a schema description?

View solution

Q. Statement 1: A tuple is a row in a relation
Statement 2: Existence of multiple foreign keys in a same relation is possible

View solution

Q. Choose the option that correctly explains in words, the function of the following relational algebra expression:
σyear≥2009 (book ⋈ borrow)

View solution

Q. State true or false: If a relation consists of a foreign key, then it is called a referenced relation of the foreign key dependency.

View solution

Q. Which of the following is not a feature of a good relational design?

View solution

Q. The dependency rules specified by the database designer are known as _______

View solution

Q. If the decomposition is unable to represent certain important facts about the relation, then such a decomposition is called as?

View solution

Q. If the decomposition is able to represent all the facts about the relation then such a decomposition is called as?

View solution

Q. A domain whose elements are indivisible is called as ______

View solution

Q. If all the domains are atomic then the relational schema is in ________ normal form

View solution

Q. State true or false: Composite attributes have non-atomic domains.

View solution

Q. State true or false: Redundancy is desired in a relational schema

View solution