laporan akhir praktikum basisdata 1 modul 1

7/26/2019 Laporan Akhir Praktikum Basisdata 1 Modul 1

1/19

LAPORAN HASIL PRAKTIKUM

BASIS DATA I

NAMA : REJEYELKY PERNATHA

NIM : DBC 114 093

KELAS : B

MODUL : I

TOPIK : DATA DEFINITION LANGUAGE (DDL) CREATE, ALTER, DROP

DATABASE DAN TABLE

Penilai,

Asisten Praktikum

MEYCELINO A.T.

KOMPOSISINilai

MaksimalNILAI

BAB I T!"# $"# L"#$"%"# T&' *0

BAB II L"#+"- K&!" 10

BAB III P&./"-"%"# 40

BAB I K&%.2"# 1

BAB D"5" P%5""

BAB I L"."# 10

J.2"- 100


2/19

LABORATORIUM PEMROGRAMAN

JURUSAN TEKNIK INFORMATIKA FAKULTAS TEKNIK

UNIVERSITAS PALANGKARAYA

TAHUN 2!"

BAB I

TUJUAN DAN LANDASAN TEORI

A. T#$#a%

S&5&2"- "5. # ."-"%%6" $""5:

17 M&./"5, $"# .+-"% $"5"/"%& .&2"2 %#5" DDL7

*7 M&./"5, .+/"- $"# .+-"% 5"/2& $+"# %#5" DDL7

37 M++"#5 #"." 5"/2& $+"# %#5" DDL7

B. La%&asa% T'()i

D% $"5" /"-"%" '#%& $"# #"." &5"." "2 $&"2"# $"2".

"5"##8" $+"# CODASYL $"5"/"%& .'$&2, $ ."#" %&." $"5"/"%& 5

$52% $"2". %#5"% /"-"%" 8"#+ .++"./""# "5"5"#, /$"#+, $"# %&5

$" ++#" $"5" .'$&2 K&.$"# $+#""# #5 .&/5 -.#"#

/"+"# $" S55&$ &8 L"#+"+& (SL) #5 .&./"5 5"/&2 $"#

$"2"7 SL;9* .&.&"2"# /"-"%" ."#2"% %&." $"# 5"/&2 %&."

#'."% #5 %&."


3/19

17 CREATED+#""# U#5 .&./"5 $"5"/" %&."# 5"/2& /", #$&%,"5" $% $"2"?$7 RDBMS 5&5 #+%

S&/"+" '#5'-, "- #5 .&./"5 5"/&2 "8"6"# $+"#

'2'. /&/&"" %".&2 ""# .!"$:

.&./"5 5"/&2 "8"6"#

create TABEL karyawan (

id INTEGER PRIMARY KEY,

first_name AR!"AR (#$% N&LL,

'ast_name AR!"AR (#% N)T N&LL,

*ate)fBirt+ N&LL TANGGAL,

%

*7 DROP

D';$+#""# #5 .+-"% $"5"/"%& 8"#+ %$"- "$", 5"/&2,

#$&%, "5" .&2-"57 P"5""# DROP "$" SL $+#""# #5

.+-"% '/!& $" %&/"- %%5&. ."#"!&. $"5"/"%& &2"%'#"2

(RDBMS)7 J% '/!& 8"#+ $""5 $!"5-"# 5&+"#5#+ "$"

RDBMS 8"#+ $+#""#, 5&5" %&/"+"# /&%" .$#+


4/19

.!"5-"# 5"/&2, ++#", $"# $"5"/"%&7 B&/&"" %%5&. (%&&5

P'%5+&SL) .&.#+#"# DROP $"# "- DDL 2"# 5&!"$

$"2". %&/"- 5"#%"% $"# $+"# $&."# ""# $+2#+ &./"27

P++#""# -"% -"#8": DROP '/!&5 58& '/!&5#".&7

P"$" DROP "5""# /&/&$" $" DELETE $"# TRUNCATE

"5""#, "" .&&" 5$" .+-"% 5"/&2 5 %$7

M%"2#8", DELETE "5""# .#+# .+-"% /&/&"" ("5"

%&.") $"5" $" 5"/&2 $"2". $"5"/"%&, %&$"#+"# DROP "5""#

""# .+-"% %&2- 5"/&2 $" $"5"/"%&7

37 ALTERA25&;U#5 .&.'$"% '/!& $"5"/"%& 8"#+ 5&2"- "$"7 P"5""#

ALTER $"2". SL $+#""# #5 .+/"- %"5 $" %"5 '/8&

$"2". %&/"- %%5&. ."#"!&. $"5"/"%& &2"%'#"2 (RDBMS)7 J%;

!% $"5" 8"#+ $""5 $/"- 5&+"#5#+ "$" RDBMS %&$"#+

$+#""#7 P++#""# 8"#+ /"%" "$"2"-:

ALTER '/!&558& '/!&5#".& "".&5&%7 S&/"+" '#5'-, "-

#5 ."./"-"# (&.$"# -"%) '2'. /"." +&2&./#+

#5 5"/&2 8"#+ "$" /"." 6"%5"&2 ""# .!"$:

ALTER TABLE A** wastafe' INTEGER -e'em./n-

ALTER -e'em./n- *R)P TABLE wastafe' K)L)M


