Question: For questions 1 6 , please use the logical entity - relationship ( ER ) model in Figure 1 to answer the questions. Figure 1

For questions 16, please use the logical entity-relationship (ER) model in Figure 1 to answer the questions.
Figure 1. Bank Accounts ER Model
Figure 1. Bank Accounts ER Model
QUESTION 1
List the names of each entity, the key attributes of each, and the non-key attributes of each.
QUESTION 2
What is the cardinality (both minimum and maximum) of each relationship?
QUESTION 3
According to this model, can an account have more than one customer? If yes, why? If no, why not?
QUESTION 4
How can a transaction be linked to an account, a merchant, and a transaction type all at the same time?
QUESTION 5
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 6
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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!