Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

There is a software application used in a bank. A bank has many customers. The software stores data about the bank s address, number of

There is a software application used in a bank. A bank has many customers. The software stores data about the banks address, number of employees, and name of the bank manager. It also stores data about a customer, e.g. customer name, social security number, account number, etc. A customer can open one or more accounts with a bank. However, a customer cannot have more than three accounts in a bank.
When creating a data model for this scenario, which of the following would you consider as a constraint as per this description?
A bank has a location address.
A customer has a name.
A customer cannot have more than three accounts in a bank.
The software stores data about the bank, its employees, and its manager

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

Professional Microsoft SQL Server 2012 Administration

Authors: Adam Jorgensen, Steven Wort

1st Edition

1118106881, 9781118106884

More Books

Students also viewed these Databases questions

Question

=+7 How has the COVID-19 pandemic impacted the operations of IHRM?

Answered: 1 week ago