السلام عليكم
لدي هذه الجداول :
Cities
--------------------
City_id varchar2(10) primary key
City_name varchar2(50)
Iuser_id varchar2(30) user how create record
Itime date time on which the record created
User_id varchar2(30) the last user update the record
Utime date the last time the record updated
departments
---------------------
dept_id varchar2(10) p.k
dept_name varchar2(50)
Iuser_id varchar2(30) user who create the record
Itime date time on which the record create
User_id varchar2(30) the last user update the record
Utime date the last time the record update
Employees
--------------------------------------------------------------
EMP_ID NOT NULL VARCHAR2(10)
EMP_NAME VARCHAR2(50)
EMP_ID_NUM VARCHAR2(10)
CITY_ID VARCHAR2(10)
DEPT_ID VARCHAR2(10)
SALARY NUMBER
VAC_BALANCE NUMBER
IUSER_ID VARCHAR2(30)
ITIME DATE
USER_ID VARCHAR2(30)
UTIME DATE
Vacation_histpry (الاجازات)
----------------------------------------- --------
----------------------------
EMP_ID VARCHAR2(10)
S_DATE DATE
E_DATE DATE
IUSER_ID VARCHAR2(30)
ITIME DATE
USER_ID VARCHAR2(30)
UTIME DATE
فكيف يتم عمل التالي وشكرا:
Use oracle form builder to create a forms to deal with the listed table as follows:
1- department_employees "used to query about the employee related to specific department."
2- emp_vacation "used to give a vacation for the employee."
3- emp_vacations_history "used to list the vacation history for an employee."
4- dept_emp_status "used to list the employees of the specific department if the employee is available or on vacation and if on vacation the start date and the end date of his vacation."