Principles of Database Systems(B) (final test).doc

Principles of Database Systems(B) (final test)
— 0201~puter Science & Technology
Name________________ ID____________________
Please fill the answers into the following table:
Multiple Choice
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Multiple Choice( 2 points * 20)
Which is not a disadvantage of traditional file processing systems?
Program-data dependence
Reduced data redundancy
Limited data sharing
Lengthy development time
Database applications can be divided into five categories. Which is NOT a database application category?
Personal
Department
Enterprise
Relational
Automated tools used to design databases and application programs are called ____ tools.
CASE
repository
OLAP
LAN
The traditional methodology used to develop, maintain, and replace information systems.
CASE
ISA
ERP
SDLC
A popular RAD method that is an iterative process of systems development is
SDLC.
CASE.
prototyping.
ISA.
The E-R model is most often used as a tool during the ___ phase of database development.
analysis
feasibility
design
implementation
If EMPLOYEE is the entity type, then SMITH, JOHN is the entity ____.
field
characteristic
instance.
identifier
The _______ specifies the number of instances of one entity that can (or must) be associated with each instance of another entity.
cardinality constraint
entity instance
multivalued at