Draw an ER Diagram for the following Business Situation: A bank has a phone call system in which the costumer can call and talk to one employee and inquire of their existing account. Costumer can have two type of accounts, checking account or savings account, client can own both type of accounts. One of the assumptions which is being made with this project is all interactions will be over the phone. Clients would call in to the business’ account representatives who will have to search the client in internal database. Once the client has been searched in the database, representative will go forth and verify the client via personal information displayed through the database. Personal Information would include, full name, address, last 4 of social security, and account number. The project will assume that the business is domestic, and all clients are in the United States. Once the client is verified, representative can discuss business related queries, including transactional questions which will also be stored in the database. If the client cannot be verified, account representative would not discuss or disclose any account related questions. Situation would be Client calls into the Bank Employee and inquires about an account via an account number which the employee uses to look up the account. once the account is pulled up, the employee can view all the transaction which have been made on via Transaction ID. Client's who has Checking Account will also be able to take out a loan and make payments on the loan. Client would also have savings and checking account in which they can withdraw or deposit the money and it will show up in Transaction ID To make it easier Entities and subtypes are listed below: - Costumer - Employee - Account (subtype: checking (loan) and savings) - Transaction ID (subtype: Deposit, loan payment, withdraw)
Draw an ER Diagram for the following Business Situation:
A bank has a phone call system in which the costumer can call and talk to one employee and inquire of their existing account. Costumer can have two type of accounts, checking account or savings account, client can own both type of accounts. One of the assumptions which is being made with this project is all interactions will be over the phone. Clients would call in to the business’ account representatives who will have to search the client in internal
Situation would be Client calls into the Bank Employee and inquires about an account via an account number which the employee uses to look up the account. once the account is pulled up, the employee can view all the transaction which have been made on via Transaction ID. Client's who has Checking Account will also be able to take out a loan and make payments on the loan. Client would also have savings and checking account in which they can withdraw or deposit the money and it will show up in Transaction ID
To make it easier Entities and subtypes are listed below:
- Costumer
- Employee
- Account (subtype: checking (loan) and savings)
- Transaction ID (subtype: Deposit, loan payment, withdraw)
* Please show the relationship which is assumed by the answerer*
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images