In a bank, what information would you store in the customer table? What columns would you include for account number, customer ID, account type, and demographic information?

A typical bank customer table would include a unique customer identifier (customer_id), personal details such as first_name, last_name, date_of_birth, and gender, contact information like phone_number and email, and address fields (street, city, state, zip). For account linkage, you would store account_number, account_type (checking, savings, credit), balance, status, and foreign keys to the customer_id. Demographic data might include occupation, income bracket, and nationality. Audit columns such as created_at, updated_at, and created_by help track changes. Normalization would separate addresses and contact methods into their own tables if multiple per customer, but for simplicity a single table can hold the most common fields.