TUGAS project UTS.docx

Description
SISTEM BASIS DATA 1 “ Pemesanan Tiket Bus” Disusun Oleh : NAMA: NADIYA RIZQI Nim : 15090030 Kelas 3B POLITEKNIK HARAPAN BERSAMA TEGAL 2017 1. TABEL KARYAWAN CREATE TABLE KARYAWAN ( NIK CHAR(10) CONSTRAINT KAR_NIK_NK NOT NULL, NAMA VARCHAR2(30) CONSTRAINT KAR_NAMA_NK NOT NULL, ALAMAT VARCHAR2(100) CONSTRAINT KAR_ALAMAT_NK NOT NULL, TGL_LAHIR varchar(8) CONSTRAINT KA

Please download to get full document.

View again

of 12
All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
Information
Category:

Documents

Publish on:

Views: 10 | Pages: 12

Extension: PDF | Download: 0

Share
Transcript
  SISTEM BASIS DATA 1 “ Pemesanan Tiket Bus” Disusun Oleh : NAMA: NADIYA RIZQINim: 15090030Kelas3B POLITEKNIK HARAPAN BERSAMA TEGAL 2017  1.TABEL KARYAWAN CREATE TABLE KARYAAN !NIK C AR!10# C$NSTRAINT KAR%NIK%NK N$T N&LL'NAMA (ARC AR2!30# C$NSTRAINT KAR%NAMA%NK N$T N&LL'ALAMAT (ARC AR2!100# C$NSTRAINT KAR%ALAMAT%NK N$T N&LL' T)L%LA IR *a+,-a+!.# C$NSTRAINT KAR%LA IR%NK N$T N&LL'N$% / (ARC AR2!12# C$NSTRAINT KAR% /%NK N$T N&LL' ENIS%KELAMIN C AR!9# C$NSTRAINT K%NK N$T N&LL'C$NSTRAINT NIK%/RK /RIMARY KEY!NIK#'C$NSTRAINT /%&NQ &NIQ&E!N$% /#'C$NSTRAINT KL%CK C ECK!ENIS%KELAMIN IN!LAKILAKI'/EREM/&AN### INPUTAN TABEL KARYAWAN INSERT INT$ KARYAAN !NIK' ama' alama4' 4l%la-i+' 6%-' 8eis%elami# (AL&ES !00001'sa4i'e+4a-a+8a'0202000'0.57;575.900'/EREM/&AN#INSERT INT$ KARYAAN !NIK' ama' alama4' 4l%la-i+' 6%-' 8eis%elami# (AL&ES !00002'<ai'a+asem=>'10111997'0.57;5755;7'LAKILAKI#INSERT INT$ KARYAAN !NIK' ama' alama4' 4l%la-i+' 6%-' 8eis%elami# (AL&ES !00003's6+a?a'8a4i=a+a'2305199.'0.57;595;;'/EREM/&AN#INSERT INT$ KARYAAN !NIK' ama' alama4' 4l%la-i+' 6%-' 8eis%elami# (AL&ES !0000'mela'4a?asa'1;112000'0.57;5755;0'/EREM/&AN#INSERT INT$ KARYAAN !NIK' ama' alama4' 4l%la-i+' 6%-' 8eis%elami# (AL&ES !00005'?ai'8al6+'0910199.'0.57;5755;1'/EREM/&AN#  INSERT INT$ KARYAAN !NIK' ama' alama4' 4l%la-i+' 6%-' 8eis%elami# (AL&ES !0000;'a>s'a+asem=>'10091995'0.57;575570'LAKILAKI#INSERT INT$ KARYAAN !NIK' ama' alama4' 4l%la-i+' 6%-' 8eis%elami# (AL&ES !00007'al@'4a?asa'1209199.'0.57;57509;7'LAKILAKI#INSERT INT$ KARYAAN !NIK' ama' alama4' 4l%la-i+' 6%-' 8eis%elami# (AL&ES !0000.'68i'a+asem=>'1011199;'0.57;575707'LAKILAKI#INSERT INT$ KARYAAN !NIK' ama' alama4' 4l%la-i+' 6%-' 8eis%elami# (AL&ES !00009'<ii'=+e=es'10111995'0.57;5755.0'/EREM/&AN#INSERT INT$ KARYAAN !NIK' ama' alama4' 4l%la-i+' 6%-' 8eis%elami# (AL&ES !000010'ase'8aea+a'10111997'0.57;57535'LAKILAKI# 2.TABEL PEMESAN CREATE TABLE /EMESAN !  ID%/EMESAN (AERC AR2!10# C$NSTRAINT ID%/EMESAN N$T N&LL'NAMA (ARC AR2!30# C$NSTRAINT NAMA%/EMESAN N$T N&LL'ALAMAT (ARC AR2!100# C$NSTRAINT ALAMAT%/EMESAN N$T N&LL' T)L DATE C$NSTRAINT T)L%/EMESAN N$T N&LL'N$% / (ARC AR2!13#' ENIS%KELAMIN C AR!9# C$NSTRAINT ENIS%KELAMIN N$T N&LL'C$NSTRAINT ID%/EMESAN%/K /RIMARY KEY !ID%/EMESAN#'C$NSTRAINT /EM%N$% / &NIQ&E !N$% /#'C$NSTRAINT ENIS%KELAMIN%CK C ECK !ENIS%KELAMIN IN!LAKILAKI'/EREM/&AN### INPUTAN TABEL PEMESAN INSERT INT$ /EMESAN !i<%emesa' ama' alama4' 4l' 6%-' 8eis%elami# (AL&ES !00011'?ai +a-a?>'8aea+a'0;111997'0.57;57535'/EREM/&AN#INSERT INT$ /EMESAN !i<%emesa' ama' alama4' 4l' 6%-' 8eis%elami# (AL&ES !00012'i<+a ma>la'4a?asa'0;111997'0.57;575535'LAKILAKI#INSERT INT$ /EMESAN !i<%emesa' ama' alama4' 4l' 6%-' 8eis%elami# (AL&ES !00013'+isa ?ai'8al6+'09121997'0.575;7535'/EREM/&AN#INSERT INT$ /EMESAN !i<%emesa' ama' alama4' 4l' 6%-' 8eis%elami# (AL&ES !0001'?a?a-'lim=aa'09121997'0.57;5759.5'/EREM/&AN#INSERT INT$ /EMESAN !i<%emesa' ama' alama4' 4l' 6%-' 8eis%elami# (AL&ES !00015'si4ia'8aea+a'09071995'0.57;57525;.'/EREM/&AN#INSERT INT$ /EMESAN !i<%emesa' ama' alama4' 4l' 6%-' 8eis%elami# (AL&ES !0001;'+iaa'=+e=es'12091995'0.57;575735'/EREM/&AN#INSERT INT$ /EMESAN !i<%emesa' ama' alama4' 4l' 6%-' 8eis%elami# (AL&ES !00017'86*a'slai'0;11199'0.57;575;75'LAKILAKI#
Related Search
We Need Your Support
Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

Thanks to everyone for your continued support.

No, Thanks