Question 1

A(n) ______________________ data model contains only entities and relationships, but no attributes.

Accepted Answer

The answer of A(n) ______________________ data model contains only entities...

Question 2

Every entity must have __________________________.

Accepted Answer

an identif

Question 3

The ___________________________ of a relationship is the number of entity classes that participate in the relationship.

Accepted Answer

The answer of The ___________________________ of a relationship is the...

Question 4

A technique wherein attributes that are common to several types of an entity are grouped into their own entity called a supertype is called:

Accepted Answer

A)  normalization 
B)  generalization 
C)  concatenation 
D)  compound data type 
E)  none of these 
A)  normalization 
B)  generalization 
C)  concatenation 
D)  compound data type 
E)  none of these

Question 5

Because all relationships are bi-directional in an entity relationship diagram, cardinality must be defined in both directions for every relationship.

Accepted Answer

A) True 
 B)False

Question 6

An identity is a class of persons, places, objects, events, or concepts about which we need to capture and store data.

Accepted Answer

A) True 
 B)False

Question 7

A good data model is simple.

Accepted Answer

A) True 
 B)False

Question 8

An entity is a class of persons, places, objects, events or concepts about which we need to capture and store data.

Accepted Answer

A) True 
 B)False

Question 9

The domain of a relationship is the number of entities that participate in the relationship.

Accepted Answer

A) True 
 B)False

Question 10

________________________________ relationships are those in which each of the participating entities has its own independent primary key.

Accepted Answer

The answer of ________________________________ relationships are those in which each...

Question 11

An entity is in third normal form if:

Accepted Answer

A)  all the values of primary keys are independent on the nonprimary keys. 
B)  values of nonprimary key attributes are not dependent on any other nonprimary key attributes. 
C)  values of its nonprimary key attributes are dependent on any other nonprimary key attributes. 
D)  you add additional nonkey attributes that are dependent on other nonkey attributes. 
E)  none of these. 
A)  all the values of primary keys are independent on the nonprimary keys. 
B)  values of nonprimary key attributes are not dependent on any other nonprimary key attributes. 
C)  values of its nonprimary key attributes are dependent on any other nonprimary key attributes. 
D)  you add additional nonkey attributes that are dependent on other nonkey attributes. 
E)  none of these.

Question 12

A candidate key must be a single attribute.

Accepted Answer

A) True 
 B)False

Question 13

The domain value for an attribute is the value that will be recorded if not specified by the user.

Accepted Answer

A) True 
 B)False

Question 14

A key value whose structure communicates data about an entity instance:

Accepted Answer

A)  is known as an intelligent key. 
B)  should be avoided (suggested by the authors of your book). 
C)  is randomly assigned. 
D)  can only use alphabetic codes. 
E)  all of these 
A)  is known as an intelligent key. 
B)  should be avoided (suggested by the authors of your book). 
C)  is randomly assigned. 
D)  can only use alphabetic codes. 
E)  all of these

Question 15

The problem analysis phase model that includes only entities and relationships but no attributes is known as:

Accepted Answer

A)  the enterprise data model 
B)  the application data model 
C)  the context data model 
D)  does not exist, all data models must have attributes 
E)  none of these 
A)  the enterprise data model 
B)  the application data model 
C)  the context data model 
D)  does not exist, all data models must have attributes 
E)  none of these

Question 16

An example of domain would be an attribute called grade where the values could only be A, B, C, D, E, or F.

Accepted Answer

A) True 
 B)False

Question 17

Alphabetic codes use finite combinations of letters (and possibly numbers) to describe entity instances.

Accepted Answer

A) True 
 B)False

Question 18

An entity existence is a single occurrence of an entity.

Accepted Answer

A) True 
 B)False

Question 19

An entity is in second normal form (2NF) if it is already in 1NF and if the values of all nonprimary key attributes are dependent on the full primary key - not just part of it.

Accepted Answer

A) True 
 B)False

Question 20

A relationship may represent an event that links the entities or merely a physical affinity that exists between the entities.

Accepted Answer

