DBS midterm

Question 13

The biggest problem caused by data redundancy is:

a.

Data visualization errors

b.

Increased software licensing costs

c.

Limited programming flexibility

d.

Compromised data integrity

Compromised data integrity

9) A graphical system used to capture the nature and relationships among data is called a(n):

A) XML data model.

B) hypertext graphic.

C) relational database.

D) data model.

D

10) Data that describe the properties of other data are:

A) relationships.

B) logical.

C) physical.

D) metadata.

D

17) A major difference between data warehouses and transactional systems as compared to big data is:

A) the data is unstructured in big data systems.

B) the size of the CPU used.

C) the programming required to access data.

D) all of the above.

A

31) A knowledge base of information or facts about an enterprise is called a(n):

A) enterprise information system.

B) repository.

C) systems information unit.

D) database process.

B

35) Database development begins with , which establishes the range and general contents of organizational databases.

A) database design

B) cross-functional analysis

C) departmental data modeling

D) enterprise data modeling

D

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

A) planning

B) design

C) analysis

D) implementation

C

38) The SDLC phase in which database processing programs are created is the phase.

A) planning

B) design

C) analysis

D) implementation

D

40) Specifying how data from a logical schema are stored in secondary memory is part of the:

A) design.

B) maintenance.

C) analysis.

D) implementation.

A

43) specify computer systems requirements.

A) Programmers

B) Users

C) Systems analysts

D) Database analysts

C

44) do NOT concentrate on determining the requirements for the database component of an information system.

A) Database analysts

B) Systems analysts

C) Programmers

D) End Users

D

1) Information is processed data.

TRUE

2) Metadata are data that describe the properties of other data.

TRUE

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

FALSE

4) File processing systems have been replaced by database systems in most critical business applications today.

TRUE

5) Unplanned duplicate data files are the rule rather than the exception in file processing systems.

TRUE

6) Organizations that utilize the file processing approach spend only 20 percent of development time on maintenance.

FALSE

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

TRUE

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

FALSE

9) 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.

TRUE

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

TRUE

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

FALSE

12) A person is an example of an entity.

TRUE

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

FALSE

14) A relational database establishes the relationships between entities by means of a common field.

TRUE

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

TRUE

16) Data redundancy is used to establish relationships between data but is never used to improve database performance.

FALSE

17) Redundancy increases the risk of inconsistent data.

TRUE

18) A user view is how the user sees the data when it is produced.

FALSE

19) 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.

TRUE

20) The data repository assists database administrators in enforcing standards.

TRUE

21) The failure to implement a strong database administrative function is the most common source of database failures in organizations.

TRUE

22) A constraint is a rule in a database system that can be violated by users.

FALSE

23) Reduced program maintenance is an advantage of file processing systems.

FALSE

24) Cost and complexity are just two of the disadvantages of database processing.

TRUE

25) The term legacy system refers to a newly installed database management system.

FALSE

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

TRUE

27) Organizational commitment to a database project is not necessary for its success.

FALSE

28) Data management technologies are also increasing often used as information systems, as a foundation for analytics or the systematic analysis of data to understand a real-world problem better.

TRUE

29) Repositories are always used in file processing systems.

FALSE

30) The user interface includes languages, menus, and other facilities by which users interact with various system components.

TRUE

31) Personal databases are designed to support a small group of individuals working together on a project.

FALSE

32) Database development begins with the design of the database.

FALSE

33) An enterprise data model describes the scope of data for only one information system.

FALSE

34) Database development projects are never done in a bottom-up fashion.

FALSE

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

TRUE

36) The steps of the systems development life cycle can only be viewed as a linear process.

FALSE

37) Enterprise modeling sets the range and general contents of organizational databases.

TRUE

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

FALSE

39) The repository is populated during the analysis phase of the systems development life cycle.

TRUE

40) The physical structure and storage organization of the database is decided upon during the implementation phase of the systems development life cycle.

FALSE

41) Database processing programs are coded and tested during the design stage of the systems development life cycle.

FALSE

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

TRUE

43) Database maintenance is typically the longest step of the database development process.

TRUE

44) Characteristics of the structure of the database are generally changed during the implementation phase of the database development process.

FALSE

45) Prototyping is a type of rapid application development.

TRUE

46) In prototyping, implementation and maintenance activities are repeated as necessary until the product is correct.

TRUE

47) Visual programming tools such as Visual Basic have made prototyping more difficult.

FALSE

48) Systems analysts work directly with both management and users to analyze the business situation and develop detailed project specifications.

FALSE

