Project #76994 - Database Systems

Scenario A bank has several branches in the UK. It needs a database to store information about its local branches. Each branch is identified by a unique branch code, an address (street, city, post code), and a phone number. The customer accounts at each branch are also recorded. Each customer account is identified by a unique account number, an account type (current or savings), and a balance. Each account has an interest rate. An account is also associated with exactly one branch. The date when the account is opened is recorded as well. An account must be classified as either a current or a savings account. A current account also has a limit of free overdraft. The free overdraft limit is set at the opening of an account. Data about its customers and employees is also recorded. Both customers and employees have an associated National Insurance number (a tax payer’s unique identification number), address (street, city, post code) and phone numbers (home number and mobile numbers). An employee can not be a customer at the same branch where he/she works. An employee has a title (Head, Manager, Project Leader, Accountant, Cashier) and a salary, and works for exactly one branch. The date that the employee joined the bank is also recorded. Every employee has a supervisor at the same branch, except the head of the branch. The head of the branch is the only person who is not supervised by anyone at the same branch. A customer may have multiple accounts with the bank, and an account may be owned by multiple customers as in a joint account. The database: This database is designed with the following relations, where the primary keys are underlined and foreign keys are in italic:

Branch(bID, street, city, p_code, bPhone)

Account(accNum, accType, balance, bID, inRate, limitOfFreeOD, openDate)

Employee(empID, street, city, postCode, title, firstName, surName, empHomePhone, empMobile1, empMobile2, supervisorID, position, salary, niNum, bID, joinDate)

Customer(custID, street, city, postCode, title, firstName, surName, custHomePhone, custMobile1, custMobile2, niNum)

CustomerAccount(custID, accNum) 

Subject Computer
Due By (Pacific Time) 07/27/2015 06:00 am
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy