Question 1

Users need to verify the data model for correctness.

Accepted Answer

A) True 
 B)False

Question 2

"PartNumber" would be a good identifier for a part entity in a database application.

Accepted Answer

A) True 
 B)False

Question 3

The ________ shows the number of entities that can be involved in a relationship.

Accepted Answer

A)   E-R
B)   UML
C)   data integrity
D)   workflow
E)   cardinalityF) A) and D)
G) A) and E)

Question 4

What are the different keys used for in relational databases? How do they maintain the integrity of the information in the database applications?

Accepted Answer

The primary key is also known as the ide...

Question 5

In a relational database,each entity is described by

Accepted Answer

A)   characters.
B)   data.
C)   bytes.
D)   attributes.
E)   records.F) A) and B)
G) C) and D)

Question 6

There is (are) ________ style(s) of E-R diagrams.

Accepted Answer

A)   2
B)   one
C)   several
D)   15
E)   10F) A) and B)
G) None of the above

Question 7

A(n) ________ data model captures the entities and their relationships in a database application.

Accepted Answer

A)   workflow
B)   O-O
C)   Semantic Object
D)   E-R
E)   flowchartF) C) and E)
G) B) and C)

Question 8

Tables are transformed into ________ to remove duplicate data and other problems.

Accepted Answer

A)   regular design
B)   normalized design
C)   regular form
D)   normal form
E)   relational formF) D) and E)
G) B) and E)

Question 9

Any mistake in the data modeling stage will come back to haunt you.

Accepted Answer

A) True 
 B)False

Question 10

A person,place or object would be represented in a database application as a(n)

Accepted Answer

A)   entity.
B)   record.
C)   table.
D)   class.
E)   object.F) A) and B)
G) None of the above

Question 11

________ is the process of converting poorly-structured tables into two or more well-structured tables.

Accepted Answer

A)   Application development
B)   Normalization
C)   Structuring
D)   Clarification
E)   ConversionF) B) and E)
G) All of the above

Question 12

When a student can have more than one adviser it is a N:M relationship.

Accepted Answer

A) True 
 B)False

Question 13

An entity is something you want to track.

Accepted Answer

A) True 
 B)False

Question 14

Each entity should have one unique identifier.

Accepted Answer

A) True 
 B)False

Question 15

In a one-to-many relationship,the foreign key is stored in the table that is on the ________ side of the relationship.

Accepted Answer

A)   weak
B)   many
C)   many-to many
D)   one
E)   cardinalF) A) and E)
G) A) and D)

Question 16

In an automobile table the ________ would make the best table key

Accepted Answer

A)   model
B)   a combination of make and model
C)   make
D)   license plate number
E)   VINF) A) and B)
G) D) and E)

Question 17

A data model describes the data and relationships that will be stored in the database.

Accepted Answer

A) True 
 B)False

Question 18

Normalization is a process that helps ensure that the tables from the database design process are well structured.

Accepted Answer

A) True 
 B)False

Question 19

E-R diagrams are too cumbersome for use in database design discussions.

Accepted Answer

A) True 
 B)False

Question 20

Database developers ________ as the first step in development.

Accepted Answer

A)   interview users
B)   create a relational model
C)   create an E-R diagram
D)   create a data model
E)   write queriesF) A) and E)
G) B) and C)

Exam 15: Database Design and Entity Relationships

In a relational database,each entity is described by

Correct AnswerverifiedShow Answer

"PartNumber" would be a good identifier for a part entity in a database application.

Correct AnswerverifiedShow Answer

Each entity should have one unique identifier.

Correct AnswerverifiedShow Answer

In a one-to-many relationship,the foreign key is stored in the table that is on the ________ side of the relationship.

Correct AnswerverifiedShow Answer

________ is the process of converting poorly-structured tables into two or more well-structured tables.

Correct AnswerverifiedShow Answer

What are the different keys used for in relational databases? How do they maintain the integrity of the information in the database applications?

Correct AnswerverifiedThe primary key is also known as the ide...View AnswerShow Answer

E-R diagrams are too cumbersome for use in database design discussions.

Correct AnswerverifiedShow Answer

Tables are transformed into ________ to remove duplicate data and other problems.

Correct AnswerverifiedShow Answer

There is (are) ________ style(s) of E-R diagrams.

Correct AnswerverifiedShow Answer

Any mistake in the data modeling stage will come back to haunt you.

Correct AnswerverifiedShow Answer

A person,place or object would be represented in a database application as a(n)

Correct AnswerverifiedShow Answer

Users need to verify the data model for correctness.

Correct AnswerverifiedShow Answer

Normalization is a process that helps ensure that the tables from the database design process are well structured.

Correct AnswerverifiedShow Answer

When a student can have more than one adviser it is a N:M relationship.

Correct AnswerverifiedShow Answer

A(n) ________ data model captures the entities and their relationships in a database application.

Correct AnswerverifiedShow Answer

An entity is something you want to track.

Correct AnswerverifiedShow Answer

A data model describes the data and relationships that will be stored in the database.

Correct AnswerverifiedShow Answer

The ________ shows the number of entities that can be involved in a relationship.

Correct AnswerverifiedShow Answer

Database developers ________ as the first step in development.

Correct AnswerverifiedShow Answer

In an automobile table the ________ would make the best table key

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
The primary key is also known as the ide...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified