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 11:00
What are the possible consequences of computer hacking? what is computer piracy? describe some examples. what are the effects of computer piracy? what are the possible consequences of computer piracy? what is intentional virus setting? describe some examples. what are the effects of intentional virus setting? what are the possible consequences of intentional virus setting? what is invasion of privacy? describe some examples. what are the effects of invasion of privacy? what are the possible consequences of invasion of privacy? what is an acceptable use policy and what is the purpose of the acceptable use policy what is intellectual property and how can you use it?
Answers: 1
question
Computers and Technology, 23.06.2019 16:30
What is one reason why indoor air pollution has become an increasing problem.
Answers: 1
question
Computers and Technology, 25.06.2019 05:30
Radar devices are used by law enforcement to be sure that individuals are driving safely. they tell the officer how fast the vehicle is traveling at that specific moment in time. the radar device determines the vehicle's a. instantaneous speed. b. acceleration. c. maximum velocity. d. average speed.
Answers: 1
question
Computers and Technology, 25.06.2019 08:00
Astrategy for speeding up hard drive performance is
Answers: 2
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, 05.03.2021 02:30
question
Mathematics, 05.03.2021 02:30
question
Mathematics, 05.03.2021 02:30
question
English, 05.03.2021 02:30
question
Mathematics, 05.03.2021 02:30
Questions on the website: 13722359