Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Answer the following questions using IE Crow's Foot notation. Examine the subscription form shown in Figure 1 . Using the structure of this form, do

Answer the following questions using IE Crow's Foot notation.
Examine the subscription form shown in Figure 1. 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. S21/year-U.S. funds, please)
2 years (12 issues) for just $34-save 24%
(Outside the U.S. S40/2 years -U.S. funds, please)
Name
Address
City State Zip
My payment is enclosed. Please bill me.
Please start my subscription with current issue next issue.
Figure 1- Subscription Form
Create a model with one entity. Specify the identifier and attributes.
a. Create a model with two entities, one for customer and a second for subscription. Specify identifiers, attributes, relationship name, type, and cardinalities.
The E-R Crow's Foot model above is based on the following data:
\table[[RELATIONSHIP,CARDINALITY],[PARENT,CHILD,TYPE,MAX,MIN],[,,,,]]
Under what conditions do you prefer the model in A to that in B?
Under what conditions do you prefer the model in B to that in A?
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions