Exam 2: Introduction to Database Development

In system development methodology,the ___________ model describes the kind of data and relationships that will occur in the system.

The non-enforcement of a business rule in a database would be a lack of which characteristic of data quality?

The distributed database design and physical database design phases involve ________ skills,which are characterized as quantitative,objective,and data intensive.

Prototyping tools are useful for creating forms and reports,but their main disadvantage is that they cannot generate code.

For large projects,the most difficult problem in view design and integration is often:

Even though most of the prominent CASE tools are offered by DBMS vendors,they are relatively DBMS neutral.

Due to the highly integrated nature of database design,design role specialization rarely occurs and the same individual usually performs all phases of the development process.

The conceptual data modeling and logical database design phases are not concerned with the efficient implementation of a database.

In the database development process,the _________________ phase uses data requirements and produces entity relationship diagrams (ERDs).

The external schema of a database represents all the requirements and formats of the system,while the conceptual schema deals with the requirements of a particular usage of the database.

Achieving good data quality is such an important goal in database design that short and long-term costs are seldom an issue.

Which one of the following indicates poor data quality?

A(n)____________________ accepts data from its environment,processes data,and produces output data for decision making.

In the traditional systems development life cycle,the boundaries between the various phases are usually well-defined and each phase is completed before the next phase is begun.

Which of the following decisions would be part of Distributed Database Design?

Conceptual data modeling is especially process-oriented and requires mostly hard skills of the database designer.

The main source of conflict in view integration is caused by:

In system development methodology,the ____________ model describes relationships among processes,such as which process can provide input data another process.

Entity Relationship Diagrams are input to the following phase of Database Development:

The traditional systems development life cycle is known as the ________________ model because each phase flows to the next phase.