Quiz 1 (Week 102)

CASE (Computer Aided software Engineering)

- design databases and app programs - generate CODE to create the database

Databases may be more expensive to maintain than files because of:

- specialized personnel. - complex database environment. -backup and recovery needs.

A data warehouse contains summarized and historical information. A. TURE B. FALSE

A. TRUE

E. F. Codd developed the relational data model during the 1970s. A.TRUE B.FALSE

A.TRUE

In prototyping, implementation and maintenance activities are repeated as necessary until the product is correct. A.TURE A.FALSE

A.TRUE

Information is processed data. A.TRUE A.FALSE

A.TRUE

Separation of metadata from application programs that use the data is called data independence. A.TRUE B.FALSE

A.TRUE

Because applications are often developed independently in file processing systems: A.unplanned duplicate data files are the rule rather than the exception. B.the data is always non-redundant. C.data can always be shared with others.

A.unplanned duplicate data files are the rule rather than the exception.

One application (a way of using ) data warehouses is: A.ORDER PROCESSING B.Decision SUPPORT C. SHIPPING INFO

B.Decisions support

All of the following are properties of metadata EXCEPT: A. data definitions. B. processing logic. C.rules or constraints. D.data structures.

B.processing logic

One of the most popular RAD methods is: A.automated design. B. structured C. walkthrough. D, prototyping. crafting.

D. prototyping

CASE is a class of tools that: A. assists the database administrator in maintaining a database. B. provides guidelines for the physical design of a database. C. provides management reporting tools. D.automates the design of databases and application programs.

D.automates the design of databases and application programs.

A person, place, an object , an event or concept about which the organization wishes to maintain data is called a(n): A.ENTITY B.OBJECT C.ATTRIBUTE

Entity

An iterative methodology that rapidly repeats the analysis, design, and implementation phases of the SDLC is called: A.CASE. B.CAD. C.RAD

RAD

Cost and complexity are just two of the disadvantages of database processing A.TRUE B.FALSE

TRUE

A data model is a graphical system used to capture the nature and relationships among data. TRUE FALSE

True

A modern database management system automates more of the backup and recovery tasks than a file system. TRUE FALSE

True

A physical schema contains the specifications for how data from a conceptual schema are stored in a computer's secondary memory. TRUE FALE

True

The systems development life cycle is the traditional methodology used to develop, maintain, and replace information systems.

True

An enterprise resource planning system integrates all functions of the enterprise. TRUE FALSE

True ex sales, finance , accounting ,payroll systems that are separate into one or connected.

DBMS Purpose

create data update data store data

Metadata

data that describes properties or characteristics and CONTEXT of end user data

Data warehouses

gather data from various databases and give users the opportunity to work with historical data to identify patterns and trends which is helpful for decision support.

Data Model

graphical system used to capture relationships among data

All of the following are primary purposes of a database management system (DBMS) EXCEPT: A. creating data. B. updating data. C. storing data D. providing an integrated development environment.

providing an integrated development environment.

Data independence

separation of data descriptions (METADATA) from Applications programs

RAD (Rapid application development)

software development methodology that uses minimal planning in favor of rapid prototyping. Apart of prototyping information system development approach prototyping