CS431 Haroon Tanweer Midterm 1

A user view is how the user sees the data when it is produced

F

Databases were developed as the first application of computers to data processing

F

Organizations that utilize the file processing approach spend only 20% of development time on maitenance

F

Orgs that utilize the file processing approach spend 20% of dev time on maitenance

F

With the traditional file processing approach, each application shares data files, thus enabling much data sharing

F

A constraint is a rule in a DB system that can be violated by users

False

Reduced program maintenance is an advantage of file processing systems

False

The term legacy system refers to a newly installed dBMS

False

Visual programming tools such as Visual Basic have made prototyping more difficult (TF)

False

With the traditional file processing approach, each application shares data files, thus enabling much data sharing. (TF)

False

an enterprise data model describes the scope of data for only one information system

False

Discuss the advantages of storing data in a DB compared o storing data in files

Reduced redundancy, reduced updating errors and increased consistency, greater data integrity, independence from apps and programs, greater data access, security, and reduced entry/storage/retrieval costs. There is also direction that is given for development of a new applications program

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

T

A data warehouse derives its data from: various operational data sources

T

A relational DB establishes the relationships between entities by means of a common field

T

Development starts from scratch with the traditional file processing approach because new file formats, descriptions, and file access logic must be designed for each new program

T

File processing systems have been replaced by db systems in most critical business applications today

T

In practice, databases today may contain either data or information (TF)

T

Information is processed data (TF)

T

MYSQL is an example of a database software

T

Metadata are data that describe the properties of other data

T

One reason for improved application development productivity with the database approach is that file design and low-level implementation details do not need to be handled by the application programmer

T

Redundancy increases the risk of inconsistent data

T

The most common source of DB failures in orgs is: failure to implement a strong DB administration function

T

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

T

many of the disadvantage of file processing systems can also be limitations of databases

T

unplanned duplicate data files are the rule rather than the exception in file processing systems

T

A data model is a graphical system used to capture the nature and relationships among data. (TF)

True

An enterprise resource planning system integrates all functions of the enterprise (TF)

True

CASE is a class of tools that automates the design of dbs and application programs

True

Cost and complexity are just two of the disadvantages of db processing

True

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

True

End users can often retrieve and display data easily with a relational db

True

Metadata are data that describe the properties of other data. (TF)

True

Older systems that often contain data of poor quality are called Legacy Systems (TF)

True

One application of data warehouses is: decision support (TF)

True

One disadvantage of file processing systems is: Limited data sharing (TF)

True

Prototyping is a type of rapid application development (TF)

True

The data repository assists database administrators in enforcing standards

True

The failure to implement a strong DB admin function is the most common source of DB failures in orgs

True

in a file processing environment, descriptions for data and the logic for accessing the data are built into: a) application programs b) database descriptors c) fields d) records

a) application programs

A database is an organized collection of _______ related data. a) logically b) physically c) loosely d) badly

a) logically

Which of the following is not an advantage of database systems? a0 redundant data b) program-data independence c) better data quality d) reduced program maitenance

a) redundant data

a property or characteristic of an entity type that is of interest to the organization is called a a. attribute b. coexisting entity c. relationship d. cross function

a. attribute

a person's name, birthday, and SSN are all examples of a. attributes b. entities c. relationships d. descriptors

a. attributes

STUDENT SID Name Address (Street, City, State, ZipCode) a. composite attribute b. relational attribute c. derived attribute d. multivalued attribute

a. composite attribute

Data modeling may be the most important part of the systems development process because: a) data characteristics are important in the design of programs and other systems components b. the data in a system are generally less complex than processes and play a central role in development c. data are less stable than processes d. it is the easiest

a. data characteristics are important int he design of programs and other systems components

A knowledge base of information on facts about an enterprise is called a a. enterprise information system b. repository c. systems information unit d. db process

a. enterprise information system

customers, cars, and parts are examples of: a. entities b. attributes c. cardinals d. relationships

a. entities

business policies and rules govern all of the following EXCEPT a. managing employees b. creating data c. updating data d. removing data

a. managing employees

In an E-R diagram, there are ________ business rule(s) for every relationship. a) two b. 3 c. 1 d. 0

a. two

__________ is a tool even non-programmers can use to access information from a database a) odbc b) structured query language (SQL) c) ASP D) data manipulation query language

b) SQL

A rule that cannot be vilated by database users is called a: a) password b) constraint c) program d) view

b) constraint

Older systems that contain data of poor quality are called ______ systems. a) controlled b) legacy c) database d) mainframe

b) legacy

The need for consensus on data definitions is an example of which type of risk in the DB environment? a) specialized personnel needs? b) organizational conflict c) conversion costs d) legacy systems

b) organizational conflict

All of the following are properties of metadta EXCEPT: a_ data definitions b) processing logic c) rules or constraints d) data structures

b) processing logic

_________ are established between entities in a well-structured database so that the desired information can be retrieved. a) entities b) relationships c) lines d) ties

b) relationships

