Deck 15: Database Design and Entity Relationships

Question 1

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

Answer 1

True

Question 2

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

Answer 2

False

Question 3

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

Answer 3

False

Question 4

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

Question 5

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

Question 6

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

Question 7

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

Question 8

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

Question 9

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

Question 10

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

Question 11

Users need to verify the data model for correctness.

Question 12

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

Question 13

Each entity should have one unique identifier.

Question 14

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

Question 15

An entity is something you want to track.

Question 16

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

Question 17

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

Question 18

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

Question 19

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

Question 20

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

Question 21

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 22

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 23

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 24

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

Question 25

In a relational database,each entity is described by

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

Question 26

UML stands for

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

Question 27

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 28

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 29

________ 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 30

________ 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 31

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

Question 32

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 33

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 34

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 35

"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 36

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 37

________ 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 38

Entities have ________ that describes characteristics of the entity.

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

Question 39

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

Question 40

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

Question 41

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 42

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 43

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

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

Question 44

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 45

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 46

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 47

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 48

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 49

________ 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 50

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 51

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 52

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 53

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 54

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

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

Question 55

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 56

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 57

________ 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 58

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 59

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

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

Question 60

________ 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 61

What are the stages in developing a database application? At what point is it easiest to make changes?

Question 62

Describe how normalization works.

Question 63

Describe an E-R diagram.

Question 64

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

Question 65

What are the different types of relationships represented in a data model? How are these captured by the use of keys?