Question
You are assigned to design a database for Bank of America. In this system, we have different branches, located at different states and addresses, providing
You are assigned to design a database for Bank of America. In this system, we have different branches, located at different states and addresses, providing service to many customers. The service provided includes various accounts (checking, saving, etc.), various types of credit cards, and various types of loans. Each customer can get service from different branches, for example a customer may have credit cards issued by different branches or have received loans from different branches. 1. Think about this system and develop an entity relationship diagram (ERD) (entities, their attributes, and relationships) for this problem. 2. Define the corresponding tables in Access. Make sure to define a primary key for each entity. Make sure to define foreign keys if needed. Creates the relationships. 3. Make up data for each one of the tables (at least 4 records for each table). 4. Create a form for entering data of customers. 5. Create a form for entering data of branches. Use Combo box for specifying the state in which the branches are located. 6. Create a query to get the name of a branch from the user and then list the information of the customers of that branch. 7. Create a report that shows the results of the query you build in previous question. 8. Create a query that shows the name of the customer and the list of branches they have accounts in and the type of those accounts. 9. Create a query that shows the name of the customer and the list of branches they have gotten loan from and the type and amount of those accounts. 10. Create a query that asks you to enter the name of a customer and then returns the list of credit cards the customer has and the branches that processed the requests, and also the balance on each credit card.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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