A startup Local Bank (Bank Lesotho) has decided to implement an online system to manage customers’ details, loans, inventory and sales of its different products. You have been requested to ensure that the following information is captured in their proposed database using SQL Server 2012: a). The Bank has outlets country wide including Maseru mall, Pioneer Mall, Sefika Mall etc. Each location is identified by its Location ID, address, Town/City contact number and business type can either be for corporate customers/private clients and normal banking customers. b) The bank has many employees at different positions where each employee has an employee number, location, first name, last name, job title (Teller, Manager, marketers etc.) address City/town contact number. c) The bank has customers who have account numbers located at any of the branches nationwide with the bank and the customers can either be a corporate/private client or ordinary customers. The system should provide running customer balances at the end of each month and also minimum, average and maximum values of the running balance for each customer. d). the main operation of the bank is to open accounts for customers, customers are given account numbers, they can save or withdraw money from their accounts and there are different types of account (Savings, current, call account etc.). e). After opening accounts with the bank, the customers can apply for loans or overdraft from the bank which is subject to approval or rejection depending on the credit worthiness of the individual customers. Loans have a monthly repayment amount, interest rates, loan period and a deadline for payment. f). Customers can either apply for debit or credit card with the bank to facilitate transactions. give the entity types and their relationships from this scenario and draw an ERD diagrams using Crowfoot notation. use appropriate mapping of EERDs types and appropriate mapping of regular/associative entity under normalization.
