Exam 1: The Database Environment and Development Process

The scope of an enterprise application is one workgroup or department.

A well-structured database establishes the entities between relationships in order to derive the desired information.

________ allows an organization's data to change and evolve without changing the application programs that process the data.

A user view is:

Many of the disadvantages of file processing systems can also be limitations of databases.

The SDLC phase in which every data attribute is defined,every category of data are listed and every business relationship between data entities is defined is called the ________ phase.

________ increases the risk of inconsistency.

Database development begins with the design of the database.

A centralized knowledge base of all data definitions,data relationships,screen and report formats,and other system components is called a(n):

All of the following are primary purposes of a database management system (DBMS)EXCEPT:

Data from prior systems is converted to the new system during the implementation phase of the systems development life cycle.

________ is data that describes the properties or characteristics of other data.

The data that you are interested in capturing about an entity is called an instance.

________ are established between entities in a well-structured database so that the desired information can be retrieved.

All projects move from the planning-enterprise modeling step to the planning-conceptual data modeling step of the systems development life cycle.

In file-processing systems,any change in the file structure requires a change to the ________ for all programs that access the file.

Separation of metadata from application programs that use the data is called data independence.

Discuss Enterprise Resource Planning Systems and contrast these to data warehouses.

A ________ represents data as a collection of tables.

E.F.Codd developed the relational data model during the 1970s.