THE DATABASE DEVELOPMENT PROCESS QUIZ

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

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Logical database design

Physical database design and definition

Conceptual data modeling

Enterprise modeling

TRUE ANSWER : ?
YOUR ANSWER : ?

User views are included as part of which schema?

Conceptual

None of these

Internal

External

TRUE ANSWER : ?
YOUR ANSWER : ?

The longest step of database development is database maintenance.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Which is not a relevant feature of CASE tools?

The ability to generate code

Access to a DB via the Internet

An information repository

The ability to help draw data models using entity-relationship notations

TRUE ANSWER : ?
YOUR ANSWER : ?

Packaged data models can reduce implementation times and costs.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Database analysts

Neither A or B

Database administrators

Both A and B

TRUE ANSWER : ?
YOUR ANSWER : ?

A conceptual schema is usually depicted in graphical format using E-R or object-modeling notations.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

An entity type is which of the following?

The application software

A major category of data about people, place, and things

The business processes the support the mission of an organization

The various departments of an organization

TRUE ANSWER : ?
YOUR ANSWER : ?

The three-schema components include all, but:

conceptual schema.

programming schema.

internal schema.

external schema.

TRUE ANSWER : ?
YOUR ANSWER : ?