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

Q. An instance of a relation that satisfies all real world constraints is known as?

View solution

Q. If K → R then K is said to be the _______ of R

View solution

Q. X → Y holds on a schema k(K) if?

View solution

Q. X→ Y is trivial if?

View solution

Q. Which of the following is not a condition for X→ Y in Boyce codd normal form?

View solution

Q. Which of the following is used to express database consistency?

View solution

Q. Which of the following is not a condition for the third normal form in the case of X→Y?

View solution

Q. F+ is called as the ________ of F

View solution

Q. State true or false: A functional dependency must first satisfy the second normal form to satisfy the third normal form.

View solution

Q. State true or false: The fourth normal form does not exist and it is instead called as the BCNF.

View solution