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, 21.06.2019 16:20
Quincy would like to view the contents of a specific message in his inbox. a portion of his computer screen is shown. what should quincy do in order to complete this task? 1. click on the inbox in the navigation pane, and click on the specific message in the folder pane to display its contents. 2. click on the inbox in the outlook today window, and click on the specific message in the folder pane to display its contents. 3. double-click the message’s header in the outlook today window, and right-click on the specific message to display its contents. 4. double-click the mail option in the navigation pane, and right-click on the specific message to display its contents.
Answers: 1
question
Computers and Technology, 22.06.2019 10:30
Auniversity wants to install a client-server network. which feature do you think is important for them as they set up the network? sending email blocking multiple people to use the same file low security low set up cost limited access to files
Answers: 1
question
Computers and Technology, 23.06.2019 11:30
In cell h5 enter a formula that will calculate the percentage of attendees that went to the altamonte springs job fair in 2018.
Answers: 1
question
Computers and Technology, 23.06.2019 13:30
Spoons are designed to be used for: spring hammering. applying body filler. identifying high and low spots. sanding highly formed areas.
Answers: 3
You know the right answer?
You are a member of database design team for a retail banking system. The system maintains informati...
Questions
question
English, 10.03.2021 05:00
question
Mathematics, 10.03.2021 05:00
question
Geography, 10.03.2021 05:00
question
Mathematics, 10.03.2021 05:00
question
Mathematics, 10.03.2021 05:00
question
Mathematics, 10.03.2021 05:00
Questions on the website: 13722360