Exam 9: Data Design

Most date formats now are based on the model established by the International Organization for Standardization (ISO), which requires a format of ____.

____________________ software looks for meaningful patterns and relationships among data.

-In the table or file shown in the accompanying figure, a(n) ____________________ is a set of related fields that describes one instance, or occurrence of an entity.

A(n) ____________________ code indicates what action is to be taken with an associated item.

Unicode represents more than ____ unique, multilingual characters.

A(n) ____ is a collection of tools, features, and interfaces that enable users to add, update, manage, access, and analyze the contents of data.

At the beginning of the 21ˢᵗ century, many firms that used only two digits to represent the year were faced with a major problem called the ____________________.

____ means that a system can be expanded, modified, or downsized easily to meet the rapidly changing needs of a business enterprise.

A ____ is a set of letters or numbers that represents a data item.

Field X is functionally dependent on field Y if the value of field X depends on the value of field Y.

A set of related characters forms a field, which also is called a(n) ____________________.

Which of the following is a data coding and storage scheme?

A(n) ____ is a graphical model of an information system that depicts the logical relationships and interaction among system entities.

Security concerns about Web-based data design can be addressed with software that can protect the system and detect intrusion, for example.

A data ____, which is a framework for organizing and storing data, consists of one or more files or tables.

Compared with character-based formats, a ____ storage format offers a more efficient storage method.

Michelle tells Malia that a primary key is a field or combination of fields that uniquely and minimally identifies a particular entity. She explains that there may be a choice of fields or field combinations to use as the primary key. What is the term used for a possible primary key?

To bridge the gap between a database and the Web and enable data to be viewed and updated, it is necessary to use ____, which is software that integrates different applications and allows them to exchange data.

____ is a coding method used on most personal computers.

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 -As an analyst, you must understand this in order to create a data design that accurately reflects all relationships among system entities.