An ER model contains:

A university is designing an integrated Research Management Database. The system maintains information about departments, faculty members, students, research projects, laboratories, and equipment. A faculty member belongs to exactly one department and may supervise several students. Based on the above complex E-R modeling scenario, enter your fullname. Students can participate in multiple research projects, while each project may involve multiple students. Faculty members may also mentor other faculty members, creating a recursive relationship. During a research project, a student may use a particular equipment item, and the system records the Experiment Date and Result for that specific association.

A large organization is selecting between two architectures for a web application.

Given:

A PERSON entity has:

During a major online sale, the application server fails while the database server remains operational. Customers cannot place orders because authentication, payment validation, inventory verification, and order processing are performed by the application server. Which architectural conclusion is most appropriate?

A database designer defines Age with the domain {18, 19, ..., 60}. A user attempts to insert Age = 75. Which constraint should reject the operation?

A vehicle rental system specifies:

• A customer rents vehicles.
• A vehicle can be rented by different customers.
• A vehicle is assigned to one branch.
• A branch maintains many vehicles.
• A rental is identified by Customer + Vehicle + Branch.
• A driver handles one rental.
• A driver can handle many rentals.

Which relationship must be modeled as ternary?

For:

Consider: