Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started