Here you will be able to:

Create the tables (Part of HR application):

create table HR_Department( Department_id number, Department_name varchar2(100), Manager_id number, constraints HR_Department_PK primary key(Department_id) ); create table HR_Jobs( Job_id varchar2(30), Job_title varchar2(100), Min_Salary number, Max_Salary number, constraints HR_Jobs_PK primary key(Job_id) ); create table HR_Emlopyee( Department_id number, Employee_id number, First_name varchar2(100), Last_name varchar2(100), Email varchar2(30), Phone varchar2(20), Hire_date date, Job_id varchar2(30), Salary number, Commission number, Manager_id number, constraint HR_Emlopyee_pk primary key(Employee_id) , constraint HR_Emlopyee_fk1 foreign key(Department_id) references HR_Department(Department_id), constraint HR_Emlopyee_fk2 foreign key(Job_id) references HR_Jobs(Job_id));

Create Business component :

• Entity object
• View object
• Application module

Watch the Session