subject

You are a member of database design team for a retail banking system. The system maintains information related to each customer. The customer information includes his/her first name, last name, gender, residential address, mailing address, and social security number. Each customer is given a unique customer number. A customer should have at least one account and can have more than one accounts. Each account is identified by an account number. The system allows two types of transactions on an account. They are withdrawal transactions and deposit transactions. A withdrawal transaction reduces the account balance by the transaction amount. A deposit transaction increases the account balance by the transaction amount. The system does not allow opening a new account without the initial deposit and therefore an account has at least one deposit transaction. The system has a requirement to record all the withdrawals and deposits. Required:
Based on the description above, draw the first level data model diagram that identifies all the entities/classes, attributes/properties for each class/entity, and the relationships between the classes/entities.

ansver
Answers: 1

Another question on Computers and Technology

question
Computers and Technology, 23.06.2019 18:30
This program should be a short piece of code that prints all of the positive integers from 1 to 100 as described more fully below. the program may contain multiple methods, and if using an oo language, should be contained within a single class or object. the program should be designed so that it begins execution when invoked through whichever mechanism is most common for the implementation language. â–ş print out all positive integers from 1 to 100, inclusive and in order. â–ş print messages to standard output, matching the sample output below. â–ş in the output, state whether the each integer is 'odd' or 'even' in the output. â–ş if the number is divisible by three, instead of stating that the number is odd or even, state that the number is 'divisible by three'. â–ş if the number is divisible by both two and three, instead of saying that the number is odd, even or divisible by three; state that the number is 'divisible by two and three'. â–ş design the logic of the loop to be as efficient as possible, using the minimal number of operations to perform the required logic. sample output the number '1' is odd. the number '2' is even. the number '3' is divisible by three. the number '6' is divisible by two and three.
Answers: 1
question
Computers and Technology, 24.06.2019 07:00
Guys do you know sh27 cause he hacked me : ( pidgegunderson my old user
Answers: 2
question
Computers and Technology, 24.06.2019 07:00
Why would a business likely use a java applet - to back up their data files for the business - to create a program that a customer can launch in their web browser - to create music on a powerpoint presentation - to organize files on their company directory
Answers: 3
question
Computers and Technology, 24.06.2019 15:00
Universal windows platform is designed for which windows 10 version?
Answers: 1
You know the right answer?
You are a member of database design team for a retail banking system. The system maintains informati...
Questions
question
Mathematics, 27.04.2021 16:30
question
Business, 27.04.2021 16:30
question
Mathematics, 27.04.2021 16:30
question
Mathematics, 27.04.2021 16:30
Questions on the website: 13722360