database-creation-STEPS

docx

School

University of Texas, Dallas *

*We aren’t endorsed by this school

Course

3311

Subject

Information Systems

Date

Apr 3, 2024

Type

docx

Pages

Uploaded by aamkh4n

 Download SQL Script called ap_ex_om_dbs.sql from eLearning. (Script will vary for each task) Note the directory where you have downloaded the file.  Open the MySQL workbench in your laptop.  You should see above screen.  Choose “Open SQL Script” From File Menu.

Choose the file you downloaded from eLearning. Choose SQL script you downloaded from eLearning.

Click on this to run

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

After successful run, you will see three new databases will be created (EX, AP and OM). If you don’t see it in SCHEMAS click on Refresh Button ( ) .

To Verify the creation of the database , do following if you want. Result Output Type as below in SQL editor. This should be always needed to run before running any SQL. This is selecting which database to use for querying. Type Use AP or database you want to work on and highlight and press Now, copy the below sql and run it again as below. You need to highlight the sql text and press copy this sql to SQL Editor and execute it by clicking SELECT current_user(), @@hostname, now(), (select count (*) from invoices ) invoices, (select count (*) from vendors) vendors, (select count (*) from terms ) terms, (select count (*) from vendor_contacts) vendor_contacts, (select count (*) from invoice_line_items) invoice_line_items, (select count (*) from general_ledger_accounts) general_ledger_accounts, (select count (*) from invoice_archive) invoice_archive from dual;

Do the same for other databases using sqls provided by instructors.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Repeat the same process for other database sql if you have After successful run, you will see three new databases will be created

database-creation-STEPS

Related Documents