Question 1

Complex requirements may dictate data transformations, and they may expand the number of entities and attributes within the design.

Accepted Answer

A)  information 
B)  entity 
C)  design 
D)  processing 
A)  information 
B)  entity 
C)  design 
D)  processing

Question 2

are underlined in an ER diagram.

Accepted Answer

The answer of are underlined in an ER diagram....

Question 3

A attribute can be further subdivided to yield additional attributes.

Accepted Answer

A)  composite 
B)  simple 
C)  single-valued 
D)  multivalued 
A)  composite 
B)  simple 
C)  single-valued 
D)  multivalued

Question 4

The Crow's foot symbol with two vertical parallel lines indicates cardinality.

Accepted Answer

A)  (0,N) 
B)  (1,N) 
C)  (1,1) 
D)  (0,1) 
A)  (0,N) 
B)  (1,N) 
C)  (1,1) 
D)  (0,1)

Question 5

Software vendors have adopted the Chen representation because of its compact representation.

Accepted Answer

A) True 
 B)False

Question 6

The first step in building an entity-relationship diagram (ERD) is .

Accepted Answer

A)  developing the initial ERD 
B)  creating a detailed narrative of the organization's description of operations 
C)  identifying the attributes and primary keys that adequately describe the entities 
D)  identifying the business rules based on the description of operations 
A)  developing the initial ERD 
B)  creating a detailed narrative of the organization's description of operations 
C)  identifying the attributes and primary keys that adequately describe the entities 
D)  identifying the business rules based on the description of operations

Question 7

Failure to understand the distinction between mandatory and optional in relationships might yield designs in which awkward (and unnecessary) temporary rows (entity instances) must be created just to accommodate the creation of required entities.

Accepted Answer

The answer of Failure to understand the distinction between mandatory...

Question 8

A attribute is one that cannot be subdivided.

Accepted Answer

A)  composite 
B)  simple 
C)  single-valued 
D)  multivalued 
A)  composite 
B)  simple 
C)  single-valued 
D)  multivalued

Question 9

To implement a small database, a database designer must know the "1" and the "M" sides of each relationship and whether the relationships are mandatory or optional.

Accepted Answer

A) True 
 B)False

Question 10

In the entity relationship model, a table row corresponds to an entity instance.

Accepted Answer

A) True 
 B)False

Question 11

The Crow's Foot notation easily identifies multivalued attributes.

Accepted Answer

A) True 
 B)False

Question 12

If Tiny College has some departments that are classified as "research only" and do not offer courses, the COURSE entity of the college database would be the DEPARTMENT entity.

Accepted Answer

A)  existence-dependent on 
B)  independent of 
C)  mandatory for 
D)  optional to 
A)  existence-dependent on 
B)  independent of 
C)  mandatory for 
D)  optional to

Question 13

A(n) relationship is also known as an identifying relationship.

Accepted Answer

The answer of A(n) relationship is also known as an...

Question 14

A weak entity has a primary key that is partially or totally derived from the parent entity in the relationship.

Accepted Answer

A) True 
 B)False

Question 15

A entity has a primary key that is partially or totally derived from the parent entity in the relationship.

Accepted Answer

A)  strong 
B)  weak 
C)  business 
D)  child 
A)  strong 
B)  weak 
C)  business 
D)  child

Question 16

A(n) process is based on repetition of processes and procedures.

Accepted Answer

The answer of A(n) process is based on repetition of...

Question 17

In a 1:M relationship, to avoid the possibility of referential integrity errors, the data of the "1" side must be loaded first.

Accepted Answer

A) True 
 B)False

Question 18

A weak entity must be -dependent.

Accepted Answer

The answer of A weak entity must be -dependent....

Question 19

If an employee within an EMPLOYEE entity has a relationship with itself, that relationship is known as a ?relationship.

Accepted Answer

A)  self 
B)  self-referring 
C)  looping 
D)  recursive 
A)  self 
B)  self-referring 
C)  looping 
D)  recursive

Question 20

In Crow's Foot notation, an optional relationship between entities is shown by drawing a(n) on the side of the optional entity.

