Database

Database

The Database Development Process has 30 Questions
Which of the following database activities allow for the actual retrieval and use of a database?

Enterprise modeling
Logical database design
Physical database design and definition
Database implementation
There is one physical schema for each logical schema.

True
False
The three-schema components include all, but:

internal schema.
conceptual schema.
programming schema.
external schema.
The most important reason for data architecture is reliability.

True
False
Which is not a type of data management technology?

Relational
Rational
Object-oriented
Dimensional
The systems development life cycle cannot be used with database implementation.

True
False
Which is not a relevant feature of CASE tools?

The ability to help draw data models using entity-relationship notations
The ability to generate code
An information repository
Access to a DB via the Internet
Enterprise data modeling typically occurs during information systems planning.

True
False
The first step in database development is which of the following?

Enterprise data modeling
Logical database design
Physical database design and definition
Database Implementation
During logical database design, the conceptual data model is transformed into a logical data model which describes the data in terms of a specific data management technology.

True
False
Which of the following database activities determines the entities, attributes, and relationships of data?

Conceptual data modeling
Logical database design
Physical database design and definition
Database implementation
A conceptual schema is usually depicted in graphical format using E-R or object-modeling notations.

True
False
The use of packaged data models can offer which of the following benefits?

Reduce implementation time and costs
Higher quality models
Both A and B.
Neither A nor B.
The physical database design identifies data integrity and security requirements.

True
False
The Enterprise tier of the three-tiered database architecture includes:

managing the data.
managing the User-system interface.
processing HTTP protocol.
processing scripting tasks.
The longest step of database development is database maintenance.

True
False
An entity type is which of the following?

A major category of data about people, place, and things
The various departments of an organization
The application software
The business processes the support the mission of an organization
Incremental commitment does not allow a project to be easily redirected or to be terminated.

True
False
Strategic Planning factors do not include which of the following?

Organizational goals
Critical success factors
Information engineering
Problem areas
There are three stages involved when analyzing the initiation of an information systems project.

True
False
CASE tools do not include which of the following features?

Help to draw data models
Help to generate code
Help to manage people
Create an information repository
One of the most popular systems development life cycle methods is prototyping.

True
False
In enterprise data modeling, which is incorrect?

You review current systems.
You implement the new database.
You describe the data needed at a very high level of abstraction.
You plan one or more database development projects.
The goal of information systems planning is to align information technology with the business strategies of the organization.

True
False
Which of the following database activities require a specific knowledge of a DBMS?

Enterprise modeling
Conceptual data modeling
Logical database design
Physical database design and definition
Functional decomposition is the process of breaking down the functions of an organization into greater levels of detail.

True
False
User views are included as part of which schema?

Internal
Conceptual
External
None of the above.
Packaged data models can reduce implementation times and costs.

True
False
Whose role is it to determine the requirements and design for a database?

Database analysts
Database administrators
Both A and B.
Neither A or B.
With an enterprise data model, it is much easier to build applications because you know exactly what data exist and what needs to be added.

True
False