Exam 9: Data Design

Three main types of relationships that can exist between entities are a one-to-one relationship, abbreviated 1:1; a one-to-many relationship, abbreviated 1:M; and a many-to-many relationship, abbreviated M:N.

____ describes how instances of one entity relate to instances of another entity.

Perry mentions that data in a file processing system may be repeated in several different files. He points out that problems can arise if updates to the data are not applied in every file. What is the name of this type of problem?

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

To access information on the Internet, a person uses a(n) ____________________, which is an application that enables the user to navigate, or browse, the Internet and display Web pages on his or her local computer.

____________________ log files, which record details of all accesses and changes to a file or database, can be used to recover changes made since the last backup.

A ____ is a text document written in HTML.

A table design that does not contain repeating groups is called unnormalized. _________________________

____ codes are numbers or letters assigned in a specific order.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -In e-commerce, this works best when a goal is to reduce clicks to close, which means average page views to accomplish a purchase or obtain desired information.

A database system stores and manages data in separate files using a method called file processing.

____________________ software looks for meaningful patterns and relationships among data.

A popular rule of thumb is that a design is in 3NF if every nonkey field depends on the key, the whole key, and nothing but the key.

A(n) ____, which is used to access stored data, allows a user to specify a task without specifying how the task will be accomplished.

A binary digit is called a bit, and each group of eight bits is called a(n) ____________________.

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

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

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

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

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