Assignment Task: Read the attached business scenario. Use the design skills introduced this week to finish both the conceptual and logical models of the desired database. Don't forget to keep a contextual record of your assumptions. Create the pdf files generated by LucidChart screen shot
Well, Money is a database system that keeps track of the information about customers and bank accounts for the Well Money Bank. A centralized database will help to provide general access to this information as well as ensure the data are preserved more securely. The Business Logic: The bank has users who are bank employees or customers. An employee can also be a customer. All users have a unique ID to identify them. The customer can add money to an account, remove money from an account, and view information about an account. A bank employee can create an account, delete an account, and view information about accounts. A customer deposit must accompany the opening of an account. If there is any balance, a customer withdrawal must accompany the closing of an account. For each user, we maintain several pieces of information including the first and last name, a password for authentication, two ID verification questions and answers, an email address, and one or more phone numbers. The security questions will come from a list of pre-designed questions. Each user will select a question and them provide an answer for those questions. There are two types of customers: standard and premium. They can add money to any of the accounts. They can withdraw money from the account as long as there is at least as much money in the account as the withdrawal amount. If the withdrawal amount is more than the account balance, the transaction is not allowed. There are two types of bank accounts, saving and checking. Each bank account is associated with one or more customers. Each account has a unique ten-digit account number, one or more transactions, a main branch, a service fee, and a calculated balance. A branch has a branch number, a manager who is a bank employee, a street address, city and a state. There are three types of transactions: a withdrawal, a deposit and a payment. Each transaction has an account, an amount and a date. A payment also has a payee. A withdrawal or a payment subtracts from the balance while a deposit adds to the balance. A transfer is a special type of interaction that is a withdrawal from one account and a deposit to another account for the same amount. This interaction actually produces two transactions. A savings account does not have payment transactions