A) True 
 B)False

A(n) ______________________ data model contains only entities and relationships, but no attributes.

Every entity must have __________________________.

The ___________________________ of a relationship is the number of entity classes that participate in the relationship.

A technique wherein attributes that are common to several types of an entity are grouped into their own entity called a supertype is called:

Because all relationships are bi-directional in an entity relationship diagram, cardinality must be defined in both directions for every relationship.

An identity is a class of persons, places, objects, events, or concepts about which we need to capture and store data.

A good data model is simple.

An entity is a class of persons, places, objects, events or concepts about which we need to capture and store data.

The domain of a relationship is the number of entities that participate in the relationship.

________________________________ relationships are those in which each of the participating entities has its own independent primary key.

An entity is in third normal form if:

A candidate key must be a single attribute.

The domain value for an attribute is the value that will be recorded if not specified by the user.

A key value whose structure communicates data about an entity instance:

The problem analysis phase model that includes only entities and relationships but no attributes is known as:

An example of domain would be an attribute called grade where the values could only be A, B, C, D, E, or F.

Alphabetic codes use finite combinations of letters (and possibly numbers) to describe entity instances.

An entity existence is a single occurrence of an entity.

An entity is in second normal form (2NF) if it is already in 1NF and if the values of all nonprimary key attributes are dependent on the full primary key - not just part of it.

A relationship may represent an event that links the entities or merely a physical affinity that exists between the entities.

The Context of Systems Analysis and Design Methods

Information System Building Blocks

Information Systems Development

Project Management

Systems Analysis

Fact-Finding Techniques for Requirements Discovery

Modeling System Requirements With Use Cases

Process Modeling

Object-Oriented Analysis and Modeling Using the Uml

Feasibility Analysis and the System Proposal

Systems Design

Application Architecture and Modeling

Database Design

Output Design and Prototyping

Input Design and Prototyping

User Interface Design

Object-Oriented Design and Modeling Using the UML

Systems Construction and Implementation

Systems Operations and Support

Filters

Exam 8: Data Modeling and Analysis

A(n) ______________________ data model contains only entities and relationships, but no attributes.

Every entity must have __________________________.

The ___________________________ of a relationship is the number of entity classes that participate in the relationship.

A technique wherein attributes that are common to several types of an entity are grouped into their own entity called a supertype is called:

Because all relationships are bi-directional in an entity relationship diagram, cardinality must be defined in both directions for every relationship.

An identity is a class of persons, places, objects, events, or concepts about which we need to capture and store data.

A good data model is simple.

An entity is a class of persons, places, objects, events or concepts about which we need to capture and store data.

The domain of a relationship is the number of entities that participate in the relationship.

________________________________ relationships are those in which each of the participating entities has its own independent primary key.

An entity is in third normal form if:

A candidate key must be a single attribute.

The domain value for an attribute is the value that will be recorded if not specified by the user.

A key value whose structure communicates data about an entity instance:

The problem analysis phase model that includes only entities and relationships but no attributes is known as:

An example of domain would be an attribute called grade where the values could only be A, B, C, D, E, or F.

Alphabetic codes use finite combinations of letters (and possibly numbers) to describe entity instances.

An entity existence is a single occurrence of an entity.

An entity is in second normal form (2NF) if it is already in 1NF and if the values of all nonprimary key attributes are dependent on the full primary key - not just part of it.

A relationship may represent an event that links the entities or merely a physical affinity that exists between the entities.

The Context of Systems Analysis and Design Methods

Information System Building Blocks

Information Systems Development

Project Management

Systems Analysis

Fact-Finding Techniques for Requirements Discovery

Modeling System Requirements With Use Cases

Process Modeling

Object-Oriented Analysis and Modeling Using the Uml

Feasibility Analysis and the System Proposal

Systems Design

Application Architecture and Modeling

Database Design

Output Design and Prototyping

Input Design and Prototyping

User Interface Design

Object-Oriented Design and Modeling Using the UML

Systems Construction and Implementation

Systems Operations and Support

Filters