You are building a database for a shoe retailer. Create the database tables needed to store information about the following attributes: customer name, customer address, customer telephone, names of customers children, salesperson name, salesperson address, sales department (e-g, used ears, new cars, or leases), sales department phone, department in which a salesperson works (assume that each salesperson works in only one department), shoe model, shoe color, shoe sales price, sales date, shoes purchased by each customer.

Clearly indicate all primary and foreign keys in your tables. You may need to circle some primary keys

The answer should be in third normal form (3NF)