Exam 9: Data Design

Each group of eight bits is called a(n) ____________________.

Which of the following is the advantage of a DBMS (database management system)?

Middleware can interpret client requests in HTML form and translate the requests into commands that the database can execute. _________________________

The complete definition of a database, including descriptions of all fields, tables, and relationships, is called a(n) ____.

MATCHING Identify the letter of the choice that best matches the phrase or definition.a.UML f.subschema b.cardinality g.EBCDIC c.secondary key h.entity d.data mining i.physical e.orphan j.logical -A widely used method of visualizing and documenting software systems design.

When a primary key combines two or more fields, it is called a ____ key.

Web-based systems are popular because they offer ease of access, cost-effectiveness, and worldwide connectivity.

____ is the process of converting readable data into unreadable characters to prevent unauthorized access to the data.

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

Like a primary key, a foreign key must be unique.

-In the accompanying figure, a ____ is a field or combination of fields that uniquely and minimally identifies a particular member of an entity.

Web-based design is dependent on a specific combination of hardware and software.

One common method of indicating ____ is called crow's foot notation because of the shapes, which include circles, bars, and symbols that indicate various possibilities.

Many three-character airport codes are cipher codes.

____ codes combine data from different item attributes, or characteristics, to build the code.

Which of the following is a problem found with 1NF (first normal form) design that does not exist in 2NF (second normal form)?

In a client/server system, processing is isolated in a single computer.

During the systems design phase, ____ fields are used to organize, access, and maintain data structures.

A table is in first normal form (1NF) if it contains a repeating group.

EBCDIC and ASCII both require ____ bits.