Exam 14: Database Design

Duplication of data items in multiple files is normally cited as the principal disadvantage of (file-based or database) systems.

In a database, primary key fields may be duplicated across records.

The physical, relational database implementation of the data model is known as the schema.

The data definition language (DDL) is able to specify different views of a database. Views restrict the portion of the database that may be used or accessed by different users and programs.

Centralization helps data administrators maintain an important data management rule - data should be controlled and centralized as much as possible to ensure data integrity.

Central distribution of data refers to the physical duplication of entire tables to multiple locations.

Which language is used by the DBMS to create, read, update, and delete records in the database and to navigate between different records and types of records?

A file that contains off-line records of master or transaction files is what type of file?

_________________________________ is a three-step technique that places the data model into first normal form, second normal form and third normal form.

Most database technologies impose a(n) ________________________ record structure, meaning that each record instance has the same fields, same number of fields and same logical size.

The set of all occurrences of a given record structure in a database system is frequently called a table.

Different DBMSs express precision of real numbers differently.

___________________________________ of data refers to the physical duplication of entire tables to multiple locations.

In implementing a database schema, each fundamental, associate, and weak entity is implemented as a separate table.

Record structures that require each record instance to have the same fields, same number of fields, and same logical size is classified as:

Files or tables that contain records that are relatively permanent are known as:

Referential integrity means that every table should have a unique, primary key, whose value is NOT NULL.

The data manipulation language (DML) is used by the DBMS to physically establish record types, fields, and structural relationships. Additionally, the DML defines views of the database.

The physical implementation of a data attribute; it is the smallest unit of meaningful data to be stored:

Centralization of the database refers to the physical distribution of entire tables to multiple locations on central processing units.