Question: For questions 1 6 , please use the logical entity - relationship ( ER ) model in Figure 1 to answer the questions. Figure 1
For questions please use the logical entityrelationship ER model in Figure to answer the questions.
Figure Bank Accounts ER Model
Figure Bank Accounts ER Model
QUESTION
List the names of each entity, the key attributes of each, and the nonkey attributes of each.
QUESTION
What is the cardinality both minimum and maximum of each relationship?
QUESTION
According to this model, can an account have more than one customer? If yes, why? If no why not?
QUESTION
How can a transaction be linked to an account, a merchant, and a transaction type all at the same time?
QUESTION
According to this model, can we answer any questions about what types of accounts our customers have? If yes, why? If no why not?
QUESTION
According to this model, can we answer questions about who made a purchase on a specific date from a specific merchant? If yes, why? If no why not?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
