CIS 130 Quiz 4

35 Questions | By Yupeilin | Last updated: Mar 21, 2022 | Total Attempts: 577

Questions

Settings

Create your own Quiz

Questions and Answers

1.

A data model is a:
- A.
  
  The mathematical model of formulas and logic used in a system
- B.
  
  The abstract creating of an ideal system transformation
- C.
  
  The model that is produced by extreme programming
- D.
  
  The expanded, thoroughly balanced and normalized use case for a system
- E.
  
  A formal way of representing the data that are used and created by a business system
2.

A data model can __________
- A.
  
  Illustrate return-on-investment, break-even point, and economic feasibility
- B.
  
  Represent actions or processes that occur in the to-be system
- C.
  
  Be used as a logical data model in analysis and as a physical data model in design
- D.
  
  Only be used with Document analysis
- E.
  
  Only be used with JAD sessions
3.

Which of the following is NOT illustrated by a data model?
- A.
  
  People
- B.
  
  Places
- C.
  
  Things
- D.
  
  Actions
4.

ERD is an acronym for
- A.
  
  Enterprise Relationship Diagramming
- B.
  
  Entity Relationship Diagramming
- C.
  
  Electronic Repository Diagramming
- D.
  
  Enhanced Relationship Diagramming
- E.
  
  Entity Repository Design
5.

An analyst can read an ERD to
- A.
  
  Discover the individual pieces of information in a system and how they are organized and related to each other
- B.
  
  Find what processes use what data
- C.
  
  Determine the cardinality of processes in a system and if the modality of process is 1:M; 1:1; or M:N
- D.
  
  Evaluate data structure hierarchies as to processing anomalies in a business system
- E.
  
  Discover how the people, places and things in a business system are generated, moved, transformed and stored
6.

Which of the following is NOT true about ERDs?
- A.
  
  Special symbols are added to show high-level business rules
- B.
  
  The diagrams are drawn in a sequential order – from top to bottom
- C.
  
  Similar kinds of information are listed together in entities
- D.
  
  ERD's are data modeling techniques
- E.
  
  Lines are drawn to show relationships among the data
7.

Which is NOT an element of an Entity Relationship Diagram?
- A.
  
  Cardinality
- B.
  
  Modality
- C.
  
  Attribute
- D.
  
  Relationship
- E.
  
  Data stores
8.

Which would NOT likely be an attribute of an entity called “Student”?
- A.
  
  Age
- B.
  
  Student identification number
- C.
  
  Class room number
- D.
  
  Home phone
- E.
  
  Gender
9.

Which would NOT likely be an entity on a car insurance ERD?
- A.
  
  Customer
- B.
  
  Policy
- C.
  
  Agent
- D.
  
  Zip code
- E.
  
  Car
10.

Modality refers to
- A.
  
  Relationships of one-to-one; one-to-many; or many-to-many
- B.
  
  Whether a child entity can exist with or without a related instance in the parent entity
- C.
  
  The hierarchical structure that was developed in process models applied to data models
- D.
  
  The number of attributes generated by an entity
- E.
  
  Whether the entity has a unique identifier or a concatenated identifier
11.

CASE tools have a(n) __________________ where information about entities, attributes and relationships on the ERD are stored.
- A.
  
  Information space
- B.
  
  Data store
- C.
  
  Meta file
- D.
  
  Data flow
- E.
  
  Data dictionary
12.

Information in the data dictionary is called:
- A.
  
  Metadata
- B.
  
  Cached information
- C.
  
  Compiled data
- D.
  
  Data repository
- E.
  
  File silo
13.

Mike is drawing an ERD diagram. He has a one-to-many relationship. To identify the end of the relationship for the main relationship, Mike should draw:
- A.
  
  An oval
- B.
  
  A crow's foot
- C.
  
  The letter M
- D.
  
  An infinity symbol
- E.
  
  A diamond
14.

The three major parts of an ERD diagram are:
- A.
  
  Process, data flow, data store
- B.
  
  Attribute, modularity, cardinality
- C.
  
  Relationship, data flow, entity
- D.
  
  Relationship, attribute, entity
- E.
  
  Process, entity and relationship
15.

What is true about creating an entity relationship diagram?
- A.
  
  There will be at most seven entities
- B.
  
  There will be at most seven relationships
- C.
  
  If you identify more than seven entities, analyze and combine until you have seven or less
- D.
  
  It is an iterative process
- E.
  
  Entities will have at most seven attributes
16.

In adding attributes to an ERD, which of the following might NOT be a good resource for attributes?
- A.
  
  From the CASE tool
- B.
  
  Data flows from DFD's
- C.
  
  Requirements documents
- D.
  
  The system proposal document
- E.
  
  Through interviews (what users need for reports and processing)
17.

The last step in creating basic ERD’s is to:
- A.
  
  Identify relationships
- B.
  
  Define attributes and assign identifiers
- C.
  
  Recognize entities
- D.
  
  Test them with users
- E.
  
  Compile them with Java
18.

The first step to building an Entity Relationship Diagram is to
- A.
  
  Identify data flows from the level 0 DFD diagram
- B.
  
  Draw the relationships between the entities
- C.
  
  Identify the attributes for each entity
- D.
  
  Identify the entities
- E.
  
  Identify the processes, data flows and data stores
19.

When normalizing data models, if you take attributes that have multiple values for a single instance of an entity and create separate entities for those attributes you are moving from:
- A.
  
  0 normal form to 1st normal form (1NF)
- B.
  
  1st normal form (1NF) to 2nd normal form (2NF)
- C.
  
  3rd normal form (2NF) to 3rd normal form (3NF)
- D.
  
  Generalized normal form (GNF) to fully normalized form (FNF)
- E.
  
  Dependent normal form (DNF) to Independent normal form (INF)
20.

Independent entities are:
- A.
  
  When a child requires attributes from the parent
- B.
  
  When there is only one entity for a data process model
- C.
  
  When an entity can exist without the help of another entity
- D.
  
  Where the entity identifier is also the primary key
- E.
  
  When a entity comes from an external source (external entity)
21.

A(n) _____ entity cannot exist without the presence of another entity and is normally on the “many” end of a relationship or has an identifier that is based on another entity’s attribute.
- A.
  
  Independent
- B.
  
  Incomplete
- C.
  
  Dependent
- D.
  
  Variable
- E.
  
  Non-complying
22.

When the analyst is evaluating a data model to ensure that all fields in a record depend fully on the entire primary key, which step of normalization is being performed?
- A.
  
  Base normal form
- B.
  
  First normal form
- C.
  
  Second normal form
- D.
  
  Third normal form
- E.
  
  Cannot tell from the above information
23.

Data models can be either logical or physical
- A.
  
  True
- B.
  
  False
24.

The data that are used and created by a business system are illustrated by a process model.
- A.
  
  True
- B.
  
  False
25.

Logical data models are most commonly drawn with the Data Flow Diagram technique
- A.
  
  True
- B.
  
  False