SAMPLE PROJECT

I WANT TO CREATE ONE SAMPLE PROJECT BACKEND is ORACLE FRONT-END WITH ORACLE-ADF 12C Project Details : when the project will start the login page will display , after enter the login then dashboard will be display, dashboard have hierarchy menu in left side, but it is not fixed can be hide ,when the user click on employee then employee form will be display and user can insert update delete and select data, when the user click on employee report then employee report will be display we can print and save in excel and pdf format. note:= login and logout session will be maintain TABLE:- CREATE TABLE MENU (MEUEID NUMBER PRIMARY KEY, MENUNAME VARCHAR2(200), PMENUID NUMBER REFERENCES MENU); INSERT INTO MENU VALUES(1,'MENU',null); INSERT INTO MEN VALUES(2,'Project-1',1); INSERT INTO MENU VALUES(3,'Project-3',1); INSERT INTO MENU VALUES(4,'Project-4',1); INSERT INTO MENU VALUES(5,'Master',2); INSERT INTO MENU VALUES(6,'Report',2); INSERT INTO MENU VALUES(7,'Employee',5); INSERT INTO MENU VALUES(8,'Employee Report',6); CREATE TABLE USERS (USERID NUMBER PRIMARY KEY, USERNAME VARCHAR2(100) UNIQUE, PASSWORD VARCHAR2(100)); create table emp (empno number(4) primary key, ename varchar2(20), job varchar2(20), mgr number references emp, hiredate date, sal number(10,2), comm number(10,2), deptno number(2));