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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!