Exam 9: Data Design

Explain why large firms use data warehouses.

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

A _____,which is not unique,is a field or combination of fields that can be used to access or retrieve records.

Systems that interact with a DBMS are relatively independent of how the physical data is maintained.

Any field that is not a primary key or a candidate key is called a _____.

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

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

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

The basic elements of logical storage are alphabetic or numeric characters,such as the letter A or the number 9.

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

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

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

_____,a coding method that uses one byte per character,is used on mainframe computers and high-capacity servers.

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

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

A long integer format uses _____ bits to represent the number 1,234,567,890 in binary form.

In an entity-relationship diagram,entities are commonly represented as _____.

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

A primary key is composed of exactly two fields.

_____ is designed to serve the needs of a specific department,such as sales,marketing,or finance.