| Generate the tutorial database schema | 
The tutorial application uses a three database tables to store each employee's information: EMPLOYEE, ADDRESS and PHONE. Table: Tutorial Database Schema describes the columns for each table.
You can download SQL scripts to build and populate the database tables with sample data from: download location pending.
Tutorial Database Schema
| Table | Column | Type | Details | 
|---|---|---|---|
| EMPLOYEE 
 | EMP_ID | NUMBER(15) | Primary Key | 
| F_NAME | VARCHAR(40) | 
 | |
| L_NAME | VARCHAR(40) | 
 | |
| ADDR_ID | NUMBER(15) | Foreign Key, references ADDRESS.ADDRES_ID | |
| VERSION | NUMBER(15) | 
 | |
| ADDRESS 
 | ADDRESS_ID | NUMBER(15) | Primary Key | 
| PROVINCE | VARCHAR(80) | 
 | |
| COUNTRY | VARCHAR(80) | 
 | |
| STREET | VARCHAR(80) | 
 | |
| P_CODE | VARCHAR(20) | 
 | |
| CITY | VARCHAR(80) | 
 | |
| PHONE 
 | EMP_ID | NUMBER(15) | Foreign Key, reference to EMPLOYEE.EMP_ID | 
| AREA_CODE | VARCHAR(3) | 
 | |
| P_NUMBER | VARCHAR(7) | Primary key | |
| TYPE | VARCHAR(15) | 
 | 
Next, you will Create a database connection.