Question
$10.00 SQL syntax help
- From Computer-Science: Programming-Methods
- Closed, but you can still post tutorials
- Due on Sep. 08, 2010
- Asked on Sep 07, 2010 at 7:15:22PM
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.