Question 1

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

Accepted Answer

In an entity-relationship (E-R) diagram, a line or connector is used to represent a relationship between two entities. The type of line used depends on the nature of the relationship, such as a solid line for a strong relationship and a dotted line for a weak relationship.

Question 2

The little 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 the commonly used graphical representation of entities and their relationships in E-R diagrams. The little lines on the entity's side indicate the number of relationships an entity can have with other entities.

Question 3

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

C

Question 4

________ describe the characteristics of entities.
A)Attributes
B)Dependencies
C)Cardinalities
D)Alternatives

Accepted Answer

Attributes are the characteristics that describe entities. Dependencies refer to relationships between entities or attributes. Cardinalities describe the number of instances of one entity that are related to instances of another entity. Alternatives typically refer to different possible pathways or options in a system. Therefore, the best choice to describe the characteristics of entities is A) Attributes.

Question 5

________ are attributes whose values are associated with one,and only one,entity instance.
A)Cardinalities
B)Descriptors
C)Dependencies
D)Identifiers

Accepted Answer

Identifiers are attributes that are unique to each entity instance and are used to differentiate one entity instance from another. They are commonly used as primary keys in a database management system.

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

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 that many advisers can be related to many students, also known as a many-to-many relationship.

Question 8

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

Accepted Answer

It is important to gain user validation and approval before proceeding with construction of a database design to ensure that it meets their requirements and needs.

Question 9

Entities have relationships to attributes but not to each other.

Accepted Answer

Entities can have relationships with each other, represented as lines connecting them in entity-relationship diagrams.

Question 10

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

Accepted Answer

A data model defines the organization and structure of data in a database system in a logical way, without considering how the data will actually be stored or accessed.

Question 11

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 popular technique used to create a data model. It allows developers to describe the content of a database by defining what is to be stored in the database and the associations among them. It is widely used due to its simplicity and ease of use. The other options, like UML and object-relational model, are not primarily designed for creating data models.

Question 12

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

Accepted Answer

A data model depicts the relationships among the data.

Question 13

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

The validated and approved data model is transformed into a database design, which specifies the structure and organization of the actual database.

Question 14

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. It helps to organize the data into a format that makes sense for the specific needs of an application or system. It does not necessarily have to be created after the database is designed, and it can describe relationships among the data. However, option C is the most accurate definition of a data model. Option B describes a unique attribute, and option D is incorrect in stating that a data model does not describe relationships.

Question 15

Entities have attributes that describe characteristics of the entity.

Accepted Answer

This statement is true. Attributes are the characteristics or properties that describe the entity. For example, the attributes of a person entity might include their name, age, and address.

Question 16

Explain the database development process.

Accepted Answer

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

Question 17

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 18

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 19

In a university,each adviser can advise multiple students,but each student can have only one adviser.In a data model,this can be best represented by ________.
A)N:M relationships
B)N:N relationships
C)1:N relationships
D)1:1 relationship

Accepted Answer

This is a 1:N relationship where each adviser can advise multiple students, but each student can have only one adviser. Therefore, students are associated with one adviser each, but advisers can be associated with multiple students.

Question 20

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 in an E-R diagram refers to the maximum number of entities that can be involved in a particular relationship. It specifies the upper limit of the number of entities that can participate in a relationship. For example, in a student and course relationship, the maximum cardinality for the student entity can be either 1 or many, as a student can take multiple courses, whereas the maximum cardinality for the course entity can be only 1, as a course can be taken by many students but taught by only one professor.

Quiz 17: Database Design

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

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

Which of the following is true of entities?

________ describe the characteristics of entities.

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

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

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 should be transformed into a database design only after the users have approved and validated it.

Entities have relationships to attributes but not to each other.

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

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.

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

Which of the following is true of a data model?

Entities have attributes that describe characteristics of the entity.

Explain the database development process.

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

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

In a university,each adviser can advise multiple students,but each student can have only one adviser.In a data model,this can be best represented by ________.

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