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.