Reference no: EM13926739
The Goal: Get experience in programming using databases. What you need to know for this project: Designing relational databases, SQL, stored procedures.
The project is based on the material of Class/Labs. The Task: Implement a Banking Program of a bank providing account/loan services to customers by several branches.
Here is the minimum functionality of the application:
1. Define/update a customer having id, name, address, date of birth, sex.
2. Define/update branch having branch name, address.
3. Define/update an employee having id, name, branch, position, salary, enter date. An employee has customers assigned to them.
4. Define/update account having account number, balance, history of operations on it. Each account pertains to a unique branch. History of operations shows operation (deposit/withdraw), amount deposited/withdrawn, balance before and after operation, date, employee responsible for it.
5. Define/update loan having loan number, amount, history of operations on it. Each loan pertains to a unique branch. History of operations shows operation (borrow/return payment), amount of money borrowed/returned, resulting loan amount before and after operation, date, responsible for it employee.
6. List customers together with their number of accounts, total account balances, number of loans, and total loan amounts, living in a given city, having given sex and age, and having accounts and/or loans in a given branch.
7. List employees together with the number of assigned to them customers and salary who work in a given branch and who entered it not before a given date.
8. List branches together with the number of employees and assigned to them customers, total loan amount, total account balance for branches residing in the given city.
9. List customers who made account and loan operations in the given time period 10. List employees and the number of served by each of them customers in the given time period
Methodology: You should write queries/stored procedures for each one of the above options. What to hand in: You should hand in a report which contains the design of your database as an E-R diagram, the tables in the database, all the stored procedures, and all the data in your tables. References to the sources you used (textbooks, manuals, web-sites, etc.) shall be also shown. Give an explanation for each stored procedure.
|
Business requirements driving the need for the system
: The presentation must include the following: A full description of the new system, a description of its components, and the benefit it will provide to Riordan A discussion of the business requirements driving the need for the system A discussion o..
|
|
Css to create a navigation bar
: What suggestions do you have for Karina as she plans to update the website using CSS? What advantages are there to using CSS to create a navigation bar for your website? List two advantages.
|
|
Explain what they will change in dbms technology
: Explain how they work and what advantages and disadvantages they bring.
|
|
Functions and role of law in business and society
: Write a 700- to 1,050-word paper in which you define the functions and role of law in business and society. Discuss the functions and role of law in your past or present job or industry. Properly cite at least two references from your reading.
|
|
Update account having account number
: Define/update account having account number, balance, history of operations on it. Each account pertains to a unique branch. History of operations shows operation (deposit/withdraw), amount deposited/withdrawn, balance before and after operation, ..
|
|
What is quantitative reasoning
: Creating my grocery list and buying groceries - This task requires A LOT of quantitative reasoning. You have to estimate the amount of each item that you need for a given time. You have to make sure the total of all items fit into your budget.
|
|
Basic services provided by a parole agency
: 1. What are the three basic services provided by a parole agency?2. How does the independent model of parole administration differ from the consolidated model?
|
|
The brazilian federal data processing service
: Use the Internet to research the architectures that other government organizations and intelligence agencies use for email privacy, if any. Examine the proposed business ethical problem that the Brazilian Federal Data Processing Service is present..
|
|
Describe conditional release
: Directions: Write a response that is at least one page in length for each of the following questions. 1. Describe conditional release and explain the concept of good time.
|