H13 (CE5) Database Design

In an organization, the administrative department consists of one clerk whose sole responsibility is the management of various administrative functions. The notation that accurately indicates this relationship is ________. A. 1:1 B. N:N C. 1:N D. N:M

A. 1:1

Jackie is a new database administer. She notices that many of the tables are poorly constructed. What should she do to create more well-structured tables? A. Jackie should create a new database. B. Jackie should normalize the tables. C. Jackie should delete the table and begin again. D. There is nothing Jackie can do; once the tables are created they are set.

B. Jackie should normalize the tables

Which of the following is TRUE of entities? A. Entities can only represent a logical construct or transaction, not a physical object. B. The characteristics of entities are described by attributes. C. Entities have an identifier whose value is associated with every entity in the data model. D. The names of entities are always plural.

B. The characteristics of entities are described by attributes

In an entity relationship diagram, constraints on minimum requirements are called ________. A. identifier B. crow's foot C. minimum cardinality D. least cardinality

B. crow's foot

Once the users have validated and approved the data model, it is transformed into a ________. A. data repository B. database design C. knowledge system D. technical report

B. database design

Maximum cardinality in an entity-relationship (E-R) diagram refers to the maximum number of ________. A. identifiers possible in a particular diagram B. entities that can be involved in a relationship C. normalizations possible in a diagram D. attributes associated with an entity

B. entities that can be involved in a relationship

Which of the following is a highly popular technique for creating a data model with which the developers describe the content of a database by defining what is to be stored in the database and the associations among them? A. object-relational model B. semantic data model C. entity-relationship (E-R) data model D. Unified Modeling Language (UML)

C. entity relationship (E-R) data model

Which of the following statements is TRUE of identifiers? A. They highlight instances of data duplication in a database. B. They are constraints on minimum requirements in a relationship. C. They are attributes whose values are associated with only one entity instance. D. They are data that users want to track.

C. they are attributes whose valued are associated with only one entity instance.

Carol, an online shopping customer, raises a complaint stating she had placed an order for books two weeks ago but has still not received them. Nigel, in charge of handling complaints for the site, wants to verify Carol's complaint. He tracks the order number and the order date for Carol's books. The data that Nigel is tracking are also called ________. A. alternatives B. cardinalities C. dependencies D. attributes

D. attributes

Normalized tables eliminate ________. A. data conversion B. data insufficiency C. data dependency D. data duplication

D. data duplication

1:N means that more than one entity is allowed on each side of the relationship. A. True B. False

false

A data model does not depict the relationships among the data. A. True B. False

false

Entities have relationships to attributes but not to each other. A. True B. False

false

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

false

To represent an N:M relationship between two entities, two normalized tables are sufficient. A. True B. False

false

Database practitioners classify tables into various normal forms according to the kinds of problems they have. A. True B. False

true

Entities have attributes that describe characteristics of the entity. A. True B. False

true

Normalization is a database design concept that helps to construct well-structured tables. A. True B. False

true

The general goal of normalization is to construct tables such that every table has a single topic or theme. A. True B. False

true

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

true