Q. A _________ Fc for F is a set of dependencies such that F logically implies all dependencies in Fc, and Fc logically implies all dependencies in F.

View solution

Q. What does the BCNF decomposition algorithm do?

View solution

Q. The 3NF decomposition algorithm is also called as _______

View solution

Q. Which of the following is desirable in a database design with functional dependencies?

View solution

Q. Which of the following is not a process of generating a good relational schema?

View solution

Q. What is unique role assumption?

View solution

Q. The process of making a normalized schema unnormalized is called as _________

View solution

Q. State true or false: Crosstabs are not desirable in a database design

View solution

Q. The data that have a time interval associated with them during which they are valid are called as ________

View solution

Q. The value of the data at a particular time is called as?

View solution

Q. Functional dependencies that have a time associated with them during which they are valid are called as________

View solution

Q. State true or false: Overlapping time intervals cannot be prevented

View solution

Q. Which of the following is the time of temporal data that record when a fact was recorded in a database?

View solution

Q. To specify the foreign keys in relations referencing temporal data we need to specify _______

View solution

Q. A relational database consists of a collection of

View solution

Q. A ________ in a table represents a relationship among a set of values.

View solution

Q. The term _______ is used to refer to a row.

View solution

Q. The term attribute refers to a ___________ of a table.

View solution

Q. For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.

View solution

Q. Database __________ which is the logical design of the database, and the database _______ which is a snapshot of the data in the database at a given instant in time.

View solution