Question 1

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

Accepted Answer

A data model is a logical representation of the structure of the data. It defines the entities, their attributes, and the relationships between them. It provides a conceptual framework for organizing and understanding data, which can then be implemented in a database management system.

Question 2

Entities have attributes that describe characteristics of the entity.

Accepted Answer

Attributes are used to describe characteristics of an entity.

Question 3

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

Each student can only be tutored by Roger, indicating a one-to-many relationship between Roger and the students he tutors. Therefore, a 1:N relationship is the best representation for this scenario.

Question 4

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

The angled lines in an entity-relationship (E-R) diagram used as shorthand to represent multiple relationships are referred to as crow's foot. The crow's foot notation is used in Barker's Notation, Structured Systems Analysis and Design Method (SSADM) and information engineering.

Question 5

Explain the database development process.

Accepted Answer

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

Question 6

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, depicting how data is connected and structured. Option A is incorrect because a data model is created before the database is designed to give a blueprint for how the database should be constructed. Option B is incorrect because a unique attribute is associated with only one entity instance, but that does not necessarily relate to the data model. Option D is incorrect because data models explicitly describe relationships between data.

Question 7

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

Accepted Answer

A data model does depict the relationships among the data. It is a visual representation of the data's organization, relationships, and rules.

Question 8

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

Accepted Answer

The answer of A database contains a description of both...

Question 9

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 10

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. It enables developers to describe the content of a database by defining what is to be stored in the database and the associations among them. The E-R data model allows the developers to conceptualize the database in terms of entities, attributes, and relationships, which makes it easier to optimize performance, create efficient queries, and ensure data integrity. The other options, such as UML, object-relational model, and semantic data model, are not typically used for creating data models specifically for databases.

Question 11

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 creating the actual database.

Question 12

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 or characteristics of Carol's order. Dependencies refer to relationships among data elements, cardinalities represent how many instances of one entity can be linked to instances of another entity, and alternatives refer to different options or choices.

Question 13

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 signifies a many-to-many relationship where a student can have many advisers and an adviser can have many students. Option A (1:N) signifies a one-to-many relationship where an adviser can have many students, but a student can only have one adviser. Option C (N:1) signifies a many-to-one relationship where a student can only have one adviser, but an adviser can have many students. Option D (N:N) signifies a bi-directional many-to-many relationship, which is essentially the same as option B.

Question 14

Entities have relationships to attributes but not to each other.

Accepted Answer

Entities can have relationships with other entities in a data model. For example, a customer entity may have a relationship with an order entity, indicating that a customer can place multiple orders.

Question 15

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 16

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

The maximum cardinality in an E-R diagram refers to the maximum amount of entities that can be involved in a relationship. This is usually denoted by the symbols "1" or "M" for one or many, respectively, on each side of the relationship line.

Question 17

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 a particular entity instance in a table. Option A is incorrect as it describes minimum cardinality constraints. Option B is incorrect as it describes user-defined data. Option C is incorrect as it describes the identification of data duplication, whereas identifiers are used to uniquely identify a particular entity instance.

Question 18

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 19

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

Accepted Answer

A line with diamonds on each end is used to represent a relationship between two entities in an E-R diagram.

Question 20

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

Quiz 17: Database Design

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

Entities have attributes that describe characteristics of the entity.

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

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

Explain the database development process.

Which of the following is TRUE of a data model?

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

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

Which of the following is TRUE of entities?

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?

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

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?

Entities have relationships to attributes but not to each other.

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

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

Which of the following statements is TRUE of identifiers?

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

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

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