Question 1

When adding historical details to a relationship,typically the 1-M relationship is converted to an M-N relationship with an attribute.

Accepted Answer

A) True 
 B)False

Question 2

A common design error is to leave relationships in a design that could be derived from other relationships.These relationships are referred to as ___________ relationships.

Accepted Answer

The answer of A common design error is to leave...

Question 3

Repeating the information already contained in an ERD is an example of poor________________.

Accepted Answer

documentat

Question 4

For relationship ________,you should look at the number (singular or plural)of nouns along with other words that indicate cardinality.

Accepted Answer

The answer of For relationship ________,you should look at the...

Question 5

Figuer:  
-Assuming that we do not use the rule(s)that avoid null values in tables,the table AUTHOR obtained in converting the ERD diagram to a relational database will have the following number of attributes:

Accepted Answer

A)  2 
B)  3 
C)  4 
D)  5 
A)  2 
B)  3 
C)  4 
D)  5

Question 6

One common refinement to an initial ERD would be to split compound attributes into smaller attributes.

Accepted Answer

A) True 
 B)False

Question 7

When constructing an ERD from a problem narrative:

Accepted Answer

A)  You can derive relationships but not cardinalities from the narrative 
B)  You can derive cardinalities but not relationships from the narrative 
C)  You can usually derive both relationships and cardinalities from the narrative, but sometimes they are incomplete 
D)  None of the above 
A)  You can derive relationships but not cardinalities from the narrative 
B)  You can derive cardinalities but not relationships from the narrative 
C)  You can usually derive both relationships and cardinalities from the narrative, but sometimes they are incomplete 
D)  None of the above

Question 8

In a narrative,you should look for _________ involving people,things,places,and events as potential entity types.

Accepted Answer

The answer of In a narrative,you should look for _________...

Question 9

The basic rules for converting an ERD cannot be applied to converting self-referencing relationships or more complex identification dependencies.

Accepted Answer

A) True 
 B)False

Question 10

________________ should include justification for design decisions involving multiple feasible choices and explanations of subtle design choices.

Accepted Answer

Design Doc

Question 11

In the absence of indication of minimum cardinality,the default should be _________.

Accepted Answer

The answer of In the absence of indication of minimum...

Question 12

Figuer:  
-Assuming that we do not use the rule(s)that avoid null values in tables,the table VOLUME obtained in converting the ERD diagram to a relational database will have the following primary key:

Accepted Answer

A)  Volume# 
B)  Title 
C)  Combination Volume#, Title 
D)  Combination Volume#, Title, #-of-pages 
A)  Volume# 
B)  Title 
C)  Combination Volume#, Title 
D)  Combination Volume#, Title, #-of-pages

Question 13

Figuer:  
-In converting the ERD diagram to a relational database,SS# will appear in the following number of tables:

Accepted Answer

A)  3 
B)  4 
C)  5 
D)  6 
A)  3 
B)  4 
C)  5 
D)  6

Question 14

Figuer:  
-Assuming that we do not use the rule(s)that avoid null values in tables in converting the ERD diagram to a relational database,the number of tables will be:

Accepted Answer

A)  3 
B)  4 
C)  5 
D)  6 
A)  3 
B)  4 
C)  5 
D)  6

Question 15

Figuer:  
-Assuming that we do not use the rule(s)that avoid null values in tables in converting the ERD diagram to a relational database,the number of attributes in the key of the table MEMBER is:

Accepted Answer

A)  3 
B)  4 
C)  5 
D)  6 
A)  3 
B)  4 
C)  5 
D)  6

When adding historical details to a relationship,typically the 1-M relationship is converted to an M-N relationship with an attribute.

A common design error is to leave relationships in a design that could be derived from other relationships.These relationships are referred to as ___________ relationships.

Repeating the information already contained in an ERD is an example of poor________________.

For relationship ________,you should look at the number (singular or plural)of nouns along with other words that indicate cardinality.

Figuer: -Assuming that we do not use the rule(s)that avoid null values in tables,the table AUTHOR obtained in converting the ERD diagram to a relational database will have the following number of attributes:

One common refinement to an initial ERD would be to split compound attributes into smaller attributes.

When constructing an ERD from a problem narrative:

In a narrative,you should look for _________ involving people,things,places,and events as potential entity types.

The basic rules for converting an ERD cannot be applied to converting self-referencing relationships or more complex identification dependencies.

________________ should include justification for design decisions involving multiple feasible choices and explanations of subtle design choices.

In the absence of indication of minimum cardinality,the default should be _________.

Figuer: -Assuming that we do not use the rule(s)that avoid null values in tables,the table VOLUME obtained in converting the ERD diagram to a relational database will have the following primary key:

Figuer: -In converting the ERD diagram to a relational database,SS# will appear in the following number of tables:

Figuer: -Assuming that we do not use the rule(s)that avoid null values in tables in converting the ERD diagram to a relational database,the number of tables will be:

Figuer: -Assuming that we do not use the rule(s)that avoid null values in tables in converting the ERD diagram to a relational database,the number of attributes in the key of the table MEMBER is:

Introduction to Database Management

Introduction to Database Development

The Relational Data Model

Query Formulation With SQL

Understanding Entity Relations

Normalization of Relational Tables

Physical Database Design

Advanced Query Formulation With SQL

Application Development With Views

Stored Procedures and Triggers

View Design and Integration

Data and Database Administration

Transaction Management

Data Warehouse Technology and Management

Client-Server Processing and Distributed Databases

Object Database Management Systems

Filters

Exam 6: Developing Data Models for Business Databases

When adding historical details to a relationship,typically the 1-M relationship is converted to an M-N relationship with an attribute.

A common design error is to leave relationships in a design that could be derived from other relationships.These relationships are referred to as ___________ relationships.

Repeating the information already contained in an ERD is an example of poor________________.

For relationship ________,you should look at the number (singular or plural)of nouns along with other words that indicate cardinality.

Figuer: -Assuming that we do not use the rule(s)that avoid null values in tables,the table AUTHOR obtained in converting the ERD diagram to a relational database will have the following number of attributes:

One common refinement to an initial ERD would be to split compound attributes into smaller attributes.

When constructing an ERD from a problem narrative:

In a narrative,you should look for _________ involving people,things,places,and events as potential entity types.

The basic rules for converting an ERD cannot be applied to converting self-referencing relationships or more complex identification dependencies.

________________ should include justification for design decisions involving multiple feasible choices and explanations of subtle design choices.

In the absence of indication of minimum cardinality,the default should be _________.

Figuer: -Assuming that we do not use the rule(s)that avoid null values in tables,the table VOLUME obtained in converting the ERD diagram to a relational database will have the following primary key:

Figuer: -In converting the ERD diagram to a relational database,SS# will appear in the following number of tables:

Figuer: -Assuming that we do not use the rule(s)that avoid null values in tables in converting the ERD diagram to a relational database,the number of tables will be:

Figuer: -Assuming that we do not use the rule(s)that avoid null values in tables in converting the ERD diagram to a relational database,the number of attributes in the key of the table MEMBER is:

Introduction to Database Management

Introduction to Database Development

The Relational Data Model

Query Formulation With SQL

Understanding Entity Relations

Normalization of Relational Tables

Physical Database Design

Advanced Query Formulation With SQL

Application Development With Views

Stored Procedures and Triggers

View Design and Integration

Data and Database Administration

Transaction Management

Data Warehouse Technology and Management

Client-Server Processing and Distributed Databases

Object Database Management Systems

Filters