Exam 6: Developing Data Models for Business Databases

Figuer: -Assuming that we 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:

(Multiple Choice)

4.7/5

(30)

Question 21

The goals of narrative problem analysis are to strive for a _ design that is __ with the narrative.Be prepared to follow up with additional requirements collection and consideration of alternative designs.

(Short Answer)

4.8/5

(35)

Question 22

One type of transformation that should be used sparingly,because it is a specialized modeling tool,is the transformation of an entity type into a ___________________.

(Short Answer)

4.8/5

(38)

Question 23

Design errors are more difficult to detect and resolve than ____________ because design errors involve the meaning of elements on a diagram,not just a diagram's structure.

(Short Answer)

4.7/5

(30)

Question 24

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,Deptno appears as a foreign key the following number of times:

(Multiple Choice)

4.9/5

(36)

Question 25

One of the benefits of transforming an entity type into a generalization hierarchy is the avoidance of null values in entities.

(True/False)

4.8/5

(32)

Question 26

Figuer: -In converting the ERD diagram to a relational database,"ON DELETE CASCADE" option is set in the following number of tables:

(Multiple Choice)

4.8/5

(33)

Question 27

One example of splitting compound entity type attributes into smaller attributes would be:

(Multiple Choice)

4.7/5

(37)

Question 28

To avoid null values in foreign keys,an optional 1-M relationship can be converted to a separate table.

(True/False)

4.9/5

(44)

Question 29

When converting a narrative problem into an ERD,which of the following would potentially be converted into an entity type:

(Multiple Choice)

4.8/5

(29)

Question 30

During the iterative design of an ERD,two important aspects of the specification should be documented as they are discovered so that they can be resolved through more extensive requirements gathering.They are inconsistency and ___________ in the specification.

(Short Answer)

4.9/5

(42)

Question 31

Identification dependency is required to transform a single entity type into two entity types and a relationship.

(True/False)

4.8/5

(31)

Question 32

Design decisions to enforce uniqueness of attributes,attribute value restrictions,null values,and default values are efforts to in the design process to capture __________.

(Short Answer)

4.8/5

(29)

Question 33

Figuer: -The table WRITTEN-BY obtained in converting the ERD diagram to a relational database will have the following primary key:

(Multiple Choice)

4.9/5

(34)

Question 34

Figuer: -Converting the ERD diagram to a relational database will produce the following number of tables:

(Multiple Choice)

4.7/5

(37)

Question 35

When an optional 1-M relationship is converted into a new table,the new table contains foreign keys for the primary keys of both entity types participating in the relationship.

(True/False)

4.7/5

(38)

Question 36

What statement is true regarding the various ERD notations:

(Multiple Choice)

4.8/5

(31)

Question 37

In refining a data model,you should generate ______________ and evaluate them according to user requirements.

(Short Answer)

4.9/5

(34)

Question 38

A primary key for an entity type should never change after it has been assigned,and it should serve no other purpose but to identify that entity.

(True/False)

5.0/5

(33)

Question 39

Figuer: -In converting the ERD diagram to a relational database,SS# will appear as a foreign key the following number of times:

(Multiple Choice)

4.9/5

(34)

Question 40

Showing 21 - 40 of 75

Figuer: -Assuming that we 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:

The goals of narrative problem analysis are to strive for a _ design that is __ with the narrative.Be prepared to follow up with additional requirements collection and consideration of alternative designs.

One type of transformation that should be used sparingly,because it is a specialized modeling tool,is the transformation of an entity type into a ___________________.

Design errors are more difficult to detect and resolve than ____________ because design errors involve the meaning of elements on a diagram,not just a diagram's structure.

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,Deptno appears as a foreign key the following number of times:

One of the benefits of transforming an entity type into a generalization hierarchy is the avoidance of null values in entities.

Figuer: -In converting the ERD diagram to a relational database,"ON DELETE CASCADE" option is set in the following number of tables:

One example of splitting compound entity type attributes into smaller attributes would be:

To avoid null values in foreign keys,an optional 1-M relationship can be converted to a separate table.

When converting a narrative problem into an ERD,which of the following would potentially be converted into an entity type:

During the iterative design of an ERD,two important aspects of the specification should be documented as they are discovered so that they can be resolved through more extensive requirements gathering.They are inconsistency and ___________ in the specification.

Identification dependency is required to transform a single entity type into two entity types and a relationship.

Design decisions to enforce uniqueness of attributes,attribute value restrictions,null values,and default values are efforts to in the design process to capture __________.

Figuer: -The table WRITTEN-BY obtained in converting the ERD diagram to a relational database will have the following primary key:

Figuer: -Converting the ERD diagram to a relational database will produce the following number of tables:

When an optional 1-M relationship is converted into a new table,the new table contains foreign keys for the primary keys of both entity types participating in the relationship.

What statement is true regarding the various ERD notations:

In refining a data model,you should generate ______________ and evaluate them according to user requirements.

A primary key for an entity type should never change after it has been assigned,and it should serve no other purpose but to identify that entity.

Figuer: -In converting the ERD diagram to a relational database,SS# will appear as a foreign key the following number of times:

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

Figuer: -Assuming that we 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:

The goals of narrative problem analysis are to strive for a _________ design that is __________ with the narrative.Be prepared to follow up with additional requirements collection and consideration of alternative designs.

One type of transformation that should be used sparingly,because it is a specialized modeling tool,is the transformation of an entity type into a ___________________.

Design errors are more difficult to detect and resolve than ____________ because design errors involve the meaning of elements on a diagram,not just a diagram's structure.

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,Deptno appears as a foreign key the following number of times:

One of the benefits of transforming an entity type into a generalization hierarchy is the avoidance of null values in entities.

Figuer: -In converting the ERD diagram to a relational database,"ON DELETE CASCADE" option is set in the following number of tables:

One example of splitting compound entity type attributes into smaller attributes would be:

To avoid null values in foreign keys,an optional 1-M relationship can be converted to a separate table.

When converting a narrative problem into an ERD,which of the following would potentially be converted into an entity type:

During the iterative design of an ERD,two important aspects of the specification should be documented as they are discovered so that they can be resolved through more extensive requirements gathering.They are inconsistency and ___________ in the specification.

Identification dependency is required to transform a single entity type into two entity types and a relationship.

Design decisions to enforce uniqueness of attributes,attribute value restrictions,null values,and default values are efforts to in the design process to capture __________.

Figuer: -The table WRITTEN-BY obtained in converting the ERD diagram to a relational database will have the following primary key:

Figuer: -Converting the ERD diagram to a relational database will produce the following number of tables:

When an optional 1-M relationship is converted into a new table,the new table contains foreign keys for the primary keys of both entity types participating in the relationship.

What statement is true regarding the various ERD notations:

In refining a data model,you should generate ______________ and evaluate them according to user requirements.

A primary key for an entity type should never change after it has been assigned,and it should serve no other purpose but to identify that entity.

Figuer: -In converting the ERD diagram to a relational database,SS# will appear as a foreign key the following number of times:

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

The goals of narrative problem analysis are to strive for a _ design that is __ with the narrative.Be prepared to follow up with additional requirements collection and consideration of alternative designs.