Requirements for a banking application

Assignment Help Basic Computer Science
Reference no: EM131102360

Consider the following data requirements for a banking application.

A bank account has an account number, an opening date and a balance. There are two types of accounts: checking and saving. An account must be at least either saving or checking, while some accounts can be both saving and checking. A saving account has an interest rate while a checking account has a minimum deposit amount.

An account owner has an owner id and a start date. An owner may own several accounts, while an account can have several owners. An owner always owns at least one account, while not every account has an owner.

A check has a check number, which is unique only in the same checking account. A check also has a date and an amount. A check must belong to one and only one checking account while a check account may have many checks.

There are two categories of owners: person and company. A person has a first name, a last name, and an SSN. A company has a name, a tax id and an address. Every company is an owner, while not every person is an owner.

A bank employee has an SSN, a name (first and last) and a start date.

Some bank employees are account owners. Each employee-owner has a bonus interest rate.

Draw an EER diagram based on the requirements.

Reference no: EM131102360

Questions Cloud

Analyze the relationships among the three quality principles : Describe each quality principle and show how it is illustrated in the article. Analyze the relationships among the three quality principles. Examine whether the principle in one example might apply to other examples.
Array of monthly sales figures : Write a C++ program using pointers that will create dynamically allocated array of monthly sales figures whose size has been input by the user. After prompting the user to input the sales figure, it will find the highest monthly sales amount and t..
How is management accounting information : How is management accounting information a means to an end?
Write a time-domain expression for the signal : A signal has the double-sided amplitude and phase spectra shown in Figure 2.34. Write a time-domain expression for the signal.
Requirements for a banking application : Consider the following data requirements for a banking application.
Which therapeutic approach do you think is best : Write a paragraph on how this diagnosis could be treated by each of the four major schools of psychotherapy - How might the Prochaska Model of Change assist.
Select and describe a specific healthcare operating unit : Select and describe a specific healthcare operating unit. Examples are an emergency department, a surgical service, a specific nursing unit, and a physician's office practice. Select a type of healthcare service you are familiar with.
Write a paper about different types of investment banks : Write a paper of no more than 1,050 words about different types of investment banks, including financial holding companies, full service investment banks, and boutique investment banks.
Implement a particle filter for a simulated boat driving : E28: Mobile Robotics - Fall 2015 - HOMEWORK 12. Your goal is to implement a particle filter for a simulated boat driving along a circular channel. Let x denote the boat's position in the interval [0, 1]. Since the channel is circular, going past x ..

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Identifies the cost of computer

identifies the cost of computer components to configure a computer system (including all peripheral devices where needed) for use in one of the following four situations:

  Input devices

Compare how the gestures data is generated and represented for interpretation in each of the following input devices. In your comparison, consider the data formats (radio waves, electrical signal, sound, etc.), device drivers, operating systems suppo..

  Cores on computer systems

Assignment : Cores on Computer Systems:  Differentiate between multiprocessor systems and many-core systems in terms of power efficiency, cost benefit analysis, instructions processing efficiency, and packaging form factors.

  Prepare an annual budget in an excel spreadsheet

Prepare working solutions in Excel that will manage the annual budget

  Write a research paper in relation to a software design

Research paper in relation to a Software Design related topic

  Describe the forest, domain, ou, and trust configuration

Describe the forest, domain, OU, and trust configuration for Bluesky. Include a chart or diagram of the current configuration. Currently Bluesky has a single domain and default OU structure.

  Construct a truth table for the boolean expression

Construct a truth table for the Boolean expressions ABC + A'B'C' ABC + AB'C' + A'B'C' A(BC' + B'C)

  Evaluate the cost of materials

Evaluate the cost of materials

  The marie simulator

Depending on how comfortable you are with using the MARIE simulator after reading

  What is the main advantage of using master pages

What is the main advantage of using master pages. Explain the purpose and advantage of using styles.

  Describe the three fundamental models of distributed systems

Explain the two approaches to packet delivery by the network layer in Distributed Systems. Describe the three fundamental models of Distributed Systems

  Distinguish between caching and buffering

Distinguish between caching and buffering The failure model defines the ways in which failure may occur in order to provide an understanding of the effects of failure. Give one type of failure with a brief description of the failure

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd