Deck 6: Data Modeling

Question 1

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

Answer 1

A

Question 2

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 (aka 'primary key')or a concatenated identifier (aka 'composite key')

Answer 2

B

Question 3

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

Answer 3

B

Question 4

Lines on an ERD diagram indicate:

A)Hierarchies between processes
B)Relationships among the data
C)Plurality of data items
D)Uniqueness of data items
E)Primary keys

Question 5

An entity relationship diagram (ERD):

A)Is a use-case diagram enhanced graphically to show data and process modeling
B)Is a high-level CASE diagram of data modeling used in business systems
C)Is an illustration of external data flows to and from a business systems
D)Is a picture that shows the information that is created, stored and used by a business system
E)Is a graphical display of the processes in a business system

Question 6

Which would NOT likely be an entity on a car insurance ERD?

A)Customer
B)Policy
C)Agent
D)Zip code
E)Car

Question 7

On an ERD _________________:

A)Processes are listed alphabetically with relationship connections drawn between processes
B)Data elements are listed alphabetically with a cross listing to the processes that manipulate them
C)Data elements are described as singular (1:1); plurals (1:N); or didactic (M:N)
D)Data elements are grouped in a hierarchical structure that is uniquely identified by number
E)Data elements are listed together and place inside boxes called entities.

Question 8

Which of the following software packages does NOT provide data modeling capabilities?

A)ERwin
B)Visual Basic
C)Oracle Designer
D)Visible Analyst Workbench
E)Visio

Question 9

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

Question 10

Which is NOT an element of an Entity Relationship Diagram?

A)Cardinality
B)Modality
C)Attribute
D)Relationship
E)Data stores

Question 11

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 in BPR situations
E)Only be used with JAD sessions

Question 12

An attribute:

A)Is some type of information that is captured about an entity
B)Is the basic building block for a data model
C)Is the association between entities
D)Is the identification of parent and child entities
E)Is drawn as a line between processes

Question 13

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

Question 14

Which is NOT true about using Visible Analyst Workbench?

A)It can be used with many different databases
B)It integrates the data model with other parts of the project
C)It is a full-service CASE tool
D)Data modeling is one of many capabilities
E)It can generate Java code when the data modeling is done

Question 15

Which of the following is NOT illustrated by a data model?

A)People
B)Places
C)Things
D)Actions
E)Nouns

Question 16

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

Question 17

You have entities of ITEM,SOLD-ITEM,SALE and PAYMENT.Which most likely is NOT a relationship?

A)SALE is paid by PAYMENT
B)PAYMENT pays for ITEM
C)ITEM is included in SOLD-ITEM
D)SALE involves SOLD-ITEM
E)PAYMENT pays for SALE

Question 18

ERwin,a CASE tool with data modeling features,was created by:

A)Oracle
B)Microsoft
C)Platinum Technology
D)Sun Systems
E)United Technologies

Question 19

Entity relationship diagramming (ERD)is a graphical drawing technique developed by:

A)Cole and Weston
B)Thomas Barton
C)Peter Chen
D)Alan Dennis
E)Martin and Chang

Question 20

An entity:

A)Is the association between two related processes
B)Has cardinality (1:1, 1:N, or M:N)
C)Shows if it can be null or no null
D)Is a person, place or thing
E)Is described with a verb phrase

Question 21

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

Question 22

Anthony is working on the cardinality of doctors and patients in a large urban hospital.With the large number of doctors with varying specialties and patients that may have more than one aliment,he thinks the relationship might be noted as:

A)1 to 1
B)1 to 2
C)1 to many
D)Many to many
E)Many to 1

Question 23

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

Question 24

Jack is developing an ERD for a small dental practice office patient record system.The dental practice has three dentists,six hygienists,and many patients.A patient is always assigned to the same dentist for all appointments.In particular,he is working on the relationship between dentists and patients.Should it be:

A)1 to 1, with a modality of null
B)1 to many with a modality of not null
C)Many to many with a modality of null
D)Many to many with a modality of not null
E)1 to many with a modality of null

Question 25

Omar has a model with 85 entities.He can:

A)Compress these into at most seven entity grouping units
B)Group these into related subject areas
C)Stop - he has all entities defined
D)Sort the entities alphabetically
E)Co-validate the entities with the level 2 DFD diagrams

Question 26

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 (aka 'external entity')

Question 27

Entity Relationship Diagrams show relationships between entities that are _____.

A)Outputs from JAD sessions
B)Consistent with the ACM guidelines
C)In line with the business rules and processing
D)Defined by the project sponsor
E)Extensions of the process models

Question 28

Ting-You is creating an ERD diagram.She knows that it is a(n)_____________

A)Well defined process
B)Sequential process
C)Process defined by five steps
D)Iterative process
E)User defined process

Question 29

Information in the data dictionary is called: _______________

A)Metadata
B)Cached information
C)Compiled data
D)Data repository
E)File silo

Question 30

Sanjay is identifying relationships as he draws ERD's.He will need to:

A)Determine originality and functionality
B)Include cardinality and crows feet
C)Add modality and functionality
D)Determine modality and cardinality
E)Include 1:1, 1:N and M:N relationships

Question 31

In the IDEF1X ERD notation,an entity is drawn as:

