Question 5.58 from Kroenke12

Examine the subscription form shown in Figure 5-53. Using the structure of this form, do the following:

Figure 5-53 Subscription Form

5.1  Create a model with one entity. Specify the identifier and attributes.

CustomerID firstName, lastName, address, city, state, ZIP, startDate, endDate

5.2  Create a model with two entities, one for customer and a second for subscription. Specify identifiers, attributes, relationship name, type, and cardinalities.

CustomerID firstName, lastName, address, city, state, ZIP

CustomerID subscriptionStartDate, subscriptionEndDate

5.3  Under what conditions do you prefer the model in A to that in B?

If you only have one magazine.

5.4  Under what conditions do you prefer the model in B to that in A?

If you have more than one magazine that you sell subscriptions to.