Ch. 1 Flashcards
If uncontrolled, what can lead to data anomalies?
data redundancy
A record in the logical design of a database corresponds to a ____ in the physical database.
row
Analyzing historical sales data stored in a database is commonly referred to as ____.
data mining
A ____ is a group of interrelated files
database
Which of the following terms is considered the basic unit of data in a database?
character
Which of the following terms refers to a group of related records?
file
Which of the following committees are responsible for establishing SQL guidelines?
ANSI and ISO
Which of the following terms best describes where a group of characters that represents a customer’s address would be stored in the logical design?
field
A record in the logical design of a database is represented by what in the physical database?
row
In which step of the Systems Development Life Cycle (SDLC) are the logical and physical components defined?
systems design
A field in the logical design of a database is represented by what in the physical database?
column
In which step of the Systems Development Life Cycle (SDLC) is the solution to the identified problem determined and understood?
systems analysis
The multi-step process used when creating a new system is referred to as ____.
the Systems Development Life Cycle
Which of the following is an example of an attribute?
a person’s hair color
Data mining refers to ____.
analyzing data already stored in a database
Which of the following terms represents a collection of fields?
record
In which step of the Systems Development Life Cycle (SDLC) is the system actually used by the end-user on a regular basis?
systems deployment
Which of the following is used to uniquely identify each record?
primary key
What represents a characteristic or attribute that is being collected about an entity?
field
What is the first step in the SDLC?
- Systems investigation: understanding the problem
What is the second step in the SDLC?
- Systems analysis: understanding the solution to the previously identified problem
What is the third step in the SDLC?
- Systems design: defining the logical and physical components
What is the fourth step in the SDLC?
- Systems implementation: creating the system
What is the fifth step in the SDLC?
- Systems integration and testing: placing the system into operation for testing
What is the sixth step in the SDLC?
- Systems deployment: Placing the system into production
What is the seventh step in the SDLC?
- Systems maintenance and review: evaluating the implemented system
What are the seven step process of the Systems Development Life Cycle (SDLC)?
Systems investigation Systems analysis Systems design Systems implementation Systems integration and testing Systems deployment Systems Maintenance and review