Intern — Middle
Inserting test records into tables
livecode
Task condition
Formulate SQL queries to populate test data:
- Add several records (about 3-5) with name fields to the customers table.
- Add several records to the purchases table, with:
- customer_id referencing an existing record from customers;
- purchase_date set to different dates and times.
Requirements:
- Maintain referential integrity between customers and purchases.
- One of the customers should have more than one order.