2 Day Developer > Overview of Development > Overview of Developing Appl... > Sample HR Account
Sample HR Account |
Previous |
Next |
Oracle Database XE provides the HR
sample user account for use with the examples in this guide. This HR
user account is also referred to as the HR
schema. A schema is a logical container for the database objects that the user creates.
The HR sample account is set up to be a simple Human Resources division for tracking information on the employees and the facilities. In the HR
schema, each employee has an identification number, e-mail address, job identification code, salary, and manager. Some employees earn commissions in addition to their salary. Each job has an identification code that associates it with a job title, a minimum salary, and a maximum salary for the job.
Each employee is assigned to a department, and each department is identified either by a unique department number or a short name. Each department is associated with one location, and each location has a full address that includes the street name, postal code, city, state or province, and the country code.
For information about viewing the database objects in the HR
schema, including the structure of the HR
tables, see "Managing Database Objects With Object Browser".