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.