This question's due date has already passed. You may post a tutorial, but there's no guarantee that the original asker will purchase the tutorial. But other people might!

Question

$10.00 SQL syntax help

Asked by :
mityguy23
mityguy23 Not confirmed
Rating :No Rating
Questions Asked: 49
Tutorials Posted: 0
 
 
Q:
1) Create a new Access Database 2) Import the data from the sample1_data.xml file provided. Create the structures and the data 3) Edit the customer table and add a customer_id column. Set this as a primary key and then assign a customer_id to each entry in the table 4) Edit the fulladdress table and add a customer_id column to it. Fill each row with a valid customer_id from step #3 5) Setup the relationship between customer and full address 6) Create a new table that contains all the columns in the customer and the fulladdress table (note: only need one customer_id field in this new table) 7)Write a query to pull together the customers with their proper full address and insert it into the table in created in step 6. In your Microsoft Word write up indicate the SQL Syntax statements that you would use for steps 3,4,6,7. When completing the work in Access you may use the design interface, however when you submit the word document I am looking for you to explain the SQL DDL and the DML you would use if you didn't have the GUI interface.