Using SQL Developer Interface
Creating and Using Tables
Creating and Using Database Objects 3-3
Creating a Table
To implement the employee evaluation process, you will need to establish three tables,
performance_parts
,
evaluations
, and
scores
.
The
performance_parts
table lists the categories of performance
measurements, and the relative weight for each item.
The
evaluations
table will contain the employee's information, evaluation date,
and the job, manager and department at the time of evaluation. You must preserve
this information in this table because at any point in the future, the employee may
change job designation, manager, or department.
The
scores
table contains the scores assigned to each performance category for
each evaluation.
To create a table using SQL Developer interface:
You will create the
performance_parts
table using the SQL Developer graphical
interface.
1.
In the Connections navigation hierarchy, click the plus sign (+) next to
hr_conn
to
expand the list of schema objects.
2.
Right-click Tables.
3.
Select New Table.
4.
In the Create Table window, enter the following information:
For Schema, select
HR
.
For Name, enter
PERFORMANCE_PARTS
.
