Relational Database Design and Modeling for Software Engineers
0% completed
Previous
Next
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.