Exam 2: Introduction to Database Development

In the database development process,the _________________ phase uses entity relationship diagrams (ERDs)and converts them into relational table designs.

Physical database design takes place during:

An system is a set of unrelated components that work independently to accomplish some objectives.

_____________________ is a database design activity which removes redundancies in table design using constraints or dependencies among columns.

Due to the high cost costs of developing new systems,a system is seldom changed once it has been implemented.

In the database development process,important choices about indexes and data placement occur during the _____________________ phase.

One of the common characteristics of data quality is _________________,meaning failures or interferences do not corrupt the database.

In the database development process,the _________________ phase involves choices about the location of data and processes so that performance can be optimized.

In the database development process,a graphical representation that depicts entities and relationships among entities is a(n)_____________________.

The characteristic of consistency in data quality is achieved when each part of the database has only one meaning.

The following is usually a component(s)of an information system:

When designing a database,which of the following is not a required feature?

If an information system consistently reports outdated inventory levels that causes delays in re-stocking orders,this would be an example of a lack of what characteristic of data quality?

Although establishing a common vocabulary among different parts of an organization is not easy,a database can unify an organization by accomplishing this.

Choose the most appropriate statement.

The Internal Schema is output from the following phase of Database Development:

In database design,a CASE tool analysis function which converts a table design to an ERD is known as _________________.

A design approach in which ERDs are constructed for each group of users and merged into a complete conceptual schema is referred to as _____________________________.

Relational Database Tables are output from the following phase of Database Development:

Analysis functions,which are supported by most products,are the most widely used function in CASE tools.