Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The Blackout Coalition is building a database to store information on Black - owned financial institutions as a part of their #BankBlack campaign. Each institution
The Blackout Coalition is building a database to store information on Blackowned
financial institutions as a part of their #BankBlack campaign. Each institution is identified
by a unique code and also has a name, URL, and classification eg bank vs credit
union If applicable, the database also records the name of each institutions insurer.
For instance, Adelphi Bank is a member of the Federal Deposit Insurance Corporation.
An institution may or may not be a subsidiary of one other institution. A single institution
may have multiple subsidiaries, but is not required to have any.
Each institution may have multiple branches, though some are onlineonly and do not
have any branches. A branch belongs to exactly one institution. Branches have a unique
ID and address eg Gray Street, Suite B College Station, AR
Standalone branches do not have unitsuite information. Branches also have a list of
services offered, like ATMs, personal loans, andor notary services.
Financial institutions have at least individuals who serve on their board of directors.
Individuals have a unique ID name including first, middle, last, and suffix and race.
Some have just a first and last name. One individual may serve on the board of directors
for multiple institutions, and must serve at least one to be included in the database.
Whenever an individual is on the board of directors for an institution, the database tracks
their role if applicable For example, one individual can serve as the Chair of the board
for an institution and also serve on the board of a different institution with no special role.
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