Use Oracle through the command line

• To login:
  • Log into csci.viu.ca;
  • Log into Oracle by entering command "sqlplus username@XE", where username should be your csci account username, and password is your student number;
  • If you want to use up/down key to access history of commands in sqlplus, then log in use the command "rlwrap sqlplus username@XE".
  • You can change your Oracle account password by entering command "password" once you logged into Oracle.
• There are a set of the tables created under HR schema. To find out the names of the tables owned by HR, you can type in the following query:

      select table_name
      from all_tables
      where owner = 'HR';
      

• For each table that you can access, if you want to see the schema of the table, type in the query "describe table_name". For example,

      describe HR.employees
      

• To drop the prefix of "HR" before the table name, change your session using command "alter session set current_schema = hr;".
• Get familiar with the table schema under the HR schema. We'll use these data in the following labs.
• There are a list of commonly used Oracle command line commands that can help you modify the settings of the Oracle text interface.

Your tasks:

There are following relations in database HR:

REGIONS
LOCATIONS
DEPARTMENTS
JOBS
EMPLOYEES
JOB_HISTORY
COUNTRIES

According to the information of these relations (which can be obtained by using the command "describe"), draw the ER diagram of this database design.

You don't need to submit your lab solution, but the good understanding of the database schema will help you write queries in the later labs, and the practice of translating database schema back to ER diagram will help you better understand the database design.

Try to access Oracle through its web interface by following instructions here.