How many accounts does each customer have at each branch

Example: Banking Database Senator Curry North Glenn 2. customer F( TFF) customer-name customer-street customer-city Adams Spring Pittsfield Brooks Brooklyn Rye Sand Hill Woodside Green Green Walnut Wann Hayes Main Harrison wa Conso Alma Amma Palo Alto Jones Main Jones Harrison Lindsay Park Pittsfield Smith North Rye Turner Putnam Stamford Williams Nassau Princeton Stamford 3. depositor ## customer-name account number Hayes A-102 Johnson A-101 Johnson A-201 Jones A-217 Lindsay A-222 Smith A-215 Turner A-305 Johnson 1. branch SA branch-name branch-city assets Brighton Brooklyn 7100000 Downtown Brooklyn 9000000 Mianus Horseneck 400000 North Town Rye 3700000 Perryridge Horseneck 1700000 Pownal Bennington 300000 Redwood Palo Alto 2100000 Round Hill Horseneck 8000000 4. borrower # customer-name loan-number Adams L-16 Curry L-93 Hayes L-15 Jackson L-14 Jones L-17 Smith L-11 Smith L-23 Williams L-17 5. account ## account-number branch-name balance A-101 Downtown 500 A-102 Perryridge 400 A-201 Brighton 900 A-215 Mianus 700 A-217 Brighton A-222 Redwood 700 A-305 Round Hill 350 6. loan loan-number branch-name amount L-11 Round Hill 900 L-14 Downtown 1500 L-15 Perryridge 1500 L-16 Perryridge 1300 L-17 Downtown 1000 L-23 Redwood 2000 L-93 Mianus 500 Tel-Pang Yang, Information Management, NDHU Unit 6 Database Design and the E-R Model 6-20 Example: Banking Database Senator Curry North Glenn 2. customer F( TFF) customer-name customer-street customer-city Adams Spring Pittsfield Brooks Brooklyn Rye Sand Hill Woodside Green Green Walnut Wann Hayes Main Harrison wa Conso Alma Amma Palo Alto Jones Main Jones Harrison Lindsay Park Pittsfield Smith North Rye Turner Putnam Stamford Williams Nassau Princeton Stamford 3. depositor ## customer-name account number Hayes A-102 Johnson A-101 Johnson A-201 Jones A-217 Lindsay A-222 Smith A-215 Turner A-305 Johnson 1. branch SA branch-name branch-city assets Brighton Brooklyn 7100000 Downtown Brooklyn 9000000 Mianus Horseneck 400000 North Town Rye 3700000 Perryridge Horseneck 1700000 Pownal Bennington 300000 Redwood Palo Alto 2100000 Round Hill Horseneck 8000000 4. borrower # customer-name loan-number Adams L-16 Curry L-93 Hayes L-15 Jackson L-14 Jones L-17 Smith L-11 Smith L-23 Williams L-17 5. account ## account-number branch-name balance A-101 Downtown 500 A-102 Perryridge 400 A-201 Brighton 900 A-215 Mianus 700 A-217 Brighton A-222 Redwood 700 A-305 Round Hill 350 6. loan loan-number branch-name amount L-11 Round Hill 900 L-14 Downtown 1500 L-15 Perryridge 1500 L-16 Perryridge 1300 L-17 Downtown 1000 L-23 Redwood 2000 L-93 Mianus 500 Tel-Pang Yang, Information Management, NDHU Unit 6 Database Design and the E-R Model 6-20