Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Entity Relationship Model

Total questions: 40

Worksheet time: 20mins

Name
Class
Date
1.

What is an Entity Relationship Diagram?

a)

An Entity Relationship Diagram is a relationship between properties of entities in a database.

b)

An Entity Relationship Diagram is a type database table connections.

c)

An Entity Relationship Diagram is a type of database programming.

d)
An Entity Relationship Diagram (ERD) is a visual representation of the relationships between entities in a database.
2.

What is represented by a rectangle in an entity-relationship diagram?

a)
Entity
b)
Database
c)
Attribute
d)
Relationship
3.

In an ERD, what does a diamond-shaped symbol represent?

a)
Relationship
b)
Cardinality
c)
Entity
d)
Attribute
4.

Which of the following is not a cardinality constraint used in ER diagrams?

a)

One-to-One

b)

Many-to-Many

c)

One-to-Many

d)

All-to-All

5.

What does the crow's foot notation in an ERD signify?

a)
Many relationship
b)
Foreign key
c)
Primary key
d)
One-to-one relationship
6.

What does the line connecting two entities in an ERD represent?

a)
Link
b)
Relationship
c)
Association
d)
Connection
7.

In an ERD, what does a double rectangle represent?

a)
Primary key
b)
Foreign key
c)
Weak entity
d)
Attribute
8.

What is the purpose of an ERD's cardinality constraints?

a)
To determine the data types of attributes in a database model.
b)
To specify the primary keys of entities in a database model.
c)
To define the order of records in a database model.
d)
To define the relationships between entities in a database model.
9.

Which of the following is true regarding a composite attribute in an ERD?

a)
A composite attribute cannot have sub-parts.
b)
A composite attribute is always a single value.
c)
A composite attribute can be divided into smaller sub-parts.
d)
A composite attribute cannot be represented in an ERD.
10.

In an ERD, what is the cardinality notation for a One-to-Many relationship?

a)
diamond
b)
arrow
c)
circle
d)
1 - crows foot
11.

In an ERD, what does the term "superkey" refer to?

a)

An attribute that uniquely identifies an entity within an entity set.

b)
A key that is used for indexing purposes only.
c)

A key that is not a candidate key

d)
A set of attributes that represent a foreign key in a relation.
12.

What is an entity set in an entity-relationship diagram (ERD)?

a)
A group of unrelated entities with different attributes.
b)
A single entity with unique attributes.
c)
A relationship between two entities.
d)
A collection of similar entities with common attributes.
13.

Which of the following best describes the cardinality of an entity set in an ERD?

a)
It defines the data type of the attributes in the entity set
b)
It represents the primary key of the entity set
c)
It specifies the total number of attributes in the entity set
d)

The number of entities in the set

14.

In an ERD, what is represented by an oval-shaped symbol?

a)
Attribute
b)
Relationship
c)
Entity
d)
Table
15.

What is the primary purpose of an entity set in an ERD?

a)
To represent a single entity in the database schema
b)
To store metadata about the database schema
c)
To define relationships between entities
d)
To represent a collection of similar entities in the database schema
16.

Which of the following is an example of an entity set in an ERD for a university database?

a)
Libraries
b)
Buildings
c)
Professors
d)
Students or Courses
17.

How are entities related within an entity set in an ERD?

a)
Entities within an entity set in an ERD are related through functions.
b)
Entities within an entity set in an ERD are related through relationships.
c)
Entities within an entity set in an ERD are related through classes.
d)
Entities within an entity set in an ERD are related through attributes.
18.

What does the term "entity type" refer to in the context of an entity set?

a)
Category or classification of entities within an entity set
b)
Order of the entities in the entity set
c)
Size of the entities in the entity set
d)
Color of the entities in the entity set
19.

Which of the following statements about entity sets is true?

a)
Entity sets can only contain entities of the same type
b)
Each entity set corresponds to a column in a relational database
c)
Entity sets are used to store non-related entities in a database
d)
Entity sets are collections of similar entities, and each entity set corresponds to a table in a relational database.
20.

What is an attribute in an entity-relationship diagram (ERD)?

a)
An attribute in an ERD is a primary key
b)
An attribute in an ERD is a relationship between entities
c)
An attribute in an entity-relationship diagram (ERD) represents a property or characteristic of an entity.
d)
An attribute in an ERD is a data type
21.

Which of the following is an example of a composite attribute in an ERD?

a)
Address
b)
Date of Birth
c)
Email
d)
Phone Number
22.

What does a derived attribute in an ERD represent?

a)
An attribute whose value can be derived from other attributes in the database.
b)
An attribute that is mandatory for all entities
c)
An attribute that is not related to any other attribute
d)
An attribute that cannot be modified
23.

Which of the following is an example of a multivalued attribute in an ERD?

a)
home addresses
b)
phone numbers
c)
social security numbers
d)

student numbers

24.

What is the purpose of an attribute type in an ERD?

