4 Datebase Management Questions homework help

4 Datebase Management Questions homework help

Answer the following questions. Other than #2 (problem and exercises 5), diagrams are required for all.

 

1. Problems and Exercises 3 (c, d, e) (Page 144) 25 Points

For simplicity, subtype discriminators were left off many figures in this chapter. Add subtype discriminator notation in each figure listed below. If necessary, create a new attribute for the discriminator.

c. Figure 3-4b (page 119)

d. Figure 3-7a (page 123)

e. Figure 3-7b (page 127)

2. Problems and Exercises 5 (Page 144) 25 Points

Refer to the EER diagram for patients in Figure 3-3 (page 118). Make any assumptions you believe are necessary. Develop sample definitions for each entity type, attribute, and relationship in the diagram.

3. Problems and Exercises 8 (Page 144) 25 Points

At a weekend retreat, the entity type PERSON has three subtypes: CAMPER, BIKER, and RUNNER. Draw a separate EER diagram segment for each of the following situations:

 

1. At a given time, a person must be exactly one of these subtypes.

2. A person may or may not be one of these subtypes. However, a person who is one of these subtypes cannot at the same time be one of the other subtypes.

3. A person may or may not be one of these subtypes. On the other hand, a person may be any two (or even three) of these subtypes at the same time.

4. d. At a given time, a person must be at least one of these subtypes.

 

 

4. Problems and Exercises 9 (Page 144) 25 Points

A bank has three types of accounts: checking, savings, and loan. Following are the attributes for each type of account:

CHECKING: Acct No, Date Opened, Balance, Service Charge

SAVINGS: Acct No, Date Opened, Balance, Interest Rate

LOAN: Acct No, Date Opened, Balance, Interest Rate, Payment

 

Assume that each bank account must be a member of exactly one of these subtypes. Using generalization, develop an EER model segment to represent this situation

using the traditional EER notation, the Visio notation, or the subtypes inside supertypes notation, as specified by your instructor. Remember to include a subtype discriminator.

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!