41. In a hospital, each patient may have multiple appointments, and each appointment belongs to exactly one patient. How should this relationship be represented?

A. One-to-one
B. One-to-many
C. Many-to-many
D. Recursive

Answer: B
Explanation:

Each patient can have multiple appointments, making this a one-to-many relationship from Patient to Appointment.

42. In a university, a professor may supervise multiple students, and each student may have only one supervisor. How should this be modeled?

A. One-to-one
B. One-to-many
C. Many-to-many
D. Recursive relationship

Answer: B
Explanation:

This is a one-to-many relationship from Professor to Student because each professor can supervise many students, but a student has only one supervisor.

43. In an e-commerce system, a shopping cart contains multiple products, each with quantity. How should the cart be modeled?

A. Multivalued attribute
B. Weak entity
C. Associative entity
D. Derived attribute

Answer: C
Explanation:

Cart contents involve a relationship-specific attribute (quantity), so an associative entity linking Cart and Product is required.

44. In a library, a book may belong to multiple genres. How should “genre” be represented?

A. Simple attribute
B. Multivalued attribute
C. Weak entity
D. Derived attribute

Answer: B
Explanation:

Since a book can belong to multiple genres, “genre” is a multivalued attribute or can be represented as a separate entity.

45. In a hospital, “Total Bill” is computed from individual treatment charges. How should it be represented?

A. Simple attribute
B. Derived attribute
C. Weak entity
D. Multivalued attribute

Answer: B
Explanation:

Total Bill is a derived attribute because it can be calculated from the sum of individual treatment charges.

46. In a university, “Student Enrollment” links students and courses. It also stores grades. What type of entity is this?

A. Weak entity
B. Associative entity
C. Derived attribute
D. Simple attribute

Answer: B
Explanation:

Enrollment is an associative entity because it connects Student and Course and contains additional attributes like grades.

47. In a company, an employee can hold multiple positions over time. How should “position” be represented?

A. Multivalued attribute
B. Derived attribute
C. Weak entity
D. Simple attribute

Answer: A
Explanation:

Position is a multivalued attribute because an employee may hold multiple positions simultaneously or sequentially.

48. In a banking system, an account may have multiple transactions, and each transaction belongs to exactly one account. How is this relationship represented?

A. One-to-one
B. One-to-many
C. Many-to-many
D. Derived attribute

Answer: B
Explanation:

This is a one-to-many relationship where an account can have multiple transactions, but each transaction belongs to a single account.

49. In a university, a “Transcript” is computed from student grades in courses. How should Transcript be represented?

A. Simple attribute
B. Multivalued attribute
C. Derived attribute
D. Weak entity

Answer: C
Explanation:

Transcript is a derived attribute as it is computed from the grades of all courses taken by the student.

50. In an airline booking system, a flight may have multiple passengers, and each passenger may take multiple flights. How should this be represented?

A. One-to-one
B. One-to-many
C. Many-to-many
D. Derived relationship

Answer: C
Explanation:

This is a many-to-many relationship between Passenger and Flight, best implemented with an associative entity to store booking details.