ER Diagrams [18 points]

[4 points] True or False:

1. ER diagrams are used to model the physical schema of a database.

    False, they are used to model the logical schema. Physical schema refers to things like file and index layout.

2. An entity set E can be associated with a relationship set R more than once.

    True, for example a relationship Reports_To which has the entity Employees participating twice, since Managers are also Employees.

3. At most 2 distinct entity sets can be associated with any relationship set R.

    False, for example, a ternary relationship “Covers” with participating entities Employees, Dependents, and Policies.

4. A weak entity set must have total participation in its identifying relationship set.

    True, by definition.