Unit 9 Flashcards
If a primary key combines two or more fields, then it is called a _____.
composite key
_____ are numbers or letters assigned in a specific order.
Sequence codes
The inherent efficiency of high-volume processing on larger computers is called _____.
economy of scale
Designing tables is easier if a _____ is used to show a table’s structure, fields, and primary key.
standard notation format
One type of validity check, called _____, is a set of rules that avoids data inconsistency and quality problems.
referential integrity
The data mining technique that relies on association rule learning is often called _____.
market basket analysis
_____ is the process of creating table designs by assigning specific fields or attributes to each table in a database.
Normalization
_____ means that a system can be expanded, modified, or downsized easily to meet the rapidly changing needs of a business enterprise.
Scalability
Encryption is the process of creating table designs by assigning specific fields or attributes to each table in the database.
False
To resolve potential database connectivity and access problems, companies use ODBC-compliant software that enables communication among various systems and DBMSs.
True
Migrating a traditional database design to the web can require design modification, additional software, and some added expense.
True
A common field is an attribute that appears in only one entity.
False
Systems that interact with a DBMS are relatively independent of how the physical data is maintained.
True
Field X is functionally dependent on field Y if the value of field X depends on the value of field Y.
True
A secondary key is a field in one table that must match a primary key value in another table in order to establish the relationship between the two tables.
False