Accepted Answer

The answer of In Crow's Foot notation, an optional relationship...

Complex requirements may dictate data transformations, and they may expand the number of entities and attributes within the design.

are underlined in an ER diagram.

A attribute can be further subdivided to yield additional attributes.

The Crow's foot symbol with two vertical parallel lines indicates cardinality.

Software vendors have adopted the Chen representation because of its compact representation.

The first step in building an entity-relationship diagram (ERD) is .

Failure to understand the distinction between mandatory and optional in relationships might yield designs in which awkward (and unnecessary) temporary rows (entity instances) must be created just to accommodate the creation of required entities.

A attribute is one that cannot be subdivided.

To implement a small database, a database designer must know the "1" and the "M" sides of each relationship and whether the relationships are mandatory or optional.

In the entity relationship model, a table row corresponds to an entity instance.

The Crow's Foot notation easily identifies multivalued attributes.

If Tiny College has some departments that are classified as "research only" and do not offer courses, the COURSE entity of the college database would be the DEPARTMENT entity.

A(n) relationship is also known as an identifying relationship.

A weak entity has a primary key that is partially or totally derived from the parent entity in the relationship.

A entity has a primary key that is partially or totally derived from the parent entity in the relationship.

A(n) process is based on repetition of processes and procedures.

In a 1:M relationship, to avoid the possibility of referential integrity errors, the data of the "1" side must be loaded first.

A weak entity must be -dependent.

If an employee within an EMPLOYEE entity has a relationship with itself, that relationship is known as a ?relationship.

In Crow's Foot notation, an optional relationship between entities is shown by drawing a(n) on the side of the optional entity.

Database Systems

Data Models

The Relational Database Model

Advanced Data Modeling

Normalization of Database Tables

Introduction to Structured Query Language Sql

Advanced Sql

Database Design

Transaction Management and Concurrency Control

Database Performance Tuning and Query Optimization

Distributed Database Management Systems

Business Intelligence and Data Warehouses

Database Connectivity and Web Technologies

Database Administration and Security

Filters

Exam 4: Entity Relationship Er Modeling

Complex requirements may dictate data transformations, and they may expand the number of entities and attributes within the design.

are underlined in an ER diagram.

A attribute can be further subdivided to yield additional attributes.

The Crow's foot symbol with two vertical parallel lines indicates cardinality.

Software vendors have adopted the Chen representation because of its compact representation.

The first step in building an entity-relationship diagram (ERD) is .

Failure to understand the distinction between mandatory and optional in relationships might yield designs in which awkward (and unnecessary) temporary rows (entity instances) must be created just to accommodate the creation of required entities.

A attribute is one that cannot be subdivided.

To implement a small database, a database designer must know the "1" and the "M" sides of each relationship and whether the relationships are mandatory or optional.

In the entity relationship model, a table row corresponds to an entity instance.

The Crow's Foot notation easily identifies multivalued attributes.

If Tiny College has some departments that are classified as "research only" and do not offer courses, the COURSE entity of the college database would be the DEPARTMENT entity.

A(n) relationship is also known as an identifying relationship.

A weak entity has a primary key that is partially or totally derived from the parent entity in the relationship.

A entity has a primary key that is partially or totally derived from the parent entity in the relationship.

A(n) process is based on repetition of processes and procedures.

In a 1:M relationship, to avoid the possibility of referential integrity errors, the data of the "1" side must be loaded first.

A weak entity must be -dependent.

If an employee within an EMPLOYEE entity has a relationship with itself, that relationship is known as a ?relationship.

In Crow's Foot notation, an optional relationship between entities is shown by drawing a(n) on the side of the optional entity.

Database Systems

Data Models

The Relational Database Model

Advanced Data Modeling

Normalization of Database Tables

Introduction to Structured Query Language Sql

Advanced Sql

Database Design

Transaction Management and Concurrency Control

Database Performance Tuning and Query Optimization

Distributed Database Management Systems

Business Intelligence and Data Warehouses

Database Connectivity and Web Technologies

Database Administration and Security

Filters