Working from the bottom up Convert the following to a conceptual model. Branch N
ID: 3715224 • Letter: W
Question
Working from the bottom up
Convert the following to a conceptual model.
Branch Name
Cust. #
Account #
Trans. #
Trans. Date
Cust. Name
Trans. Amount
Account Type
Branch Phone
Customer Phone
Central
10010
000-001
3001
02/01/93
Jones, Sam
100.00
Checking
555-0100
555-0105
Central
10010
000-002
3055
02/01/93
Jones, Sam
25.00
Savings
555-0100
555-0105
Central
10010
000-021
3056
02/01/93
Jones, Sam
-52.50
Checking
555-0100
555-0105
Central
10010
000-033
3057
02/02/93
Jones, Sam
1500.00
CD
555-0100
555-0105
Central
10010
000-003
3058
02/02/93
Jones, Sam
100.00
Safe Deposit
555-0100
555-0105
Eastside
10020
000-009
3006
02/02/93
Abrams, Max
2599.00
Checking
555-0109
555-2204
Westlake
10020
000-009
3007
02/02/93
Abrams, Max
-25.00
Checking
555-4232
555-2204
Eastside
10020
000-009
3008
02/03/93
Abrams, Max
-10.00
Checking
555-0109
555-2204
Central
10030
000-006
3012
02/03/93
Cohen, Esther
198.00
Checking
555-0100
555-0039
Central
10040
000-010
3010
02/03/93
Khan, Satya
-824.00
Savings
555-0100
555-1001
Central
10040
000-010
3011
02/03/93
Khan, Satya
-115.00
Savings
555-0100
555-1001
Westlake
10010
000-004
3081
02/03/93
Jones, Sam
190.25
Loan
555-4232
555-0105
Westlake
10050
000-018
3013
02/03/93
Brown, Judy
198.00
Checking
555-4232
555-9900
Central
10050
000-018
3014
02/03/93
Brown, Judy
-165.99
Checking
555-0100
555-9900
Westlake
10050
000-005
3015
02/03/93
Brown, Judy
25.00
Loan
555-4232
555-9900
Eastside
10060
000-012
3044
02/04/93
Wales, Minnie
-40.99
Checking
555-0109
555-0033
Eastside
10070
000-027
3017
02/04/93
Smith, Stan
-886.00
Savings
555-0109
555-1250
Westlake
10070
000-027
3018
02/04/93
Smith, Stan
100.00
Savings
555-4232
555-1250
Branch Name
Cust. #
Account #
Trans. #
Trans. Date
Cust. Name
Trans. Amount
Account Type
Branch Phone
Customer Phone
Central
10010
000-001
3001
02/01/93
Jones, Sam
100.00
Checking
555-0100
555-0105
Central
10010
000-002
3055
02/01/93
Jones, Sam
25.00
Savings
555-0100
555-0105
Central
10010
000-021
3056
02/01/93
Jones, Sam
-52.50
Checking
555-0100
555-0105
Central
10010
000-033
3057
02/02/93
Jones, Sam
1500.00
CD
555-0100
555-0105
Central
10010
000-003
3058
02/02/93
Jones, Sam
100.00
Safe Deposit
555-0100
555-0105
Eastside
10020
000-009
3006
02/02/93
Abrams, Max
2599.00
Checking
555-0109
555-2204
Westlake
10020
000-009
3007
02/02/93
Abrams, Max
-25.00
Checking
555-4232
555-2204
Eastside
10020
000-009
3008
02/03/93
Abrams, Max
-10.00
Checking
555-0109
555-2204
Central
10030
000-006
3012
02/03/93
Cohen, Esther
198.00
Checking
555-0100
555-0039
Central
10040
000-010
3010
02/03/93
Khan, Satya
-824.00
Savings
555-0100
555-1001
Central
10040
000-010
3011
02/03/93
Khan, Satya
-115.00
Savings
555-0100
555-1001
Westlake
10010
000-004
3081
02/03/93
Jones, Sam
190.25
Loan
555-4232
555-0105
Westlake
10050
000-018
3013
02/03/93
Brown, Judy
198.00
Checking
555-4232
555-9900
Central
10050
000-018
3014
02/03/93
Brown, Judy
-165.99
Checking
555-0100
555-9900
Westlake
10050
000-005
3015
02/03/93
Brown, Judy
25.00
Loan
555-4232
555-9900
Eastside
10060
000-012
3044
02/04/93
Wales, Minnie
-40.99
Checking
555-0109
555-0033
Eastside
10070
000-027
3017
02/04/93
Smith, Stan
-886.00
Savings
555-0109
555-1250
Westlake
10070
000-027
3018
02/04/93
Smith, Stan
100.00
Savings
555-4232
555-1250
Explanation / Answer
The Conceptual Model is given below:-
CUSTOMER_DETAILS - Stores all the Attributes related to a Customer Holding an Account
BRANCH_DETAILS - Stores Branch Name along with Branch Phone No.
TRANSACTION_DETAILS - Records all the Transactions done by a Customer
Please let me know in case of any clarifications required. Thanks!
Cust. # Cust. Name Account # Account Type Customer Phone Branch NameRelated Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.