Question
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
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 1st 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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started