لوحة القادة

بعد عمل مكثف وجهد كبير قمت باعداد الجداول التالية ارجو من الاخ امجد وكل الاعضاء اعطائي ارائكم في هذه الجداول وخصوصا العلاقات فيما بينها CREATE TABLE CONTRACT ( CONTRACT_ID NUMBER(10) Primary Key, CONTRACT_EMP_ID NUMBER(10) Primary Key , Foreign key, CONTRACT_DATE DATE, CONTRACT_START_DATE DATE, CONTRACT_END_DATE DATE ) CREATE TABLE COUNTRIES ( COUNTRY_ID NUMBER(3) Primary Key, COUNTRY_NAME VARCHAR2(50) ) CREATE TABLE DEPARTMENTS ( DEPT_ID NUMBER(10) Primary Key, DEPT_NAME VARCHAR2(50), DEPT_LOCATION_ID NUMBER(10)foreign key, DEPT_MANAGER_ID NUMBER(10) foreign key ) CREATE TABLE EMPLOYEES ( EMP_ID NUMBER(10) Primary Key, F_NAME VARCHAR2(30), S_NAME VARCHAR2(30), T_NAME VARCHAR2(30), L_NAME VARCHAR2(30), DOB DATE, POB NUMBER(3), NATIONALITY NUMBER(3)foreign key, GENDER NUMBER(1), CURRENT_ADDRESS VARCHAR2(100), CARD_ID VARCHAR2(30), CARD_ISSUE_DATE DATE, CARD_PLACE VARCHAR2(30), PASSPORT_ID VARCHAR2(30), PASSPORT_ISSUE_DATE DATE, PASSPORT_EXPIRE_DATE DATE, PASSPORT_PLACE VARCHAR2(30), MARITAL_STATUS NUMBER(1), TEL1 VARCHAR2(30), TEL2 VARCHAR2(30), MOBILE1 VARCHAR2(30), MOBILE2 VARCHAR2(30), EMAIL VARCHAR2(100), INTERNAL_TEL VARCHAR2(30), EMP_DEPT_ID NUMBER(10)foreign key, JOB_ID NUMBER(10) foreign key ) CREATE TABLE FAMILY ( FAMILY_ID NUMBER(10) primary key, FAMILY_NAME_OF_RELY VARCHAR2(50), FAMILY_RELATIONSHIP NUMBER(1), FAMILY_JOB VARCHAR2(50), FAMILY_DOB DATE, FAMILY_EMP_ID NUMBER(10) foreign key ) CREATE TABLE JOBS ( JOB_ID NUMBER(10) primary key, JOB_NAME VARCHAR2(50), MIN_SALARY NUMBER(8,2), MAX_SALARY NUMBER(8,2), JOB_DESCRIPTION VARCHAR2(100) ) CREATE TABLE JOB_HISTORY ( EMP_ID NUMBER(10) primary key - foreign key , START_DATE DATE, END_DATE DATE, JOB_ID NUMBER(10) primary key - foreign key, DEPARTMENT_ID NUMBER(10) primary key - foreign key, New_SALARY NUMBER(8,3), TYPE_TO_CHANGE NUMBER(1) ) CREATE TABLE LOCATIONS ( LOCATION_ID NUMBER(10) primary key, COUNTRY_ID NUMBER(3) primary key- foreign key, LOCATION_NAME VARCHAR2(50) ) CREATE TABLE PREVIOUS_EXPERIENCE ( EXPERIENCE_ID NUMBER(10) primary key, EXPERIENCE_EMP_ID NUMBER(10) primary key, COMPANY_NAME VARCHAR2(50), COMPANY_JOB VARCHAR2(50), COMPANY_JOB_DESCRIPTION VARCHAR2(50), COMPANY_FROM_DATE DATE, COMPANY_TO_DATE DATE, RESIGN_REASON VARCHAR2(100) ) CREATE TABLE QUALIFICATIONS ( QUALIFICATION_ID NUMBER(10) primary key, QUALIFICATION_EMP_ID NUMBER(10) primary key- foreign key, QUALIFICATION_TYPE NUMBER(1), QUALIFICATION_SPEC VARCHAR2(50), QUALIFICATION_FROM_PLACE NUMBER(1), QUALIFICATION_DATE DATE, QUALIFICATION_GRADE VARCHAR2(50), QUALIFICATION_OTHER_STUDIES VARCHAR2(50), QUALIFICATION_OTHER_TYPE NUMBER(1), QUALIFICATION_OTHER_SPEC VARCHAR2(50), QUALIFICATION_OTHER_DATE DATE ) CREATE TABLE RECRUITMENT ( RECRUITMENT_ID NUMBER(10) primary key, RECRUITMENT_STATUS NUMBER(1), RECRUITMENT_DATE_FROM DATE, RECRUITMENT_DATE_TO DATE, RECRUITMENT_DEFERRED_DATE_FROM DATE, RECRUITMENT_DEFERRED_DATE_TO DATE, RECRUITMENT_DATE_OF_CERTIFY DATE, RECRUITMENT_EMP_ID NUMBER(10) primary key- foreign key )