Deck 9: Extension-Database Design

Question 1

Each entity should have one unique identifier.

Answer 1

True

Question 2

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

Answer 2

True

Question 3

A physical representation of a database is called a data model.

Answer 3

False

Question 4

In E-R diagrams, entities are represented with rectangles.

Question 5

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

Question 6

Once the entities have been defined, the data model can be implemented directly on the DBMS.

Question 7

"Name" would be a good identifier for a customer entity in a database application.

Question 8

Users need to verify the data model for correctness.

Question 9

A data model should show how users see their "world."

Question 10

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

Question 11

"Address" would be a likely attribute of a customer entity in a database application.

Question 12

The object-relationship (OR) technique is the most popular one for creating a data model.

Question 13

The data model should summarize the data requirements as derived from interviews with the end users.

Question 14

In E-R diagrams, attributes can be represented with crow's feet.

Question 15

In a 1:N type of relationship, the foreign key is stored on the "1" side.

Question 16

An entity is something you want to track.

Question 17

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

Question 18

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

Question 19

Users validate and approve the data model prior to its transformation into a database design.

Question 20

The notation N:N indicates a many-to-many relationship.

Question 21

When creating tables for an entity, the identifier of the entity becomes the ________ of the table.

A) master column.
B) key.
C) index attribute.
D) foreign key.
E) index field.

Question 22

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

A) workflow
B) O-O
C) Semantic object
D) E-R
E) flowchart

Question 23

________ is used to indicate a many-to-many relationship.

A) N:M
B) 1:M
C) M:N
D) M:M
E) 1:1

Question 24

"One department can have many advisers" is an example of

A) a one-to-many relationship.
B) maximum cardinality relationship.
C) a minimum cardinality relationship.
D) a one-to-one relationship.
E) a many-to-many relationship.

Question 25

A(n) ________ diagram is like a blueprint of a database application.

A) flowchart
B) O-O
C) workflow
D) Entity-relationship (E-R)
E) O-R

Question 26

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

A) Sharing
B) Reengineering
C) Normalization
D) Decentralization
E) Redesigning

Question 27

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

A) entity.
B) record.
C) table.
D) class.
E) object.

Question 28

The easiest time to change a database design is during the data modelling stage.

Question 29

________ is (are) the most popular diagramming tool(s) for database applications.

A) O-O
B) E-R diagrams
C) Flowcharts
D) Workflows
E) UML

Question 30

If the same data element is stored differently in another table, this is said to be an issue of

A) inaccurate data.
B) entity integrity.
C) data repetition.
D) normalization.
E) data integrity.

Question 31

The most confusing type of a relationship is the ________ relationship.

A) 1:N
B) M:M
C) N:M
D) 1:1
E) N:1

Question 32

Normalization is a trade-off between the elimination of data duplication and processing speed.

Question 33

Entities have ________ that describes characteristics of the entity.

A) relations
B) properties
C) attributes
D) names
E) files

Question 34

In a relational database, each entity is described by

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

Question 35

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

Question 36

An example of a one-to-many type of relationship might be

A) an employee cannot be assigned a computer.
B) an employee can be assigned an office.
C) an employee can be assigned more than one computer.
D) an employee can be assigned one and only one computer.
E) an employee is assigned a company car.

Question 37

Entities have an ________ which is an attribute whose value is associated with one and only one entity instance.

A) index
B) agenda
C) attribute
D) initial
E) identifier

Question 38

At times you may not place a field in a table because it can be readily computed in forms or reports.

Question 39

When two rows in a database are supposed to refer to the same thing and they do not, you have a data integrity problem.

Question 40

UML stands for

A) Unified Modeling Language.
B) Unified Metadata Language.
C) United Metadata Language.
D) Universal Metadata Language.
E) Universal Modeling Language.

Question 41

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

A) Application development
B) Normalization
C) Structuring
D) Clarification
E) Conversion

Question 42

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

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

Question 43

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

