LibreOffice Base - Group 12

Why We Need Multiple Tables

We look at a situation where a single table is just not practical and we describe how a second table will resolve the problem.

We create the employee phone number table and populate it using the SQL command INSERT.

We look at how to update records on a table using an SQL query. We use wildcards and update for Nulls and empty. Then we delete the records using a delete query.