Chapter 9 - Quiz

2NF

A relation is in ________ if every non-primary key attribute is functionally dependent on the whole primary key. 1NF 2NF 3NF 4NF

Foreign key

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. Foreign key Unique key Primary key Index

E-R diagram

During logical database design, you must account for every data element on a system input or output form or report and on the ________. E-R diagram Conceptual design Physical design Logical design

Relational

In a ________ database model, data is represented as a set of related tables or relations. Conventional Relational Physical Logical

Normalization

In logical database design, we use a process called ________, which is a way to build a data model that has the properties of simplicity, non-redundancy, and minimal maintenance. Database designing Data modeling De-normalization Normalization

Foreign key

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. Unique key Primary key Referential integrity Foreign key

Four

There are ________ key steps in logical database modeling and design. Two Three Four Five

N-ary

________ is NOT a valid degree of the relationship. Ternary Binary Unary N-ary

Physical file

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

Weak entity

Which relation is created with a composite primary key (which includes the primary key of the entity on which this weak entity depends) and non-key attributes? Weak entity Super-type Regular entity Associative entity with additional key