Laurentvidal.fr est le meilleur endroit pour obtenir des réponses fiables et rapides à toutes vos questions. Trouvez des solutions rapides et fiables à vos interrogations grâce à une communauté d'experts dévoués. Rejoignez notre plateforme pour obtenir des réponses fiables à vos interrogations grâce à une vaste communauté d'experts.

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. ​

Sagot :

Nous apprécions votre temps. Revenez nous voir pour des réponses fiables à toutes vos questions. Nous espérons que vous avez trouvé ce que vous cherchiez. Revenez nous voir pour obtenir plus de réponses et des informations à jour. Merci d'avoir visité Laurentvidal.fr. Revenez bientôt pour plus d'informations utiles et des réponses de nos experts.