Because applications are often developed independently in file processing systems: a) the data is always non-redundant b) unplanned duplicate data files are the rule rather than the exception c) data can always be shared with others d) there is a larve volume of file i/o

b) unplanned duplicate data files are the rule rather than the exception

the logical representation of an org's data is called a a. db model b. entity-relationship model c. relationship systems design d. database entity diagram

b. entity-relationship model

a(n) _______ is the relationship between a weak entity type and its owner a. member chain b. identifying relationship c. jump path d. chain link

b. identifying relationship

An attribute of an entity that must have a value for each entity instance is a(n): a. optional attribute b. composite attribute c. required attribute d. fuzzy attribute

b. required attribute

an attribute that must have a value for every entity or relationship instance is a a. composite attribute b. required attribute c. optional attribute d. multivalued attribute

b. required attribute

(single boxed) employee(one) carries (to many) (double boxed) dependent This figure shows an example of a. one to many relationship b. strong entity and its associated weak entity c. co-dependent relationship d. double-walled relationship

b. strong entity and its associated weak entity

a fact is an association between two or more a. words b. terms c. facts d. nuggets

b. terms

An entity type whose existence depends on another entity type is called a ________ entity. a. strong b. weak c. codependent d. variant

b. weak

a user view is: a) what a user sees when he looks out the window b) a table or set of tables c) a logical description of some portion of the database d) a procedure stored on the server

c) a logical description of some portion of the database

program-data dependence is caused by a) file descriptors being stored in each application b) data descriptions being stored on a server c) data descriptions being written into programming code d) data cohabiting with programs

c) data descriptions being written into programming code

One application of data warehouses is: a) shipping of information b) order processing c) decision support d) file updating

c) decision support

which of the following is NOT a cost and/or risk of the DB approach? a) specialized personnel b) cost of conversion c) improved responsiveness d) organizational conflict

c) improved responsiveness

Data processed in a way that increases a user's knowledge is a) text) b) graphics c) information d) hyperlink

c) information

one disadvantage of file processing systems is a) reduced data duplication b) program-data independence c) limited data sharing d) enforcement of integrity constraints

c) limited data sharing

relational databases establish the relationships between entities by means of common fields included in a file called a(n): a) entity b) relationship c) relation d) association

c) relation

a(n) _______ is often developed by identifying a form or report that a user needs on a regular basis a) enterprise view b) reporting document c) user view d) user snapshot

c) user view

which of the following is software used to create, maintain, and provide controlled access to databases? a. network OS b) user view c. Database management system (DBMS) d. attribute

c. DBMS

an entity type name should be all of the following except a. concise b. specific to the organization c. as short as possible d. a singular noun

c. as short as possible

which of the following is not a characteristic of a good business rule? a. declaritive b. atomic c. inconsistent d. expressible

c. inconsistent

which of the following is an entity type on which a strong entity depends? a. owner b. member c. attribute d. none of the above

d none of the above

Which of the following types of data can be stored in a DB? a_ voice b) letters c) numbers d) all of the above

d) all of the above

databases may be more expensive to maintain than files because of: a) the need for specialized personnel b) the complexity of the DB environment C) backup/recovery needs d) all of the above

d) all of the above

A graphical system used to capture the nature and relationships among data is called a(n): a) logical data model b) hypertext graphic c) ERD d) data model

d) data model

A person, place, an object , an event or concept about which the organization wishes to maintain data is called a(n): a) relationship b) object c) attribute d) entity

d) entity

the most common source of DB failures in orgs is: a) lack of planning b) inadequate budget c) inadequate hardware d) failure to implement a strong DB administration function

d) failure to implement a strong DB administration function

Which organizational function should set DB standards? a) management b) application development c) technical services d) none of the above

d) none of the above (database administrator)

Data that describe the properties of other data are: a) relationships b) logical c) physical d) none of the above

d) none of the above (it's metadata)

All of the following are primary purposes of a DBMS except a) creating data b) updating data c) storing data d) providing an IDE

d) providing an IDE

With the database approach, data descriptions are stored in a central location known as a(n): a) server b) mainframe c) pc d) repository

d) repository

Organizations that utilize the file processing approach spend as much as _______ of their IS development budget on maintenance a)40% b)25% c)60% d)80%

d)80%

a business rule a. defines or constrains some aspect of the business b. asserts business structure c. controls or influences the behavior of the business d. all of the above

d. all of the above

the common types of entities are a. strong b. weak c. associative d. all of the above

d. all of the above

which of the following is not a good characteristic of a data name? a. relates to business characteristics b. relatable c. repeatable d. relates to a technical characteristic of the system

d. relates to a technical characteristic of the system

a good data definition will describe all of the characteristics of a data object except a. subtleties b examples c. who determines the value of the data d. who can delete the data

d. who can delete the data

org commitment to a db project is not necessary for its success

false

personal dbs are designed to support a small group of individuals working together on a project

false

repos are always used in file processing systems

false

the user interface includes languages, menus, and other facilities by which users interact with various system components

t

a modern dbms automates more of the backup and recovery tasks than a file system

true