Question 1: A database is being constructed to keep track of the teams and games of a sports league. A team has a number of players, not all of whom participate in each game. It is desired to keep track of the players participating in each game for each team, the positions they played in that game, and the result of the game. Design an ER schema diagram for this application, stating any assumptions you make. Choose your favorite sport (e.g., soccer, baseball, football).

Question 2: Consider the ER diagram shown in the following figure, for part of a BANK database. Each bank can have multiple branches, and each branch can have multiple accounts and loans.

List the strong (nonweak) entity types in the ER diagram.

Is there a weak entity type? If so, give its name, partial key, and identify- ing relationship.

What constraints do the partial key and the identifying relationship of the weak entity type specify in this diagram?

List the names of all relationship types, and specify the (min, max) constraint on each participation of an entity type in a relationship type. Justify your choices.

List concisely the user requirements that led to this ER schema design

Question 3: Consider the ER diagram in Figure 3.23. Assume that an employee may work in up to two departments or may not be assigned to any department. Assume that each department must have one and may have up to three phone numbers. Supply (min, max) constraints on this diagram. State clearly any additional assumptions you make. Under what conditions would the relationship HAS_PHONE be redundant in this example?

Question 4: Consider the ER diagram in Figure. Assume that a course may or may not use a textbook, but that a text by definition is a book that is used in some course. A course may not use more than five books. Instructors teach from two to four courses. Supply (min, max) constraints on this diagram. State clearly any additional assumptions you make. If we add the relationship ADOPTS, to indicate the textbook(s) that an instructor uses for a course, should it be a binary relationship between INSTRUCTOR and TEXT, or a ternary relationship among all three entity types? What (min, max) con- straints would you put on the relationship? Why?