A) E-R
B) UML
C) data integrity
D) workflow
E) cardinality

Question 44

The cardinality of the relationship between a employer and its employees is

A) 1:N.
B) M:N.
C) N:M.
D) 1:1.
E) N:1.

Question 45

Database practitioners classify tables into various ________ depending on the type of data integrity problems to which they might be subject.

A) layers
B) categories
C) normal forms
D) strata
E) types

Question 46

________ is the last step in developing a database application.

A) Designing the tables with the keys
B) Getting the information requirements
C) Reviewing the data model with users
D) Creating the database
E) Creating a data model

Question 47

Database developers ________ as the first step in development.

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

Question 48

One difficulty with designing database is the ________ number of possibilities of what to include.

A) small
B) minimal
C) large
D) fixed
E) known

Question 49

When you place data into a database, you need to place (the) ________ records first.

A) first
B) foreign key
C) primary key
D) any
E) indexed

Question 50

The user's review of the data model is

A) done after the database is programmed
B) treated as a casual process
C) not necessary
D) not usually done
E) crucial

Question 51

If a student is allowed to have multiple majors and advisers are assigned to multiple students, these would be examples of ________ relationships.

A) M:N
B) N:1
C) 1:1
D) N:M
E) 1:N

Question 52

________ would be the best identifier attribute for an employee table.

A) Birth Date
B) Social Insurance number
C) Last Name
D) Phone number
E) First Name and Last Name

Question 53

On the many side of a relationship, you place the ________ of the ________ relationship to represent the relationships in the database.

A) foreign key, one side
B) primary key, one side
C) index key, one side
D) primary key, many side
E) foreign key, many side

Question 54

A 1:N relationship relates ________ record(s) to ________ record(s) in a database.

A) many, one
B) one, three
C) one, one
D) many, many
E) one, many

Question 55

Understanding how to interpret E-R diagrams will help you interpret ________ with a bit of study.

A) flow diagrams
B) relational models
C) UML models
D) O-O models
E) workflow models

Question 56

A crow's foot diagram is a type of

A) relationship map.
B) data model.
C) E-R diagram.
D) UML model.
E) normalization model.

Question 57

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

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

Question 58

A N:M relationship is represented with a(n)

A) intersection table.
B) entity.
C) composite table.
D) linking field.
E) index field.

Question 59

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

A) weak
B) many
C) many-to many
D) one
E) cardinal

Question 60

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

A) two
B) one
C) several
D) 15
E) 10

Question 61

A(n) ________ is an attribute or group of attributes whose value is associated with one and only one entity instance.

Question 62

An E-R data model captures both the entities involved and the ________ between the entities.

Question 63

________ cardinality indicates the most entities that can be involved in a relationship.

Question 64

A(n) ________ is a characteristic of an entity.

Question 65

Entities have ________ with one another.

Question 66

The number of entities that can be involved in a relationship in a data model is called the ________.

Question 67

________ form removes duplicate data and other problems from a table.

Question 68

A(n) ________ is an attribute or group of attributes whose value is associated with one and only one entity instance.

Question 69

In an E-R data model, the crow's feet symbol is used to indicate the ________ side of the relationship.

Question 70

In order to represent a(n) ________ type of relationship, a third table is created using the keys from the two entities being related.

Question 71

________ problems can occur when data is duplicated.

Question 72

The easiest time to change a database is during the ________ stage.

Question 73

The foreign key is put on the ________ side of a one-to-many relationship.

Question 74

________ is a process for ensuring that the tables in a database design are efficient and well-structured.

Question 75

When a table contains inaccurate data for the same data elements in a table, it is said that the data in the table lacks ________.

Question 76

A(n) ________ is something users want to track.

Question 77

A crow's foot diagram is a type of ________.

Question 78

The easiest time to make changes to the database structure is during the ________ phase.

Question 79

________ is the notation used to describe a many-to-many relationship.

Question 80

________ is the second most popular data modeling technique.