Oracle 9i Create data table

Two data tables to create
1. Postgraduate Information table
Table name: Scott.student.
The table structure is shown in table 7.6.

3. Relationship of two data tables
The Master code "director_id" of the Tutor Information table (scott.director) is the outer code of the Postgraduate Information table (scott.student). In other words, when the "director_id" field of the Mentor Information table changes, the field "director_id" of the Postgraduate information table will automatically change as well.
Steps to create
1. Steps to create a Mentor information table
(1) The interface shown in Figure 7.2.
(2) The General Information tab of the Create table as shown in Figure 7.3 appears.

(3) Switch to the "Constraints" tab of the Create table as shown in Figure 7.4.

There are 5 options in the Type cell Drop-down list box, as shown in table 7.8.

(4) Switch to the "Cluster columns" tab of the Create table as shown in Figure 7.5.
(5) switch to the "Partition" tab of the Create table as shown in Figure 7.6.

(6) Switch to the Save tab of the Create table as shown in Figure 7.7.
(7) Switch to the Save tab of the Create table as shown in Figure 7.8.

(8) Switch to the "Constraint storage" tab of the Create table as shown in Figure 7.9.
(9) The interface appears as shown in Figure 7.10.

(10) In Enterprise Manager, you can view the data tables that you create, as shown in Figure 7.11.

(11) The SQL code for the above steps to create the Scott.director datasheet is as follows.

The index of the field is automatically established when the PRIMARY keyword constraint is created.
(12) The reader can also create a datasheet scott.director in "SQL Plus Worksheet" Directly by executing the Createdirector.sql file, as shown in Figure 7.12.

2. Steps to create a postgraduate information table
(1) The same as the creation of a Mentor information table operation.
(2) In the General Information tab of the Create table shown in Figure 7.13, follow the steps below to configure it.
(3) Figure 7.14 shows the Constraints tab of the primary code that creates the table.

(4) Figure 7.15 shows the Constraint tab for creating the outer code of the table.
(5) The cluster column, partition, storage, and Options tabs are set by default.
(6) The "Constraint Storage" tab shown in Figure 7.16 is configured as follows.

(7) The system will successfully create the data table Scott.student. The corresponding SQL code is as follows.

"See CD-ROM File": \ 7th Chapter \createstudent.sql.
(8) The reader can also create a datasheet scott.student in "SQL Plus Worksheet" Directly by executing the Createstudent.sql file, as shown in Figure 7.17.

(9) In Enterprise Manager, you can view the two sample data tables that you have established, as shown in Figure 7.18.