Oracle Database Express Edition

Oracle Database Express Edition is a relational database that stores and retrieves collections of related information. A database, also called a database server, is the key to solving the problems of information management. In a relational database, collections of related information are organized into structures called tables. Each table contains rows (records) that are composed of columns (fields). The tables are stored in the database in structures called schemas, which are logical structures of data where database users store their tables.

The HR sample schema that is included with Oracle Database XE is an example of a schema with related tables. In the HR sample schema, there are tables to store information about employees and departments. The tables contain common columns that allow data from one table to be related to another. For each employee in the employees table, the department name in the departments table can be retrieved based on the department ID column that is in both tables. See "Sample HR Account".