A)A diamond with the entity name in the middle
B)A circle with the upper part of the circle with the entity name
C)A rectangle with the identifier written above (outside)the rectangle
D)A rectangle with the identifier written in a darker color inside at the top of the rectangle
E)A rectangle with the identifier written at the top of the rectangle with an asterisk

Question 32

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)O normal form to 1st normal form (1NF)
B)1st normal form (1NF)to 2nd normal form (2NF)
C)2nd 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)

Question 33

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)

Question 34

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

Question 35

Which would most likely NOT be an entity on an ERD?

A)Student
B)Professor
C)Class
D)Practice
E)Enroll

Question 36

The basic building block of a data model is the:

A)Entity
B)Relationship
C)Attribute
D)Cardinality
E)Modality

Question 37

In creating ERD's,which would most likely NOT be a source for entities?

A)Use cases
B)Level 0 DFD diagrams
C)External entities
D)Data flows
E)Cost / benefit reports

Question 38

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

Question 39

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

Question 40

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

Question 41

If the logical data model does not contain attributes that have repeating values it is in _____.

A)base normal form
B)first normal form
C)non-normal form
D)second normal form
E)third normal form

Question 42

What are the rules covering the layout of ERD components?

A)Items that are related must be grouped into subject areas
B)Items that are not related must be drawn on the bottom of the page
C)They must be placed in alphabetical order
D)They must be placed in numerical order
E)There are no rules

Question 43

During the analysis phase,analysts create programming models to represent how the business system will operate.

Question 44

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

Question 45

One of the most commonly used techniques for data modeling is ERD's.

Question 46

Balance occurs between DFDs and ERDs when the data stores _____

A)Are uniquely named
B)Have only one input and one output flow
C)Are named the same as the relationships on the ERD
D)Can be compared to ERD data flows and attributes on the ERD are included in data stores on the DFD
E)Can be equated to entities on the ERD and when entities are referred to by data stores on the DFD

Question 47

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

Question 48

A logical data model that does not lead to repeating fields and that the data models leads to tables containing fields that are dependent on the whole identifier is in _____ normal form.

A)balanced
B)first
C)primary
D)second
E)third

Question 49

Project teams can use packages like ERwin or Oracle Designer or Visible Analyst Workbench to draw data models.

Question 50

The data that are used and created by a business system are illustrated by a process model.

Question 51

Data models can be either logical or physical.

Question 52

ERD is an acronym for Enterprise Reliability Diagrams.

Question 53

A data model is a formal way of representing the data that are used and created by a business system.

Question 54

Andrew,an analyst for PaxMedia Inc,has just learned that the business rules for a system he has been working on have changed.This means that _____.

A)Nothing - once the ERD data models have been drawn, they are 'frozen' for the system
B)Andrew will be reassigned to a different project that is in its beginning stages
C)The ERD components will have to be changed
D)The ERD data model will have to be put on hold while new DFD diagrams are created
E)The project will have to be scrapped and restarted

Question 55

The two methods to validate that an ERD is well formed are _____.

A)Balancing with process models and following design guidelines created by Chen
B)Normalization and balancing with process models
C)Renaming theory
D)Balancing with process models and renaming theory
E)Normalization and following design guidelines created by Chen

Question 56

Project teams generally use either Gantt or PERT charts to draw data models.

Question 57

A(n)_____ entity is an entity at the "1" end of a relationship or an entity with an identifier that describes only the entity.

A)dependent
B)incomplete
C)independent
D)intersection
E)non-identifying

Question 58

Logical data models are most commonly drawn with the Data Flow Diagram technique.

Question 59

If the logical data model contains attribute values that depend on an attribute that is not the identifier,then it is in _____.

A)base normal form
B)first normal form
C)non-normal form
D)second normal form
E)third normal form

Question 60

ERD's are drawn in several levels: Context ERD diagrams;Level 0 ERD diagrams;Level 1 ERD diagrams.

Question 61

An analyst can read an ERD to discover the individual pieces of information in a system and how they are organized and related to each other.

Question 62

In an entity called STUDENT,you might find attributes of PROFESSOR-ID,Last-Name,First-Name and CLASSROOM.

Question 63

Relationships are some type of information that is captured about entities.

Question 64

An entity is described by an action verb.

Question 65

ERD's and DFD's are two techniques for process modeling.

Question 66

Entities are further designed with attributes.

Question 67

In an entity called STUDENT,you might find attributes of Student-ID,Last-Name,First-Name and cell-phone.

Question 68

Metadata is data about data.

Question 69

The three steps in creating an ERD are: (1)identify the entities;(2)identify the processes;(3)identify the relationships

Question 70

ERD's and DFD's are two techniques for data modeling.

Question 71

On an ERD,similar kinds of information are listed together and placed inside boxes called data containers.

Question 72

CASE tools have 'data repositories'.

Question 73

An entity is the basic building block for a data model.

Question 74

Relationships are drawn with lines showing cardinality and plurality.

Question 75

An illustration of the transformation of data into business value is an ERD.

Question 76

ERD's can be quite complex and might have hundreds or thousands of entities.

Question 77

A graphical illustration that shows the information that is created,stored and used by a business system would be an ERD.

Question 78

A textbook-provided example of a 'full-service CASE' tool is Visible Analyst Workbench.

Question 79

An ERD is a picture that shows how data and information is processed and transformed by a business system.

Question 80

Relationships are associations between entities.