49) Database architects establish standards for data in business units.

TRUE

50) In 1998, ANSI/SPARC published an import document describing the three-schema architecture.

FALSE

51) The conceptual schema is always technology specific.

FALSE

52) The external schema contains a subset of the conceptual schema relevant to a particular group of users.

FALSE

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

TRUE

54) The internal schema consists of the physical schema and the enterprise data model.

FALSE

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

TRUE

56) The relational data model is no longer popular in the 21st century.

FALSE

57) Although personal databases improve productivity, one risk is that data cannot be shared with other users.

TRUE

58) The most common way to support a group of individuals who work together on a project or group of similar projects is with a multi-tier client/server database.

TRUE

59) In multi-tier database architectures, little functionality needs to be programmed into the client application.

FALSE

60) Multi-tier client/server database applications contain a business logic layer.

TRUE

61) An enterprise resource planning system integrates all functions of the enterprise.

TRUE

62) A data warehouse contains summarized and historical information.

TRUE

63) An extranet uses Internet protocols to establish limited access to company data by the company's customers and suppliers.

TRUE

1) The logical representation of an organization's data is called a(n):

A) database model.

B) entity-relationship model.

C) relationship systemsdesign.

D) database entitydiagram.

B

2) 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

3) A fact is an association between two or more:

A) words.

B) terms.

C) facts.

D) nuggets.

B

4) Data modeling may be themost important part of the systems development process because:

A) data characteristics are important in the design of programsand other systemscomponents.

B) the data in a system are generally less complex than processes and play a central role indevelopment.

C) data are less stablethan processes.

D) it is the easiest.

A

5) The most common types of entitiesare:

A) strong entities.

B) weak entities.

C) associative entities.

D) smush entities.

A

6) In an E-R diagram, there are/is business rule(s) for every relationship.

A) two

B) three

C) one

D) zero

A

7) Business policiesand rules govern all of the following EXCEPT:

A) managing employees.

B) creating data.

C) updating data.

D) removing data.

A

8) A defines or constrains some aspect of the business.

A) business constraint

B) business structure

C) business control

D) business rule

D

9) Which of the following is NOT a characteristic of a good business rule?

A) Declarative

B) Atomic

C) Inconsistent

D) Expressible

C

10) Which of the following is NOT a good characteristic of a data name?

A) Relates to business characteristics

B) Readable

C) Repeatable

D) Relates to a technical characteristic of the system

D

11) Customers, cars, and partsare examples of:

A) entities.

B) attributes.

C) cardinals.

D) relationships.

A

12) Which of the following is an entity that exists independently of otherentity types?

A) Codependent

B) Weak

C) Strong

D) Variant

C

13) An entity type whose existence depends on another entity type is called a entity.

A) strong

B) weak

C) codependent

D) variant

B

14) The following figure shows an exampleof:

A) a one-to-many relationship.

B) a strong entity and its associated weak entity.

C) a co-dependent relationship.

D) a double-walled relationship.

B

15) 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

16) An entity type name should be all of the followingEXCEPT:

A) concise.

B) specific to theorganization.

C) as short as possible.

D) a singular noun.

C

17) A property or characteristic of an entitytype that is of interestto the organization is called a(n):

A) attribute.

B) coexisting entity.

C) relationship.

D) cross-function.

A

18) An attribute that must be present for every entity (or relationship) instance is a(n):

A) composite attribute.

B) required attribute.

C) optional attribute.

D) multivalued attribute.

B

19) A person's name, birthday, and social security number are all examples of:

A) attributes.

B) entities.

C) relationships.

D) descriptors.

A

20) An attribute of an entitythat is computed is a(n):

A) optional attribute.

B) composite attribute.

C) derived attribute.

D) fuzzy attribute.

C

21) An attribute that canbe broken down into smaller parts is called a(n) attribute.

A) associative

B) simple

C) composite

D) complex

C

22) The number of entitytypes that participate in a Unary relationshipis:

A) zero.

B) one.

C) two.

D) three.

B

23) The number of entitytypes that participate in a relationship is called the:

A) number.

B) identifying characteristic.

C) degree.

D) counter.

C

24) A relationship between the instances of a single entity type is called a relationship.

A) ternary

B) primary

C) binary

D) unary

D

25) In the following diagram,what type of relationship is depicted?

A) Unary

B) Binary

C) Ternary

D) Quad

C

26) In the following diagram,which is true?

A) It depicts a ternaryrelationship.

B) It depicts a many-to-many relationship.

C) Item represents a column.

D) BOM_STRUCTURE represents a row.

B