Exam 9: Data Design

The complete definition of a database, including descriptions of all fields, tables, and relationships, is called a _____.

A(n) _____ allows a user to specify a task without specifying how the task will be accomplished.

A _____ controls database operations, including storing, retrieving, updating, and deleting data.

Which of the following are the advantages of a DBMS (database management system)?

Some abbreviation codes are called _____ codes because they use a specific combination of letters that are easy to remember.​

A table is in _____ if it does not contain a repeating group.

A table is in _____ if it is in first normal form and if all fields that are not part of the primary key are functionally dependent on the entire primary key.

A table design is in third normal form (3NF) if it is in 2NF and if all nonkey fields are dependent on one another.

_____ is the process of creating table designs by assigning specific fields or attributes to each table in a database.​

The three normal forms constitute a progression in which the second normal form represents the best design.

The inherent efficiency of high-volume processing on larger computers is called _____.

In the event of a file catastrophe, _____ can be used to restore the file or database to its current state at the time of the last backup.

_____ is an industry-standard protocol that makes it possible for software from different vendors to interact and exchange data.

_____ use a keyword to encode a number.

With a _____, users provide an example of the data requested.

Matching ​Identify the letters of the choices that best match the phrases or definitions. -A set of field values that describes a single person, place, thing, or event

Each _____ contains data about people, places, things, or events.

A common method of cardinality notation is called _____ because of the shapes, which include circles, bars, and symbols that indicate various possibilities.

A combination key can also be called a _____.

A(n) _____ is a collection of tools, features, and interfaces that enables users to add, update, manage, access, and analyze data.