Deck 19: Database Design

Question 1

In a classroom,each student can have multiple advisers.In a data model,this can be best represented by which of the following notations?

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

Answer 1

C

Question 2

A database application consists of forms,reports,queries,and application programs.

Answer 2

True

Question 3

Maximum cardinality in an E-R diagram refers to ________.

A) the maximum number of relationships possible in a diagram
B) the maximum number of entities that can be involved in a relationship
C) the maximum number of constraints possible for a particular relationship
D) the maximum number of attributes an entity can have

Answer 3

B

Question 4

The easiest time to change the database structure is ________.

A) during the data modeling stage
B) after constructing the database
C) during the data designing stage
D) after creating the application programs

Question 5

Normalized tables eliminate ________.

A) database design
B) data duplication
C) data entry
D) data conversion

Question 6

Database practitioners classify tables into various ________ according to the kind of problems they have.

A) entities
B) data models
C) normal forms
D) attributes

Question 7

Once the users have validated and approved the data model,it is transformed into a ________.

A) database design
B) requirement report
C) knowledge management system
D) data repository

Question 8

The acronym UML refers to ________.

A) unified markup language
B) unified modeling language
C) uniform markup language
D) uniform modeling language

Question 9

________ are attributes whose values are associated with one and only one entity instance.

A) File numbers
B) Descriptors
C) Titles
D) Identifiers

Question 10

Which of the following is a highly popular technique for creating a data model where the developers describe the content of a database by defining the things that will be stored in the database and the relationships among those entities?

A) E-R model
B) UML model
C) Object-Role model
D) Three Schema model

Question 11

The little lines in an E-R diagram used as shorthand for the multiple lines between two entities are referred to as ________.

A) a crow's foot
B) identifiers
C) attributes
D) a tracker

Question 12

Entities have ________ that describe the characteristics of the entities.

A) attributes
B) data models
C) cardinalities
D) relationships

Question 13

A database model can be transformed into a database design only after the users have approved and validated it.

Question 14

A data model ________.

A) is created after the database is designed
B) is an attribute whose value is associated with only one entity instance
C) is a logical representation of the structure of the data
D) does not describe the relationships among data

Question 15

The ________ notation signifies that an adviser can be related to many students and that a student can be related to many advisers.

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

Question 16

The data model contains a description of the data.However,the model does not depict the relationships among the data.

Question 17

The process of converting poorly structured tables into two or more well-structured tables is referred to as ________.

A) replication
B) duplication
C) actualization
D) normalization

Question 18

Which of the following is true for data models?

A) An identifier's value is associated with every entity in the data model.
B) An attribute is some thing that the users want to track.
C) Entities have attributes that describe characteristics of the entity.
D) The relationships between entities are known as attributes.

Question 19

The general goal of normalization is to ________.

A) create a copy of an existing table
B) construct tables such that every table has a similar topic
C) convert two or more tables into a single table
D) construct tables such that every table has a single topic

Question 20

________ is an example of an attribute in the E-R model.

A) Order
B) Salesperson
C) Order number
D) Customer

Question 21

The easiest time to change the database structure is after the database has been constructed and loaded with data.

Question 22

Normalization is the process of combining two or more poorly structured tables into a single structured table.

Question 23

An identifier is an attribute whose value is associated with only one entity instance.

Question 24

The crow's-foot notation shows the minimum number of entities that can be involved in a relationship.

Question 25

Because normalized designs can be slower to process,database designers sometimes choose to accept non-normalized tables.

Question 26

In E-R diagrams,the attributes are represented with crow's feet.

Question 27

Explain the database development process.

Question 28

How is a data model transformed into a database design?

Question 29

In an E-R diagram,a line is used to represent a relationship between two entities.

Question 30

Explain the difference between maximum and minimum cardinality.

Question 31

What are the different types of relationships represented in a data model?

Question 32

Explain the role of users in designing a database.

Question 33

Tables that are not normalized are subject to data integrity problems.

Question 34

The maximum number of entities that can be involved in a relationship is known as maximum cardinality.

Question 35

In a data model,the entity names are always plural.

Question 36

The notation N:N is used to indicate a many-to-many relationship in E-R diagrams.

Question 37

Transforming a table into a normal form to remove duplicated data and other problems is called normalizing the table.

Question 38

The UML model is the most popular tool for creating a data model.

Question 39

N:M means that more than one entity is allowed on each side of the relationship and that the number of entities on each side can be different.

Question 40

Entities have relationships to attributes,but not to each other.