Assignment #$3$

$5\mathrm{.}56$ Examine the subscription form shown in Figure $5-53.$ Using the structure of this form, do the following:

Subscription Form

$1$ year $(6$ issues$)$ for just $$18-20\%$ off the newsstand price. $($Outside the U$.$S$.$ S$21/$year$-$U$.$S$.$ funds, please$)$

$2$ years $(12$ issues$)$ for just $$34-$ save $24\%($Outside the U$.$S$.$ S$40/2$ years$-$U$.$S$.$ funds, please$)$

Name $q,$

Address $q,$

City.

State

Zip

My payment is enclosed. $$ Please bill me$.$

Please start my subscription with

current issue

next issue.

Figure $5-53-$ Subscription Form

A Create a model with one entity. Specify the identifier and attributes. B Create a model with two entities, one for customer and a second for subscription. Specify identifiers, attributes, relationship name, type, and cardinalities.

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

$5\mathrm{.}57$ Examine the list of e$-$mail messages in Figure $5-54.$ Using the structure and example data items in this list, do the following:

$\backslash$table$[[,$From,Subject,Date $,$Size$],[\backslash$Gamma $,$SailorBob$256$e somewhere.com,Big Wind,$5/13/2018,3$ KB$],[\backslash$Gamma $,$SailorBob$256$somewhere$.$com,Updato,$5/12/2018,4$ KB$],[\backslash$Gamma $,$SailorBob$256$ somewhere.com,Re: Saturday Am$,5/11/2018,4$ KB$],[\backslash$Gamma $,$SailorBob$2560$somewhere.com,Re: Weather window!,$5/10/2018,4$ KB$],[\backslash$Gamma $,$SailorBob$256$ somewhere.com,Ro: Howdy!,$5/10/2018,3$ KB$],[\backslash$Gamma $,$SailorBob$2560$somewhere.com,Still here,$5/9/2018,3$ KB$],[\backslash$Gamma $,$SailorBob$2560$ somewhere.com,Re: Turle Bay,$5/8/2018,4$ KB$],[\backslash$Gamma $,$SailorBob$2560$somewhere.com,Turle Bay,$5/8/2018,4$ KB$],[\backslash$Gamma $,$SailorBob$2560$somewhere.com,Re: Hi$,5/6/2018,3$ KB$],[\backslash$Gamma $,$SailorBob$2560$somewhere.com,Sunday, Santa Maria,$5/5/2018,3$ KB$],[\backslash$Gamma $,$MotorboatBobby$3140$elsewhere.com,Cabo, Thurs. Noon,$5/2/2018,2$ KB$],[\backslash$Gamma $,$SailorBob$2560$ somewhere.com,turbo,$5/1/2018,3$ KB$],[\backslash$Gamma $,$SailorBob$256$ somewhere.com,on our way,$4/28/2018,3$ KB$],[\backslash$Gamma $,$TugboatAmanda$7569$anotherwhere.com,RE: Hola!,$4/26/2018,3$ KB$],[\backslash$Gamma $,$TugboatAmanda$7569$anotherwhere.com,RE: Hola!,$4/24/2018,2$ KB$],[,$TugboatAmanda$756$ anotherwhere.com,RE: Hola!,$4/23/2018,3$ KB$]]$

Figure $5-54-$E$-$mail List

A Create a single$-$entity data model for this list. Specify the identifier and all entities.

B Modify your answer to $A$ to include entities SENDER and SUBJECT. Specify the identifiers and attributes of entities and the types and cardinalities of the relationships. Explain which cardinalities can be inferred from Figure $5-54$ and which need to be checked out with users.