Hotel database

What constraints do the partial key and the identifying relationship of the weak entity type specify in this diagram? Write concisely the user requirements that led to this ER schema design.

Databases Question [14 marks] Question 1: Consider the ER diagram shown in Figure 1 for part of a BANK database. Each bank can have multiple branches, and each branch can have multiple accounts and loans. 1. List the non-weak entity types in the ER diagram. 2. Is there a weak entity type? If so, give […]

Scroll to top