Back to course home
0% completed
Vote For New Content
Quiz
Question 1
Which type of relationship will you use to represent a Student enrolling in multiple Courses?
A
One-to-One
B
One-to-Many
C
Many-to-Many
D
One-to-Optional
Question 2
In an ER diagram for a hospital, a Patient entity has attributes such as Patient_ID, Name, Address, and Age. The hospital wants to include an attribute for calculating the patient's age from their Date_of_Birth. How should this be represented?
A
Add Age as a simple attribute.
B
Add Age as a derived attribute.
C
Create a separate table for age calculations.
D
Do not include Age in the ER diagram.
Question 3
If a Department can have many Employees, but an employee can only work in one department, what cardinality should you define for the relationship?
A
One-to-Many
B
Many-to-Many
C
One-to-One
D
Many-to-One
Question 4
What is the main difference between a weak entity and a strong entity?
A
Weak entities do not have attributes.
B
Weak entities are always independent.
C
Weak entities depend on a strong entity for identification.
D
Weak entities have multivalued attributes.
Question 5
In an ER diagram, how is cardinality represented?
A
Using primary and foreign keys.
B
By specifying the degree of participation.
C
By attributes connected to entities.
D
By arrows and numbers near relationships.
Question 6
Which of the following is true about composite attributes?
A
They are atomic.
B
They are multivalued.
C
They can be broken down into smaller attributes.
D
They cannot be used in ER diagrams.
Question 7
You are designing an ER diagram for a library management system. If each Book has a unique ISBN, multiple Authors, and a single Publisher, how would you represent this in an ER diagram?
Choose all correct options
Use a multivalued attribute for authors.
Create an entity for authors and relate it to the book entity.
Represent publisher as a weak entity.
Add authors and publishers as attributes of the book entity.
.....
.....
.....
Like the course? Get enrolled and start learning!
Table of Contents
Contents are not accessible
Contents are not accessible
Contents are not accessible
Contents are not accessible
Contents are not accessible