Question: reate an empty database. Call it Personnel.db reate a table called people with the following fields. Make the ID the primary key. Create a table
reate an empty database. Call it "Personnel.db" reate a table called "people" with the following fields. Make the ID the primary key. Create a table called "addresses" with the following fields. Make the ID the primary key, and have the person number be a foreign key into the person table. Insert three person records into the person table, using whatever information you like. Insert one more person using SQL. Look up the syntax for "INSERT into..." Insert three address records, assigning 2 addresses to person 1 and 1 address to person 2. Insert one more address using SQL. Query your database for all people and addresses using SQL with a "LEFT JOIN." Query your database for all people (along with their addresses) whose last name starts with " S " (or any letter you know is in your table) and addresses using SQL with a "LEFT JOIN." Create three person records in Excel and auto-import them into your person table
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
