CMSC 243 Ch 9 Data Design

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

​___ means that a system can be expanded or downsized easily to meet the rapidly changing needs of a business enterprise

​A common field is an attribute that appears in only one entity.

Cipher codes distinguish items by using a series of subgroups of digits.

​A _____ specifies the fields and identifies the primary key in a particular file.

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

​A common method of cardinality notation is called _____ because of the shapes, which include circles, bars and symbols

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

​A primary key is composed of exactly two fields.

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

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

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

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

​Designing tables is easier if a _____ is used to show a table’s structure, fields, and primary key.

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

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

​A___ is a graphical model information system that depicts the logical relationships & interaction among system entities

A table design that contains a repeating group is called _____.

​_____ combine data from different item attributes, or characteristics, to build a code.

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

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

In a table or file, each row represents a record and each column represents a field.

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

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

​___enables Java applications to exchange data with database that uses SQL statements & is compliant with its standard

​A ___ is an integrated collection of data that can include seemingly unrelated information no matter where it is stored

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

​One type of validity check, called _____, is a set of rules that avoids data inconsistency and quality problems.

​Audit log files, which record details of all accesses and changes to a file or database, can be used to recover changes

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

​A _____, which is a framework for organizing, storing, and managing data, consists of files or tables that interact.

​If a primary key combines two or more fields, then it is called a _____.

Web-based designs are dependent on a specific combination of hardware and software.

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

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

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

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

A database management system is managed by a person called __ who assesses overall requirements & maintains the database

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

​The data mining technique that relies on association rule learning is often called _____.

​_____ are numbers or letters assigned in a specific order.

___describes the numeric relationship between 2 entities & shows how instances of 1 entity relate 2 instances of another

​_____ use a keyword to encode a number.