Deck 2: Introduction to Database Development

Question 1

Because many physical design and distributed design decisions must be tested on a populated database,these last two phases of the development process are usually divided between systems design and systems implementation.

Answer 1

True

Question 2

The broadest goal of database development is to produce a working database that processes data efficiently and securely.

Answer 2

False
Explanation: The broadest goal of database development is to produce a database that provides an important resource for an organization.

Question 3

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

Answer 3

False
Explanation: The short and long-term costs and benefits should always be considered.

Question 4

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

Question 5

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

Question 6

In the traditional life cycle,the systems implementation phase begins when an information system becomes operational.

Question 7

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.

Question 8

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

Question 9

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

Question 10

Refinements to the conceptual data model usually occur in the logical database design phase.

Question 11

The role of a database is to provide short-term memory for an information system.

Question 12

The systems analysis phase produces problem statement and feasibility study,which are inputs into the systems design phase.

Question 13

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

Question 14

The two main activities in the logical database design phase of database development are conversion to tables and data propagation.

Question 15

Indexing on a column or group of columns of a table can improve the performance of update operations in a database,but it slows down the retrieval process of queries.

Question 16

The first two phases of database development are concerned with the information content of the database,while the last two phases are concerned with the efficient implementation of the design.

Question 17

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

Question 18

Data placement decisions usually occur in the distributed design phase of database development.

Question 19

Database replication,a technique to improve performance by having multiple copies of the database available to various user groups,is very seldom done in practice because it is too difficult to keep all the copies consistent.

Question 20

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.

Question 21

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

A) Physical Database Design
B) Conceptual Data Modeling
C) Logical Database Design
D) Distributed Database Design

Question 22

Which one of the following indicates poor data quality?

A) Ambiguity
B) Consistency
C) Completeness
D) Reliability

Question 23

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?

A) Completeness
B) Ambiguity
C) Reliability
D) Timeliness

Question 24

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

Question 25

Which of the following shows the correct order of various phases of the traditional Systems Development Life Cycle?

A) Systems Design, Systems Analysis, Systems Implementation
B) Systems Analysis, Systems Design, Systems Implementation
C) Systems Implementation, Systems Analysis, Systems Design
D) Systems Analysis, Systems Implementation, Systems Design

Question 26

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

A) Completeness
B) Reliability
C) Timeliness
D) Consistency

Question 27

CASE is an acronym for computer-assisted system engineering.

Question 28

Select the most appropriate statement about information systems development.

A) The data model is usually produced first
B) The process model is usually produced first
C) The environment interaction model is usually produced first
D) The choice of the first of these three models is purely arbitrary

Question 29

Data Requirements are input to the following phase of Database Development:

A) Physical Database Design
B) Conceptual Data Modeling
C) Logical Database Design
D) Distributed Database Design

Question 30

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

Question 31

A supplier shown with two different addresses in two parts of the database would violate:

A) Completeness
B) Timeliness
C) Consistency
D) Reliability

Question 32

Choose the most appropriate statement.

A) A database is synonymous with information system
B) An information system is part of a database
C) Databases are essential components of many information systems.
D) A database is usually not a component of an information system

Question 33

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

A) Physical Database Design
B) Conceptual Data Modeling
C) Logical Database Design
D) Distributed Database Design

Question 34

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

Question 35

Which one is not an advantage of prototyping?

A) The initial prototype incorporates all requirements
B) Prototypes provide for clarification of requirements
C) Prototypes provide meaningful feedback to developers
D) Prototypes are implemented rapidly

Question 36

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.

Question 37

The waterfall model characterizes the following systems development model:

A) Prototyping
B) Traditional Systems Development Life Cycle
C) Spiral Development
D) Data model development

Question 38

Which one is a drawback of the traditional Systems Development Life Cycle?

A) There is no feedback between successive phases
B) There is no feasibility study
C) An operational system is produced very late in the cycle
D) There is no distinction between analysis and design

Question 39

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

A) Support of organizational policies
B) Provide high quality data
C) Limit data access to very few users
D) Allow efficient access to data

Question 40

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

A) Databases
B) Procedures
C) Software
D) All of the above

Question 41

In the traditional systems development life cycle,the __________________________ phase produces a problem statement and a feasibility study.

Question 42

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

Question 43

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

Question 44

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

Question 45

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

Question 46

In system development methodology,the ____________ model describes relationships between events and processes.

Question 47

A scaled-down version of a system that can be implemented quickly using graphical tools for generating forms and reports is called a ______________.

Question 48

Which of the following is independent of the choice of a DBMS?

A) Entity Relationship Diagrams
B) Distribution Schema
C) Internal Schema
D) Index files

Question 49

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

A) Physical Database Design
B) Conceptual Data Modeling
C) Logical Database Design
D) Distributed Database Design

Question 50

Physical database design takes place during:

A) Systems implementation
B) Systems design
C) Systems design and system implementation
D) Systems analysis

Question 51

Conceptual data modeling takes place during:

A) Systems implementation
B) Systems design
C) Systems design and system implementation
D) Systems analysis

Question 52

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

A) Different views have conflicting data requirements
B) Designers use conflicting DBMS
C) Designers use conflicting design methods
D) Designers use different versions of SQL

Question 53

Normalization takes place during the following database development phase:

A) Conceptual data modeling
B) Logical database design
C) Physical database design
D) Implementation

Question 54

In the traditional systems development life cycle,the __________________________ phase produces executable code,databases,and user documentation.

Question 55

Which of the following is a feature provided by prototyping tools?

A) create forms and reports
B) create an initial database from a library of databases
C) generate code
D) all of the above

Question 56

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

A) Choosing the views
B) Designing individual views
C) Choosing the staff to work on individual views
D) Integrating the views

Question 57

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

A) Student data and enrollment data will be stored in two different tables
B) An index file will be created on the last name of students in the Student table
C) The Social Security number will be chosen as the primary key of the Student table
D) Student data and enrollment data will be stored in two different tables at two different locations

Question 58

A set of related components that work together to accomplish some objective is known as a(n)__________________.

Question 59

The decision to place each student's record next to the student's enrollment data on disk takes place in the following phase of Database Development:

A) Physical Database Design
B) Conceptual Data Modeling
C) Logical Database Design
D) Distributed Database Design

Question 60

In the traditional systems development life cycle,the __________________________ phase produces requirements describing processes,data,and environment interactions.

Question 61

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

Question 62

One set of skills that a database designer needs,which are described as qualitative,subjective,and people-oriented are known as __________ skills.

Question 63

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

Question 64

A repository which stores data types,integrity rules,alias names,assumptions and alternatives in a database is known as a(n)__________________.

Question 65

A common characteristic of data quality is ________________,where the database represents all the important parts of the information system.

Question 66

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

Question 67

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

Question 68

A specialized software product which is used to improve the productivity of in developing information systems,and includes diagramming and documentation functions is called a(n)___________________.

Question 69

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

Question 70

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

Question 71

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

Question 72

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

Question 73

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

Question 74

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

Question 75

CASE tools that create prototypes and generate code that can be used to cross check a database with other components of an information system are classified as ____________ CASE tools.

Question 76

The __________________ strategy,which breaks a large problem into many smaller problems,is one way to manage complexity in database design.