Question 1

A database contains a description of both the data and the relationships among the data.

Accepted Answer

False

Question 2

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

Accepted Answer

Identifiers are attributes whose values are associated with only one entity instance. They are used to uniquely identify entities in a database and differentiate them from other entities. It is important for identifiers to have unique values to ensure the integrity of the database.

Question 3

Which of the following notations signifies that an adviser can be related to many students and that a student can be related to many advisers?
A)1:N
B)N:M
C)N:1
D)N:N

Accepted Answer

N:M represents a many-to-many relationship, in which multiple advisers can be related to multiple students. Therefore, it is the best notation to signify that an adviser can be related to many students and that a student can be related to many advisers.

Question 4

A data model is a logical representation of the structure of the data.

Accepted Answer

A data model is a representation of the organization of data in a database, including the relationships between tables and the constraints on the data. It provides a framework for designing a database and helps ensure that the resulting database is efficient and consistent.

Question 5

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

Accepted Answer

Once the users have validated and approved the data model, it is transformed into a database design, which serves as the blueprint for the actual database implementation.

Question 6

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:N
B)N:N
C)1:1
D)N:M

Accepted Answer

The relationship between the administrative department and the clerk is a one-to-one (1:1) relationship, as there is only one clerk responsible for managing the administrative functions of the department.

Question 7

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

Accepted Answer

Maximum cardinality refers to the maximum number of entities that can be involved in a relationship. It is often represented using the symbols "1" or "N".

Question 8

The angled lines in an entity-relationship (E-R)diagram used as shorthand to represent multiple relationships are referred to as a(n)________.
A)crow's foot
B)identifier
C)attribute
D)cardinality line

Accepted Answer

Crow's foot notation is used in E-R diagrams to represent multiple relationships between entities. The angled lines resemble a crow's foot, thus giving it its name. Identifier refers to a unique attribute that identifies an entity instance. Attribute refers to a characteristic or property of an entity, and cardinality lines represent the minimum and maximum number of relationships between entities.

Question 9

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)attributes
B)dependencies
C)cardinalities
D)alternatives

Accepted Answer

The data that Nigel is tracking, such as the order number and order date, are attributes - characteristics or properties of the order. Dependencies refer to how different attributes relate to each other, cardinalities refer to the number of relationships between entities, and alternatives refer to different options or choices available.

Question 10

An identifier is an attribute whose value is associated with every entity in the data model.

Accepted Answer

An identifier is a name used to uniquely identify a variable, function, class, module, or other object in a code, not an attribute associated with every entity in the data model.

Question 11

Which of the following is true of an entity-relationship (E-R)diagram?
A)Each entity is shown in separate rectangles.
B)Many-to-many relationships are generally denoted by N:N.
C)A crow's foot represents a 1:N relationship between two entities.
D)Crow's foot is a shorthand representation for a single relationship between entities.

Accepted Answer

The answer of Which of the following is true of...

Question 12

Entities have relationships to attributes but not to each other.

Accepted Answer

This statement is incorrect. Entities can have relationships to other entities, known as entity relationships.

Question 13

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

Accepted Answer

The answer of Which of the following is true of...

Question 14

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

Accepted Answer

This statement is true. In an E-R diagram, a line is used to represent a relationship between two entities. The line shows how the two entities are related and can have different symbols such as a crow's foot or a diamond to indicate the type of relationship.

Question 15

Roger teaches a Chemistry class at the state university.Each student in the class can only be tutored by Roger; however, he can tutor multiple students.In a data model, this relationship is best represented as a(n)________.
A)N:M relationship
B)N:N relationship
C)1:N relationship
D)1:1 relationship

Accepted Answer

This is a one-to-many relationship (represented as 1:N in ER diagram notation), where one teacher (Roger) can tutor multiple students, but each student can only be tutored by one teacher (Roger).

Question 16

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

Accepted Answer

A data model is a logical representation of the structure of the data, including the relationships among entities and the attributes associated with those entities. Option A is incorrect because a data model is created during the database design process. Option B is incorrect because a unique attribute value is called a primary key, but not all attributes are primary keys. Option D is incorrect because describing relationships among data is an essential part of creating a data model.

Question 17

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)entity-relationship (E-R)data model
B)Unified Modeling Language (UML)
C)object-relational model
D)semantic data model

Accepted Answer

The entity-relationship (E-R) data model 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. The UML, object-relational model, and semantic data model are also used for creating data models but may not be as widely used or popular as the E-R model.

Question 18

A data model does not depict the relationships among the data.

Accepted Answer

A data model depicts the relationships among the data. It provides a visual representation of how data is organized, stored and accessed within a system.

Question 19

Explain the database development process.

Accepted Answer

The answer of Explain the database development process....

Question 20

Entities have attributes that describe characteristics of the entity.

Accepted Answer

Attributes are characteristics or properties of an entity that help to define its unique features.

Quiz 17: Database Design

A database contains a description of both the data and the relationships among the data.

Which of the following statements is true of identifiers?

Which of the following notations signifies that an adviser can be related to many students and that a student can be related to many advisers?

A data model is a logical representation of the structure of the data.

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

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

Maximum cardinality in an entity-relationship (E-R) diagram refers to the maximum number of ________.

The angled lines in an entity-relationship (E-R) diagram used as shorthand to represent multiple relationships are referred to as a(n) ________.

An identifier is an attribute whose value is associated with every entity in the data model.

Which of the following is true of an entity-relationship (E-R) diagram?

Entities have relationships to attributes but not to each other.

Which of the following is true of entities?

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

Roger teaches a Chemistry class at the state university.Each student in the class can only be tutored by Roger; however, he can tutor multiple students.In a data model, this relationship is best represented as a(n) ________.

Which of the following is true of a data model?

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 data model does not depict the relationships among the data.

Explain the database development process.

Entities have attributes that describe characteristics of the entity.