5/19

BAB II

LANGKAH KERJA

TUGAS PENDAHULUAN

P&2"!" /"+"# BELAJAR DARI CONTOH, $"# &!""# 5+"% /&5 #:

17 P&2"!" "" ++#""# &$5' SL8'+ 8"#+ 5&$""5 "$" L"."# 1

/"+"# /&2""#+ / #

*7 A" 8"#+ $."%$ $+"# D"5" D'# L"#+"+&

37 J&2"%"# "" 8"#+ $2""# '2&- "- SL "$" 2"#+"- 1;1*

(L"#+"-;2"#+"- 5&%&/5 .&""# %"5 &%"5"# 5"# '%&%7 H"%2

%&5" "- $&2-"5"# '2&- +"./" $ /"6"-#8"7)

47 G"./""# %&." $"5"/"%& "- 8"#+ $/ '2&- 2"#+"- 1;10

BELAJAR DARI CONTOH

!. show databases

2. create database akademik;

show databases;

*. use akademik;


6/19

4. show tables;

create table mahasiswa (nim varchar(20),

nama varchar(50),tgl_lahir datetime);

show tables;

desc mahasiswa;

alter table mahasiswaadd tempat_lahir varchar(20) ater nama,add dosen_pa varchar(20) not null;


7/19

desc mahasiswa;

5. alter table mahasiswaadd primar! ke! k_mahasiswa (nim);

desc mahasiswa;

". create table dosen (nip varchar(20),nm varchar(50));

#. alter table dosenchange nm nama varchar(50) ;

+. alter table dosen add primar! ke! pk_dosen (nip);


8/19

$. alter table mahasiswa add oreign ke! k_dosen_pa(dosen_pa)reerences dosen(nip);

desc mahasiswa;

!. rename table mahasiswa to mhs;

%how tables;

!!. drop table mhs;

show databases


9/19

TUGAS PRAKTIKUM

17 B"52"- $"5"/"%& 8"#+ $/& #"." %&%" NIM A#$" ."%#+;."%#+, 8"#+

.&.2 %55 %&/"+" /&5:

*7 U/"- %55 5"/2& !"2"# .!"$:

37 U/"- %55 5"/2& "2/. .!"$:

47 U/"- %55 5"/2& $52!"2"# .!"$:


10/19

7 R".& 5"/2& $52!"2"# .!"$ $&5"2!"2"#


11/19

BAB III

PEMBAHASAN

TUGAS PENDAHULUAN

2. DDL "5" D"5" D'# L"#+"+& "$"2"- .2"# "- "$" %


12/19

B+% #5 ."# %&." $"5"/"%&, 5&."% $"5"/%& 8"#+ 5&2"- $/"5

5"$ 8"5 $/1140937

&se *B!001$23

P"- # /+% #5 ."% $"2". $"5"/"%& 8"#+ #+# 5" /"5 5"/2"

8"5 $/1140937

4+5w ta.'es

B&+#" #5 .&2-"5 5"/2& 8"#+ "$" "$" $"5"/"%& 8"#+ 5" #+#"#

'#5'-#8" 5"/2&%#$/1140937

P"$" "- $"5"% /+% %&/"+" ""/&2 %&5" '2'. 8"#+ ""# $""

"$" $"5"/"%& # !&2"%"# '$#+#8" "$"2"- CREATE 5"/2& NAMA TABEL

(NAMA KOLOM TIPE DATA (PANJANG DATA ) )7


13/19

P"$" "- $"5"% !+" 2"#+%#+ #5 .&./"5 5+" 5"/2& 8"5 "2/., $52!"2"#,

$"# !"2"#7 J"$ !" 5" #+# .&2-"5 -"%2#8" $+"# .+&5 6s+5w ta.'es7

ALTER TABLE a'./m A** PRIMARY KEY 8k_a'./m(k5de_a'./m%

P"$" "- # /+% #5 ."./"- '2'. "$" "2/. $+"# '2'. "2/.

('$& "2/.)7

ALTER TABLE dt'_8en9/a'an A** PRIMARY KEY8k_dt'_8en9/a'an(k5de_8en9/a'an%

P"- # "$"2"- /+% #5 ."./"- '2'. "$" $52!"2"# $+"#

'2'. $52!"2"#7

ALTER TABLE dt'_8en9/a'an A** :)REIGN KEY

dt'_8en9/a'an(k5de_a'./m% RE:EREN!E4 a'./m(k5de_a'./m%

"$" "- # /+% #5 ."./"- '2'. "$" $52!"2"# $+"#

'2'. $52!"2"# ('$& "2/.) $"# !+" "+" $""5 5&-#/#+ $+"# "2/.

('$& "2/.)7

ALTER TABLE 8en9/a'an A** PRIMARY KEY 8en9/a'an

(k5de_8en9/a'an%

P"$" "- # "$"2"- "./"-"# '2'. "$" 5"/2& !"2"# '2&- '2'.!"2"# ('$&!"2"#)7


14/19

P"$" '$#+ $"5"% /+% #5 .".2"# '2'. "$" $"5"/"%&, !"$ "$"

'$#+ # #5 ..2"# '2'. "2/., '2'. $52!2"# $"# !"2"#,

."" 5".2"#8" %&/"+" /&57

*E4! a'./m

*E4! dt'_8en9/a'an

*E4! 8en9/a'an

ALTER TABLE 8en9/a'an

A** t5ta' *E!IMAL A:TER tan--a'

P"./"-"# '2'. "$" 5"/2& !"2"# $+"# '2'. 5'5"2 $+"# ""/&2

$&."2 $"# "./"-" "$" '2'. 5"#++"2 !+"7


15/19

ALTER TABLE a'./m

A** sam8/' BL)B A:TER 8enyanyi

P"./"-"# "$" '2'. "$" 5"/2& "2/. $+"# ."./"- '2'. %".2

$+"# "/&2 BLOB, "$" ""/&2 # /"%"#8" /&" '5'=+"./", $"#

"./"-"# '2'. "$" '2'. "#87

ALTER TABLE dt'_8en9/a'an

A** ;ty 4MALLINT A:TER k5de_a'./m

P"$" "- # /+% #5 ."./"- '2'. "$" 5"/2&!"2"# $+"# '2'.


16/19

BAB IV

KESIMPULAN

P"$" "5. "2 # $""5 $%2"#:

B&$"%""# +&5"# .+" DDL (D"5" D'# L"#+"+&) $"5"% /%"

5" "./2 &%.2"# /"-6" D"5" D'# L"#+"+& "$"2"- "- 8"#+

$+#""# #5 $%"# $"5"/"%& ."# /"+"# $" $"5"/"%& %&&5 5"/&2

$"# &67 P"- 8"#+ $+#""#: CREATE, DROP, $"# ALTER7


17/19

BAB V

DAFTAR PUSTAKA

.'$2 "5. /"%% $"5" I !%"# 5 #'."5", #&%5"% "2"#+"

"8"7

-55:==##"$6"#$"7/2'+%'57'7$=*01*=10=2"'"#;%%5&.;."#"!&./"%%;

$"5";$$27-5.2- !! a)il 2!"/ 22.*,0

-55:=="#5%47/2'+%'57'7$=*01*=10=+&5"#;$$2;$"5";$'#;

2"#+"+&7-5.2 -!!a)il 2!"/ 2*.!!0
http://nurvinadwiandari.blogspot.co.id/2012/10/laporan-sistem-manajemen-basis-data-ddl.htmlhttp://nurvinadwiandari.blogspot.co.id/2012/10/laporan-sistem-manajemen-basis-data-ddl.htmlhttp://irpantips4u.blogspot.co.id/2012/10/pengertian-ddl-data-definition-language.html%20(11http://irpantips4u.blogspot.co.id/2012/10/pengertian-ddl-data-definition-language.html%20(11http://irpantips4u.blogspot.co.id/2012/10/pengertian-ddl-data-definition-language.html%20(11http://irpantips4u.blogspot.co.id/2012/10/pengertian-ddl-data-definition-language.html%20(11http://irpantips4u.blogspot.co.id/2012/10/pengertian-ddl-data-definition-language.html%20(11http://irpantips4u.blogspot.co.id/2012/10/pengertian-ddl-data-definition-language.html%20(11http://nurvinadwiandari.blogspot.co.id/2012/10/laporan-sistem-manajemen-basis-data-ddl.htmlhttp://nurvinadwiandari.blogspot.co.id/2012/10/laporan-sistem-manajemen-basis-data-ddl.html


18/19

BAB VI

LAMPIRAN


19/19

laporan akhir praktikum basisdata 1 modul 1

Documents