Assignment #8

SQL Loads via an Access Export & SQL Scripts

for the Access Export:

- Use the Artists.mdb /External Data/ Export/ More/ODBC Database/ARTIST for the table name in the Export window/ in the "Select Data Source" choose the "Machine Data Source" of SQL and then select "OK". At the SQL Server Login window, enter your Login ID and Password credentials. Check your effort by going into SQL and verifying that the ARTIST able now exists in your SQL db.

Submit: the print out of the SQL database containing just the one table.

DROP the table when you have completed the assignment. (optional)

for the SQL Scripts:

LOAD your SQL DB from the CLASSDATASCORCER SQL Database via scripts

Read

See our Environment folder Notes Start Query Analyzer ..doc

Load

Run the 61A and 61B scripts to first create, and then the 63 script to populate, your database from the CLASSDATASCORCER SQL database. The eight tables are:

JUDGE

JUDGE_COMPETITION

COMPETITION

COMPETITION_COMPETITOR

COMPETITOR

BRIEF

TEAM

SCHOOL

Notes:

DROP - If you need to start over, use script 60. Then run scripts 61A, 61B and 63 again.

If at home, you need to have some version of SQL on your home machine such as MySQL and VPN so you can access the SJU database server.

See 1^st Time User? choice when you select the SQL Analyzer or Oracle from the list of programs (Start).

KEEP these tables after the creates and inserts (populating). You will be using them in order to write and run your SQL queries for Assignment #9.

Submit: Print out and submit the first page of the eight SQL tables as well as your login window.