a)
To determine the primary key of the entity
b)
To specify the relationship between entities
c)
To define the color scheme of the ERD diagram
d)
To define the kind of data that can be stored in a specific attribute of an entity.
25.

Which of the following is not a valid attribute type in an ERD?

a)
integer
b)

float

c)
string
d)

table

26.

What does a key attribute represent in an ERD?

a)
A key attribute in an ERD represents a random value for each entity instance.
b)
A key attribute in an ERD represents a non-unique identifier for each entity instance.
c)
A key attribute in an ERD represents the most common value for each entity instance.
d)
A key attribute in an ERD represents a unique identifier for each entity instance.
27.

Which of the following is an example of a single-valued attribute in an ERD?

a)
Name
b)

Grade

c)
Address
d)
Age
28.

What does the term "composite attribute" refer to in an ERD?

a)
A composite attribute in an ERD refers to an attribute that can be divided into smaller sub-parts, each representing a separate attribute within the entity.
b)
A composite attribute in an ERD refers to an attribute that is a primary key for each entity
c)
A composite attribute in an ERD refers to an attribute that is optional for each entity
d)
A composite attribute in an ERD refers to an attribute that is unique to each entity
29.

In an ERD, what does a multivalued attribute represent?

a)
It represents an attribute that can have multiple values for a single entity instance.
b)
It represents an attribute that can have only one value for a single entity instance.
c)
It represents an attribute that is mandatory for all entity instances.
d)
It represents an attribute that is used for identifying unique entity instances.
30.

Which of the following is an example of a derived attribute in an ERD for a database of students?

a)
date of birth
b)
student ID
c)
total credits earned
d)

address

31.

What is the purpose of a primary key in an entity-relationship diagram (ERD)?

a)
To add color to the diagram
b)
To uniquely identify each record in the entity and establish relationships between entities.
c)
To increase the font size
d)
To confuse the viewers
32.

What does the term "superkey" refer to in an ERD?

a)
A set of attributes that uniquely identifies each column in a table.
b)
A key that is not unique in a relation.
c)
A key that is used for sorting data in a relation.
d)
A set of attributes that uniquely identifies each tuple in a relation.
33.

What does the term "candidate key" signify in an ERD?

a)
Index used for faster data retrieval
b)
Foreign key in a related table
c)

  • A key that is one of the possible choices for the primary key


d)
Primary key for a table
34.

What does cardinality in an entity-relationship diagram (ERD) specify?

a)

It specifies the degree of participation of an entity in a relationship

b)
It specifies the color of entities in the diagram
c)
It specifies the size of entities in the diagram
d)
It specifies the font style of entities in the diagram
35.

Which of the following cardinalities represents a one-to-one relationship in an ERD?

a)
1:N
b)
1:2
c)
M:N
d)
1:1
36.

What does the notation (1:M) signify in an ERD?

a)
Many-to-One Relationship
b)
One-to-One Relationship
c)
Binary Relationship
d)
One-to-Many Relationship
37.

In an ERD, what does the cardinality (0, M) represent?

a)
One entity can be associated with zero instances of another entity.
b)
One entity can be associated with zero or multiple instances of another entity.
c)
One entity can be associated with multiple instances of another entity.
d)
One entity can be associated with exactly one instance of another entity.
38.

Which of the following represents a many-to-many relationship in an ERD?

a)

(M:M)

b)

(0:N)

c)

(1:M)

d)

(1:1)

39.

In a hospital database ERD, each patient can have multiple doctors, but each doctor can treat multiple patients. What cardinality constraint best represents this scenario between the Patient entity set and the Doctor entity set?

a)
One-to-One (1:1)
b)
Many-to-Many (M:N)
c)
One-to-Many (1:M)
d)
Many-to-One (M:1)
40.

In a company database ERD, each employee can have only one manager, but each manager can have multiple employees. What cardinality constraint best represents this scenario between the Manager entity set and the Employee entity set?

a)
One-to-Many
b)
One-to-One
c)
Many-to-One
d)
Many-to-Many

Similar Resources on Wayground

Movies

44 questions

Movies

quiz

Worksheet

•

2nd Grade - Professio...

Chapter 3 File Management

36 questions

Chapter 3 File Management

quiz

Worksheet

•

9th - 12th Grade

K9 - Ngân hàng câu hỏi - HKI

40 questions

K9 - Ngân hàng câu hỏi - HKI

quiz

Worksheet

•

9th Grade

Python - Coding Interpretation

35 questions

Python - Coding Interpretation

quiz

Worksheet

•

9th Grade

Apcsp midterm

38 questions

Apcsp midterm

quiz

Worksheet

•

7th - 12th Grade

01 | Consolidation Activity (Starters 1, 2 & 3)

37 questions

01 | Consolidation Activity (Starters 1, 2 & 3)

quiz

Worksheet

•

9th Grade

Python Assessment 1

40 questions

Python Assessment 1

quiz

Worksheet

•

7th - 9th Grade

98-367 PT3

35 questions

98-367 PT3

quiz

Worksheet

•

9th - 12th Grade