Question
Use the following requirements for a banking enterprise ER diagram: 1. The bank is organized into branches. Each branch is located in a particular city
Use the following requirements for a banking enterprise ER diagram:
1. The bank is organized into branches. Each branch is located in a particular city and is identified by a unique name. The bank monitors the assets of each branch.
2. Bank customers are identified by their social security numbers. The bank stores each customer's name, and the street and city where the customer lives. Customers may have accounts, and can take out loans. A customer may be associated with a particular banker, who may act as a loan officer or personal banker for that customer.
3. Bank employees are also identified by their social security numbers. The bank administration stores the name and telephone number of each employee, the name of the employee's dependents, and the social security number of the employee's manager. The bank also keeps track of the employee's start date and , thus, length of employment.
4. The bank offers two types of accounts - savings and checking accounts. Account can be held by more than one customer, and a customer can have more than one account. Each account is assigned a unique account number. The bank maintains a record of each account's balance, and the most recent date on which each customer holding the account accessed the account. In addition, each savings account has an interest rate, and overdrafts are recorded for each checking account.
5. A loan originates at a particular branch and can be held by one or more customers. A loan is identified by a unique loan number. For each loan, the bank keeps track of the loan amount and the loan payments. Although a loan payment number does not uniquely identify a particular payment among those for all the bank's loans, a payment number does identify a particular payment for a specific loan. The date and amount are recorded for each payment.
Please specify key attributes of each entity and structural constrains on each relationship. Not any unspecified requirements, and make appropriate assumptions so as to make the specification complete.
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