Answered step by step
Verified Expert Solution
Link Copied!

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 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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Oracle Solaris 11.2 System Administration (oracle Press)

Authors: Harry Foxwell

1st Edition

007184421X, 9780071844215

More Books

Students also viewed these Databases questions

Question

State the uses of job description.

Answered: 1 week ago

Question

Explain in detail the different methods of performance appraisal .

Answered: 1 week ago