Requirements for a banking application

Assignment Help Basic Computer Science
Reference no: EM131108696

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

Questions Cloud

Explain affect the capital budgeting decisions : Briefly explain how the following items affect the capital budgeting decisions of multinational companies: (a) Exchange rate risk; (b) Political risk; (c) Tax law differences; (d) Transfer pricing; and (e) A strategic, rather than a strict, financial..
What is the biological equilibrium of the fishery : Suppose that the biological mechanics for a fishery are given by the equation F(X) = aX - bX^2 , where X is the biomass of the fishery, and a and b are biological parameters assumed to be constant and positive. What is X MSY , the maximum sustainable..
In what year did deng make this tour : Deng Xiaoping made a famous tour of southern China, ending the controversy on how fast China must grow economically. In what year did Deng make this tour
Describe how each of the following behavioral approaches : Describe how each of the following behavioral approaches can be used to deal with project risk: (a) Scenario analysis and (b) Simulation.
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..
Research and development tax credits : Research and development (R&D) tax credits:
Define risk in terms of the cash flows from a capital budget : Define risk in terms of the cash flows from a capital budgeting project. How can determination of the breakeven cash inflow be used to gauge project risk?
Summarize challenges and existing international fora : "The main objective of this paper is to explore and describe the discursive politics of surveillance, the constitutional norm that aims to defend citizens from government power via unjustified infringements, the function identity can have as a dec..
Given in the linear system : Given in the linear system

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