Company Database example for MS-SQL Server
==========================================

To create company database,
  For Microsoft SQL Server 2000 database,
    * Execute the SQL script setupCompany.sql in Query Analyzer tool
      This will generate all table structures and load all tuples

  For Oracle database,
    * Execute the SQL script genCompany.sql in Query Analyzer tool
      This will generate all table structures (with no tuples)
  
    * To load the tables, copy the "data" directory and its files.
      Edit loadtables.sql script and change the path 
       on the FROM clause lines on all six instances
       with the correct path of these modified files 
      Then execute this modified script file in Query Analyzer tool.

  - To test the database with static queries,
    execute any of the queris in "queries" directory.

  - To remove all company tables, execute the SQL script DropCompany.sql

--Prabu