Karyawan 2

/*==============================================================*/ /* DBMS name: ORACLE Version 10g */ /* Created on: 10/30/2013 6:01:57 AM */ /*==============================================================*/ alter table EMPLOYEE drop constraint FK_EMPLOYEE_RELATIONS_COUPLE; alter table EMPLOYEE drop constraint FK_EMPLOYEE_RELATIONS_CHILD; alter table EMPLOYE_EDUC drop constraint FK_EMPLOYE__RELATIONS_JURUSAN; alter table EMPLOYE_EDUC drop constraint FK_EMPLOYE__RELATIONS_TR_EDU; alter table TIME_KEEPING drop constraint FK_TIME_KEE_RELATIONS_EMPLOYEE; alter table TR_EDU drop constraint FK_TR_EDU_RELATIONS_EMPLOYEE; alter table TR_TRAINING drop constraint FK_TR_TRAIN_RELATIONS_EMPLOYEE; drop table CHILD cascade constraints; drop table COUPLE cascade constraints; drop index RELATIONSHIP_10_FK; drop index RELATIONSHIP_9_FK; drop table EMPLOYEE cascade constraints; drop table EMPLOYE_EDUC cascade constraints; drop table JURUSAN cascade constraints; drop index RELATIONSHIP_3_FK; drop table TIME_KEEPING cascade constraints; drop index RELATIONSHIP_6_FK; drop table TR_EDU cascade constraints; drop index RELATIONSHIP_4_FK; drop table TR_TRAINING cascade constraints; /*==============================================================*/ /* Table: CHILD */ /*==============================================================*/ create table CHILD ( CHILD_NAME CHAR(30) not null, D_LAHIR DATE, C_PENDIDIKAN INTEGER, constraint PK_CHILD primary key (CHILD_NAME) ); /*==============================================================*/ /* Table: COUPLE */ /*==============================================================*/ create table COUPLE ( I_ISTRI INTEGER not null, N_ISTRI CHAR(30), D_LHIR DATE, constraint PK_COUPLE primary key (I_ISTRI) ); /*==============================================================*/ /* Table: EMPLOYEE */ /*==============================================================*/ create table EMPLOYEE ( ID_EMPLOYEE INTEGER not null, I_ISTRI INTEGER, CHILD_NAME CHAR(30), N_EMPLOYEE CHAR(40), E_ALAMAT VARCHAR2(50), constraint PK_EMPLOYEE primary key (ID_EMPLOYEE) ); /*==============================================================*/ /* Index: RELATIONSHIP_9_FK */ /*==============================================================*/ create index RELATIONSHIP_9_FK on EMPLOYEE ( CHILD_NAME ASC ); /*==============================================================*/ /* Index: RELATIONSHIP_10_FK */ /*==============================================================*/ create index RELATIONSHIP_10_FK on EMPLOYEE ( I_ISTRI ASC ); /*==============================================================*/ /* Table: EMPLOYE_EDUC */ /*==============================================================*/ create table EMPLOYE_EDUC ( I_EDU_FORMAL INTEGER, ID_JURUSAN INTEGER, N_EDUC_FORMAL CHAR(30), D_LULUS DATE, A_SEKOLAH CHAR(30), I_UJAZAH INTEGER ); /*==============================================================*/ /* Table: JURUSAN */ /*==============================================================*/ create table JURUSAN ( ID_JURUSAN INTEGER not null, N_JURUSAN CHAR(30), constraint PK_JURUSAN primary key (ID_JURUSAN) ); /*==============================================================*/ /* Table: TIME_KEEPING */ /*==============================================================*/ create table TIME_KEEPING ( D_ABSEN DATE not null, ID_EMPLOYEE INTEGER, I_JAM_DATANG INTEGER, I_JAM_PULANG INTEGER, E_KETERANGAN CHAR(40), constraint PK_TIME_KEEPING primary key (D_ABSEN) ); /*==============================================================*/ /* Index: RELATIONSHIP_3_FK */ /*==============================================================*/ create index RELATIONSHIP_3_FK on TIME_KEEPING ( ID_EMPLOYEE ASC ); /*==============================================================*/ /* Table: TR_EDU */ /*==============================================================*/ create table TR_EDU ( I_EDU_FORMAL INTEGER not null, ID_EMPLOYEE INTEGER, N_EDU_FORMAL CHAR(30), constraint PK_TR_EDU primary key (I_EDU_FORMAL) ); /*==============================================================*/ /* Index: RELATIONSHIP_6_FK */ /*==============================================================*/ create index RELATIONSHIP_6_FK on TR_EDU ( ID_EMPLOYEE ASC ); /*==============================================================*/ /* Table: TR_TRAINING */ /*==============================================================*/ create table TR_TRAINING ( C_TRAINING INTEGER not null, ID_EMPLOYEE INTEGER, N_TRAINING CHAR(30), constraint PK_TR_TRAINING primary key (C_TRAINING) ); /*==============================================================*/ /* Index: RELATIONSHIP_4_FK */ /*==============================================================*/ create index RELATIONSHIP_4_FK on TR_TRAINING ( ID_EMPLOYEE ASC ); alter table EMPLOYEE add constraint FK_EMPLOYEE_RELATIONS_COUPLE foreign key (I_ISTRI) references COUPLE (I_ISTRI); alter table EMPLOYEE add constraint FK_EMPLOYEE_RELATIONS_CHILD foreign key (CHILD_NAME) references CHILD (CHILD_NAME); alter table EMPLOYE_EDUC add constraint FK_EMPLOYE__RELATIONS_JURUSAN foreign key (ID_JURUSAN) references JURUSAN (ID_JURUSAN); alter table EMPLOYE_EDUC add constraint FK_EMPLOYE__RELATIONS_TR_EDU foreign key (I_EDU_FORMAL) references TR_EDU (I_EDU_FORMAL); alter table TIME_KEEPING add constraint FK_TIME_KEE_RELATIONS_EMPLOYEE foreign key (ID_EMPLOYEE) references EMPLOYEE (ID_EMPLOYEE); alter table TR_EDU add constraint FK_TR_EDU_RELATIONS_EMPLOYEE foreign key (ID_EMPLOYEE) references EMPLOYEE (ID_EMPLOYEE); alter table TR_TRAINING add constraint FK_TR_TRAIN_RELATIONS_EMPLOYEE foreign key (ID_EMPLOYEE) references EMPLOYEE (ID_EMPLOYEE);