Seacrest Bedding is changing from a file-oriented system to a relational database system. Identify and design at least three tables that would be needed to capture data for a sales transaction

Each table should include a primary key, three non-key attributes, and foreign keys as necessary. Make up data values for two records within each table.
What will be an ideal response?

Customer table; ID (primary key), name, street address, city, state, zip code, phone number, credit limit, salesperson ID (foreign key)
Salesperson table; ID (primary key), name, street address, city, state, zip code, phone number, hire date, commission rate, base salary
Sales table; sales invoice number (primary key), date, amount, sales tax, shipping charge, shipping method, customer ID (foreign key), salesperson ID (foreign key)
Inventory table; item ID (primary key), description, size, color, warehouse location, list price, quantity on hand
Sales-Inventory table; sales invoice number and item ID (concatenated primary key), quantity sold, sales price, extended amount

Students should also make up data values for two separate records for each table.