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

Q. Course(course_id,sec_id,semester)
Here the course_id,sec_id and semester are __________ and course is a _________

View solution

Q. Department (dept name, building, budget) and Employee (employee_id , name, dept name,salary)
Here the dept_name attribute appears in both the relations .Here using common attributes in relation schema is one way of relating ___________ relations.

View solution

Q. A domain is atomic if elements of the domain are considered to be ____________ units.

View solution