Question 1

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

Accepted Answer

Crow's foot notation is commonly used in E-R diagrams to represent multiple relationships, and the little lines resembling bird feet or claws are used to depict these connections. Attributes represent specific characteristics or properties of entities, entities refer to real-world objects or concepts, and identifiers are unique attributes used to identify entities within the context of the model.

Question 2

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

Accepted Answer

A data model is indeed a logical representation of the structure of the data. It defines how the data is organized, stored, and accessed in a database management system.

Question 3

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

Accepted Answer

A data model depicts the relationships among the data, including the structure, constraints, and rules.

Question 4

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

Accepted Answer

Identifiers are attributes that uniquely identify an entity instance. They have a one-to-one correspondence with each entity instance, therefore their values are associated with only one entity instance. Descriptors describe an entity instance but are not necessarily unique to that instance. Cardinalities and dependencies are related to relationships between entities, not attributes.

Question 5

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 validate the data model with users before moving on to the database design phase to ensure that it meets the requirements and accurately represents the data.

Question 6

A(n)________ notation signifies that an adviser can be related to many students and that a student can be related to many advisers.
A)N:1
B)N:N
C)N:M
D)1:N

Accepted Answer

The answer of A(n)________ notation signifies that an adviser can...

Question 7

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

Accepted Answer

A line is indeed used in an E-R diagram to represent a relationship between two entities. Additionally, symbols such as crow's foot notations or diamonds are often used to further specify the type of relationship.

Question 8

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

Accepted Answer

A data model is a logical representation of the data structure, not a physical one. It defines the entities, attributes, relationships, and constraints of the data in a database. It is usually created before the database is designed, to provide a blueprint for the database design. Option A, C, and D are all incorrect as they do not correctly describe the features and characteristics of a data model.

Question 9

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

Accepted Answer

Entity-relationship (E-R) data modeling is a highly popular technique for creating a data model. It is a graphical representation of entities and their relationships to each other, which helps in describing the content of a database by defining what is to be stored in the database and the associations among them. UML is more commonly used in software development for designing software systems, and the data integrity model and object-relational model are specific types of data models that are not as widely used as the E-R model.

Question 10

Entities have relationships to attributes but not to each other.

Accepted Answer

Entities can have relationships with other entities as well, known as entity relationships.

Question 11

Explain the database development process.

Accepted Answer

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

Question 12

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

Accepted Answer

Maximum cardinality in an E-R diagram refers to the maximum number of entities that can be involved in a relationship. It is used to indicate the maximum number of instances of one entity that can be related to an instance of another entity.

Question 13

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 14

In an organisation,a single clerk is working in the administrative department.The notation that accurately indicates this relationship is ________.
A)N:N
B)1:1
C)1:N
D)N:M

Accepted Answer

The notation 1:1 indicates a one-to-one relationship, meaning that one clerk is working in the administrative department and only in that department. This is the most accurate notation for this situation as there is only one clerk and they are not working in any other departments within the organisation. N:N indicates a many-to-many relationship, 1:N indicates a one-to-many relationship, and N:M indicates a many-to-many relationship.

Question 15

Which of the following is true of entities?
A)The relationships between entities are known as attributes.
B)Entities' characteristics are described by attributes.
C)Entities can only represent a logical construct or transaction,not a physical object.
D)An identifier's value is associated with every entity in the data model.

Accepted Answer

Entities are described by attributes, which are the characteristics or properties of the entities.

Question 16

Which of the following is true of an E-R diagram?
A)Every entity has an identifier.
B)Many-to-many relationships are generally denoted as N:N.
C)A crow's-foot is required to represent a 1:1 relationship.
D)Identifiers are shown in a section at the top of the entity.

Accepted Answer

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

Question 17

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

Accepted Answer

Entities have attributes that describe their characteristics. Alternatives refer to choices or options within a decision-making process. Dependencies refer to relationships between entities. Cardinalities refer to the number of instances of one entity that can be associated with another entity.

Question 18

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

Accepted Answer

Once the users have validated and approved the data model, it will then be transformed into a database design. This design will serve as the blueprint for how the data will be stored, organized, and accessed in a database. A knowledge management system is a broader term that refers to the process of creating, sharing, using, and managing knowledge and information within an organization. A requirement report may include the data model, but it is not the final product. A data repository is a collection of data that is stored and managed in a centralized location, but it does not necessarily involve the organizing and structuring of the data. Therefore, the best choice here is C) database design.

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

Accepted Answer

This scenario represents a one-to-many (1:N) relationship between the adviser and student entities, as each adviser can advise multiple students but each student can only have one adviser.

Question 20

Entities have attributes that describe characteristics of the entity.

Accepted Answer

The answer of Entities have attributes that describe characteristics of...

Quiz 17: Database Design

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

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

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

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

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

A(n) ________ notation signifies that an adviser can be related to many students and that a student can be related to many advisers.

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

Entities have relationships to attributes but not to each other.

Explain the database development process.

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

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

In an organisation,a single clerk is working in the administrative department.The notation that accurately indicates this relationship is ________.

Which of the following is true of entities?

Which of the following is true of an E-R diagram?

________ describe the characteristics of entities.

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

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

Entities have attributes that describe characteristics of the entity.