Exam 9: Designing Databases

In some situations,a single attribute name,called a(n)________,may have more than one meaning or describe more than one characteristic.

A computer operating system stores data in a ________,which is a named set of table rows stored in a contiguous section of secondary memory.

In some situations,two or more attributes may have different names but the same meaning,as when they describe the same characteristic of an entity.Such attributes are called ________.

Range partitioning combines range and hash partitioning by first segregating data by ranges on the designated attribute,and then within each of these partitions,it further partitions by hashing on the designated attribute.

A relation is in third normal form if it is in second normal form and there are no functional dependencies between two (or more)non-primary key attributes.

________ is the process of splitting or combining normalized relations into physical tables based on affinity of use of rows and fields.

In a relation,each row is unique and uniqueness is guaranteed because the relation has a non-empty ________ key value.

During logical database design,you must account for every data element on a system input or output-form or report-and on the flow chart.

Each ________ in a relation corresponds to an attribute of that relation.

Which relation is created by placing the primary key of either entity in the relation for the other entity or by doing this for both entities?

A ________ is an attribute that appears as a non-primary key attribute in one relation and as a primary key attribute (or part of a primary key)in another relation.

What is the difference between logical database design and the physical table design?

A recursive foreign key is a foreign key in a relation that references the foreign key values of that same relation.

A recursive foreign key is a foreign key in a relation that references the ________ values of that same relation.

A(n)________ is the smallest unit of application data recognized by system software,such as a programming language or database management system.

What is null value? Why is it useful in the database?

List and describe the popular data integrity control methods.You may use examples to explain the control method.

A(n)________ must satisfy referential integrity,which specifies that the value of an attribute in one relation depends on the value of the same attribute in another relation.

The result of normalization is that every ________ key attribute depends upon the whole primary key.

A ________ table is a named set of rows and columns that specifies the fields in each row of the table.