Inability to obtain additional information as needs change.
What is task-data dependency
100
Has emerged as the Standard Language
What is SQL
100
The number of instances or records that pertain to a specific entity.
What is occurrence
100
Number of phases in the database design
What is 6
100
What does DDP stand for
What is distributed data processing
200
Environment where users own there own data files
What is flat-file
200
Describes every data element in the database
What is data dictionary
200
Data elements that define an entity
What is Attribute
200
First phase of database design
What is Identify entities.
200
Two distributed database techniques
What is partitioned and replicated
300
Purpose is to provide controlled access to the database.
What is a Database Management System
300
Program language used to define the physical database to the DBMS
What is data definition language (DDL)
300
Characteristics uniquely identifies each record in the tables
What is primary key
300
Combining the data needs of all users into a single schema
What is view integration
300
Software control that prevents multiple simultaneous accesses to data
What is database lockout
400
Name the three conceptual models
What is hierarchal, network, and navigational models
400
Duties consist of db planning, design, implementation, operation and maintenance, and database change and growth
What is Database Administrator (DBA)
400
Used to link tables together
What is Foreign Key
400
True or False: Normalized tables should be rich enough to support the views of all users of the system being modeled.
What is true
400
Effective in companies with a high degree of sharing and no primary user
What is replicated databases
500
This model allows users to create new and unique paths to through the database to solve a wider range of business problems
What is relational model
500
At the physical level the database is a collection of these two things
What is records and files
500
Blueprint for ultimately creating the physical database
What is a data model
500
Purchase order and receiving report is this type of association
What is 1:1
500
These are advantages of what approach (Partitioned or Replicated ):
-storing data local sites increase user control
-permitting local access to data and reducing teh volume of data that must be transmitted between sites improve transaction processing response time
-Can reduce the potential for disaster by having data at several sites