Question

Object Definition Language problem

Do this design in ODL, including keys as appropriate:

Design a database for a bank, including information about customers and their accounts. Information about a customer includes their name, address, phone, and Social Security number. Accounts have numbers, types (e.g., savings, checking) and balances. Also record the customer(s) who own an account.

Answer 1

Here is the database for a bank...

Keys are :

1.Social security number = primary key

Because, every customer will be having a unique SSN.

2. number ( account number) = primary key

Because, every customer's bank account number will be unique from each others.