Teknik Informatika

"Tugas Besar Basis data"

“Tugas Besar Basis_data”

Nama : Edil Muhamad Aras

Kelas : B

M.K : Basis data

Materi : Database Hotel

Buatkan Normalisasi dari unnormalize,normal bentuk pertama, normal bentuk kedua, dan normal bentuk ketiga jika mungkin masih dapat dipecahkan lagi sampai kenormal selanjutnya dilanjutkan normalisasinya.

Normalisasi Pertama

$C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\Normalisasi 1.PNG$

Normalisasi Kedua

$C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\Normalisasi 2.PNG$

Normalisasi Ketiga

$C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\Normalisasi 3.PNG$

Buatkan database dan tabel menggunakan mysql berdasarkan normalisasi.

$C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\3 Database dan Tabel\Capture1.PNG$

$C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\3 Database dan Tabel\Capture2.PNG$

$C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\3 Database dan Tabel\Capture3.PNG$

$C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\3 Database dan Tabel\Capture12.PNG$

$C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\3 Database dan Tabel\Capture13.PNG$

$C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\3 Database dan Tabel\Capture23.PNG$

$C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\3 Database dan Tabel\Capture24.PNG$

$C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\3 Database dan Tabel\Capture33.PNG$

$C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\3 Database dan Tabel\Capture34.PNG$

$C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\3 Database dan Tabel\Capture45.PNG$

$C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\3 Database dan Tabel\Capture46.PNG$

$C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\3 Database dan Tabel\Capture47.PNG$

$C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\3 Database dan Tabel\Capture48.PNG$

4. Isi tabel Tersebut 100 Record setiap tabel dengan data yang baik dan benar bukan tabel sembarangan

$C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\4 IsiTabel 100 Record\Capture4.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\4 IsiTabel 100 Record\Capture5.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\4 IsiTabel 100 Record\Capture6.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\4 IsiTabel 100 Record\Capture7.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\4 IsiTabel 100 Record\Capture8.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\4 IsiTabel 100 Record\Capture9.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\4 IsiTabel 100 Record\Capture10.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\4 IsiTabel 100 Record\Capture11.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\4 IsiTabel 100 Record\Capture14.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\4 IsiTabel 100 Record\Capture15.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\4 IsiTabel 100 Record\Capture16.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\4 IsiTabel 100 Record\Capture17.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\4 IsiTabel 100 Record\Capture18.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\4 IsiTabel 100 Record\Capture19.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\4 IsiTabel 100 Record\Capture20.1.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\4 IsiTabel 100 Record\Capture21.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\4 IsiTabel 100 Record\Capture22.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\4 IsiTabel 100 Record\Capture25.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\4 IsiTabel 100 Record\Capture26.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\4 IsiTabel 100 Record\Capture27.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\4 IsiTabel 100 Record\Capture28.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\4 IsiTabel 100 Record\Capture29.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\4 IsiTabel 100 Record\Capture30.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\4 IsiTabel 100 Record\Capture31.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\4 IsiTabel 100 Record\Capture32.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\4 IsiTabel 100 Record\Capture35.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\4 IsiTabel 100 Record\Capture36.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\4 IsiTabel 100 Record\Capture37.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\4 IsiTabel 100 Record\Capture38.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\4 IsiTabel 100 Record\Capture39.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\4 IsiTabel 100 Record\Capture40.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\4 IsiTabel 100 Record\Capture41.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\4 IsiTabel 100 Record\Capture42.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\4 IsiTabel 100 Record\Capture43.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\4 IsiTabel 100 Record\Capture44.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\4 IsiTabel 100 Record\Capture49.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\4 IsiTabel 100 Record\Capture50.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\4 IsiTabel 100 Record\Capture51.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\4 IsiTabel 100 Record\Capture52.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\4 IsiTabel 100 Record\Capture53.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\4 IsiTabel 100 Record\Capture54.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\4 IsiTabel 100 Record\Capture55.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\4 IsiTabel 100 Record\Capture56.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\4 IsiTabel 100 Record\Capture57.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\4 IsiTabel 100 Record\Capture58.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\4 IsiTabel 100 Record\Capture59.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\4 IsiTabel 100 Record\Capture60.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\4 IsiTabel 100 Record\Capture61.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\4 IsiTabel 100 Record\Capture62.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\4 IsiTabel 100 Record\Capture63.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\4 IsiTabel 100 Record\Capture64.PNG$

$C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\4 IsiTabel 100 Record\Capture65.PNG$

5. Gunakan Perintah Alter Table yang terdiri dari add, drop, change minimal 3 field padasetiap tabel.

ALTER

$C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Alter\Alter Table 1.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Alter\Alter Table 2.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Alter\Alter Table 3.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Alter\Alter Table 4.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Alter\Alter Table 5.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Alter\Alter Table 6.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Alter\Alter Table 7.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Alter\Alter Table 8.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Alter\Alter Table 9.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Alter\Alter Table 10.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Alter\Alter Table 11.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Alter\Alter Table 12.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Alter\Alter Table 13.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Alter\Alter Table 14.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Alter\Alter Table 15.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Alter\Alter Table 16.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Alter\Alter Table 17.PNG$

$C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Alter\Alter Table 18.PNG$

CHANGE

$C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Change\Change 1.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Change\Change 2.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Change\Change 3.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Change\Change 4.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Change\Change 5.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Change\Change 6.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Change\Change 7.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Change\Change 8.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Change\Change 9.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Change\Change 10.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Change\Change 11.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Change\Change 12.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Change\Change 13.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Change\Change 14.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Change\Change 15.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Change\Change 16.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Change\Change 17.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Change\Change 18.PNG$

DROP

$C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Drop\Drop 18.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Drop\Drop 1.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Drop\Drop 2.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Drop\Drop 3.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Drop\Drop 4.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Drop\Drop 5.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Drop\Drop 6.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Drop\Drop 7.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Drop\Drop 8.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Drop\Drop 9.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Drop\Drop 10.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Drop\Drop 11.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Drop\Drop 12.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Drop\Drop 13.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Drop\Drop 14.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Drop\Drop 15.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Drop\Drop 16.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Drop\Drop 17.PNG$

$C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\5 Alter Table, Add, Drop\Drop\Drop 18.PNG$

6. Gunakan perintah Update dan delete disetiap table sebanyak 40 record.

UPDATE

$C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Update\Update 1.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Update\Update 2.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Update\Update 3.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Update\Update 4.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Update\Update 5.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Update\Update 6.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Update\Update 7.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Update\Update 8.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Update\Update 9.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Update\Update 10.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Update\Update 11.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Update\Update 12.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Update\Update 13.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Update\Update 14.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Update\Update 15.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Update\Update 16.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Update\Update 17.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Update\Update 18.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Update\Update 19.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Update\Update 20.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Update\Update 21.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Update\Update 22.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Update\Update 23.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Update\Update 24.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Update\Update 25.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Update\Update 26.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Update\Update 27.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Update\Update 28.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Update\Update 29.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Update\Update 30.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Update\Update 31.PNG$

$C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Update\Update 32.PNG$

DELETE

$C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Delete\Delete 1.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Delete\Delete 2.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Delete\Delete 3.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Delete\Delete 4.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Delete\Delete 5.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Delete\Delete 6.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Delete\Delete 7.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Delete\Delete 8.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Delete\Delete 9.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Delete\Delete 10.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Delete\Delete 11.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Delete\Delete 12.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Delete\Delete 13.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Delete\Delete 14.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Delete\Delete 15.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Delete\Delete 16.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Delete\Delete 17.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Delete\Delete 18.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Delete\Delete 19.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Delete\Delete 20.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Delete\Delete 21.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Delete\Delete 22.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Delete\Delete 23.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Delete\Delete 24.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Delete\Delete 25.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Delete\Delete 26.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Delete\Delete 27.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Delete\Delete 28.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Delete\Delete 29.PNG$

$C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\6 Update & Delete\Delete\Delete 30.PNG$

7. Gunakan perintah kondisi yang terdiri dari like, order by, group by, asc, dan desc disetiap table sebanyak 50 record.

Pegawai

$C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Pegawai\Like 50.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Pegawai\15.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Pegawai\47.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Pegawai\Like 1.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Pegawai\Like 2.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Pegawai\Like 3.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Pegawai\Like 4.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Pegawai\Like 5.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Pegawai\Like 6.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Pegawai\Like 7.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Pegawai\Like 8.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Pegawai\Like 9.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Pegawai\Like 10.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Pegawai\Like 11.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Pegawai\Like 12.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Pegawai\Like 13.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Pegawai\Like 14.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Pegawai\Like 15.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Pegawai\Like 16.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Pegawai\Like 17.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Pegawai\Like 18.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Pegawai\Like 19.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Pegawai\Like 20.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Pegawai\Like 21.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Pegawai\Like 22.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Pegawai\Like 23.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Pegawai\Like 24.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Pegawai\Like 25.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Pegawai\Like 26.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Pegawai\Like 27.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Pegawai\Like 28.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Pegawai\Like 29.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Pegawai\Like 30.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Pegawai\Like 31.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Pegawai\Like 32.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Pegawai\Like 33.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Pegawai\Like 34.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Pegawai\Like 35.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Pegawai\Like 36.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Pegawai\Like 37.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Pegawai\Like 38.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Pegawai\LIke 39.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Pegawai\Like 40.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Pegawai\Like 41.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Pegawai\Like 42.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Pegawai\Like 43.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Pegawai\Like 44.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Pegawai\LIke 45.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Pegawai\Like 46.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Pegawai\Like 47.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Pegawai\Like 48.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Pegawai\Like 49.PNG$

Tamu

$C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Tamu\Like 50.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Tamu\Like 1.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Tamu\Like 2.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Tamu\Like 3.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Tamu\Like 4.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Tamu\Like 5.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Tamu\Like 6.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Tamu\Like 7.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Tamu\Like 8.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Tamu\Like 9.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Tamu\Like 10.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Tamu\Like 11.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Tamu\Like 12.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Tamu\Like 13.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Tamu\Like 14.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Tamu\Like 15.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Tamu\Like 16.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Tamu\Like 17.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Tamu\LIke 18.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Tamu\Like 19.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Tamu\Like 20.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Tamu\Like 21.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Tamu\Like 22.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Tamu\Like 23.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Tamu\LIke 24.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Tamu\Like 25.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Tamu\Like 26.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Tamu\Like 27.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Tamu\Like 28.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Tamu\Like 29.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Tamu\Like 30.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Tamu\Like 31.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Tamu\Like 32.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Tamu\Like 33.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Tamu\Like 34.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Tamu\Like 35.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Tamu\Like 36.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Tamu\Like 37.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Tamu\Like 38.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Tamu\Like 39.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Tamu\Like 40.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Tamu\Like 41.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Tamu\Like 42.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Tamu\Like 43.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Tamu\Like 44.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Tamu\Like 45.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Tamu\Like 46.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Tamu\Like 47.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Tamu\Like 48.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Tamu\Like 49.PNG$

Kamar

$C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Kamar\Like 20.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Kamar\Like 1.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Kamar\Like 2.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Kamar\Like 3.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Kamar\Like 4.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Kamar\Like 5.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Kamar\Like 6.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Kamar\Like 7.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Kamar\Like 8.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Kamar\Like 9.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Kamar\Like 10.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Kamar\LIke 11.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Kamar\like 12.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Kamar\Like 13.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Kamar\LIke 14.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Kamar\like 15.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Kamar\like 16.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Kamar\Like 17.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Kamar\LIke 18.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Kamar\Like 19.PNG$

Transaksi

$C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Transaksi\Like 30.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Transaksi\Like 1.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Transaksi\Like 2.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Transaksi\Like 3.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Transaksi\Like 4.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Transaksi\Like 5.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Transaksi\Like 6.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Transaksi\Like 07.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Transaksi\LIke 8.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Transaksi\Like 9.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Transaksi\Like 10.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Transaksi\Like 11.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Transaksi\Like 12.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Transaksi\LIke 13.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Transaksi\LIke 14.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Transaksi\Like 15.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Transaksi\Like 16.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Transaksi\Like 17.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Transaksi\Like 19.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Transaksi\Like 20.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Transaksi\Like 21.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Transaksi\Like 22.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Transaksi\Like 23.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Transaksi\Like 24.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Transaksi\Like 25.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Transaksi\Like 26.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Transaksi\Like 27.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Transaksi\Like 28.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Transaksi\Like 29.PNG$

Kamar

Makanan

$C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Makanan\Like 20.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Makanan\Like 1.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Makanan\Like 2.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Makanan\LIke 3.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Makanan\Like 4.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Makanan\Like 5.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Makanan\Like 6.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Makanan\Like 7.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Makanan\LIke 8.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Makanan\Like 9.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Makanan\Like 10.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Makanan\Like 11.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Makanan\Like 12.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Makanan\Like 13.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Makanan\LIke 14.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Makanan\Like 15.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Makanan\LIke 16.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Makanan\Like 17.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Makanan\Like 18.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Makanan\Like 19.PNG$

Minuman

$C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Minuman\Like 20.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Minuman\Like 1.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Minuman\Like 2.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Minuman\Like 3.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Minuman\Like 4.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Minuman\Like 5.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Minuman\Like 6.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Minuman\LIke 7.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Minuman\Like 8.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Minuman\Like 9.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Minuman\Like 10.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Minuman\LIke 11.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Minuman\Like 12.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Minuman\Like 13.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Minuman\Like 14.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Minuman\Like 15.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Minuman\Like 16.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Minuman\Like 17.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Minuman\Like 18.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Like\Minuman\Like 19.PNG$

Order By

$C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Order By\Order by 34.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Order By\Order by 1.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Order By\Order by 2.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Order By\Order by 3.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Order By\Order by 4.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Order By\Order by 5.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Order By\Order by 6.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Order By\Order by 7.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Order By\Order by 8.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Order By\Order by 9.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Order By\Order by 10.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Order By\Order by 11.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Order By\Order by 12.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Order By\Order by 13.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Order By\Order by 14.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Order By\Order by 15.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Order By\Order by 16.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Order By\Order by 17.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Order By\Order by 18.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Order By\Order by 19.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Order By\Order by 20.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Order By\Order by 21.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Order By\Order by 22.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Order By\Order by 23.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Order By\Order by 24.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Order By\Order by 25.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Order By\Order by 26.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Order By\Order by 27.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Order By\Order by 28.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Order By\Order by 29.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Order By\Order by 30.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Order By\Order By 31.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Order By\Order by 32.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Order By\Order by 33.PNG$

$C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Order By\Order by 34.PNG$

Group By

$C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Group By\Group By 15.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Group By\Group By 16.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Group By\Group By 17.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Group By\Group By 18.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Group By\Group By 19.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Group By\Group By 20.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Group By\Group By 21.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Group By\Group By 1.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Group By\Group By 2.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Group By\Group By 3.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Group By\Group By 4.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Group By\Group By 5.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Group By\Group By 6.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Group By\Group By 7.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Group By\Group By 8.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Group By\Group By 9.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Group By\Group By 10.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Group By\Group By 11.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Group By\Group By 12.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Group By\Group By 13.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Group By\Group By 14.PNG$

ASC & DESC

$C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Asc, Desc\48.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Asc, Desc\1.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Asc, Desc\2.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Asc, Desc\3.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Asc, Desc\4.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Asc, Desc\5.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Asc, Desc\6.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Asc, Desc\7.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Asc, Desc\8.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Asc, Desc\9.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Asc, Desc\10.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Asc, Desc\11.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Asc, Desc\12.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Asc, Desc\13.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Asc, Desc\14.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Asc, Desc\15.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Asc, Desc\16.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Asc, Desc\17.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Asc, Desc\18.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Asc, Desc\19.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Asc, Desc\20.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Asc, Desc\21.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Asc, Desc\22.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Asc, Desc\23.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Asc, Desc\24.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Asc, Desc\25.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Asc, Desc\26.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Asc, Desc\27.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Asc, Desc\28.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Asc, Desc\29.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Asc, Desc\30.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Asc, Desc\31.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Asc, Desc\32.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Asc, Desc\33.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Asc, Desc\34.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Asc, Desc\35.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Asc, Desc\36.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Asc, Desc\37.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Asc, Desc\38.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Asc, Desc\39.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Asc, Desc\40.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Asc, Desc\41.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Asc, Desc\42.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Asc, Desc\43.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Asc, Desc\44.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Asc, Desc\45.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Asc, Desc\46.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\7 Like, Order by, Grup By, Asc, Des\Asc, Desc\47.PNG$

8. Gunakan Perintah fungsi – fungsi yang terdri dari fungsi String, Fungsi tanggal, dan fungsi Agrasi disetiap tabel.

Pegawai

$C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi String\Pegawai\Table Pegawai.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi String\Pegawai\ASCII.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi String\Pegawai\Char Pegawai.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi String\Pegawai\Concat Pegawai.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi String\Pegawai\Insert Pegawai.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi String\Pegawai\Instr Pegawai.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi String\Pegawai\Left,Right,Mid,Reverse Pegawai.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi String\Pegawai\Lenght Pegawai.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi String\Pegawai\Locate Pegawai.PNG$

Tamu

$C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi String\Tamu\Tabel Tamu.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi String\Tamu\ASCII Tamu.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi String\Tamu\Char Tamu.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi String\Tamu\Concat Tamu.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi String\Tamu\Insert Tamu.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi String\Tamu\Instr Tamu.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi String\Tamu\Left, Right, Mid, Reverse.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi String\Tamu\Length Tamu.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi String\Tamu\Locate Tamu.PNG$

Kamar

$C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi String\Kamar\Tabel Kamar.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi String\Kamar\ASCII Kamar.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi String\Kamar\Char Kamar.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi String\Kamar\Concat Kamar.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi String\Kamar\Insert Kamar.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi String\Kamar\Instr Kamar.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi String\Kamar\Left, Right, Mid, Reverse.PNG$

Transaksi

$C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi String\Transaksi\Tabel Transaksi.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi String\Transaksi\ASCII Transaksi 1.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi String\Transaksi\ASCII Transaksi 2.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi String\Transaksi\Char Transaksi.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi String\Transaksi\Concat Transaksi.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi String\Transaksi\Insert Transaksi.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi String\Transaksi\Instr Transaksi.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi String\Transaksi\Left, Right, Mid, Reverse.PNG$

Makanan

$C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi String\Makanan\Tabel Makanan.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi String\Makanan\ASCII Makanan.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi String\Makanan\Char Makanan.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi String\Makanan\Concat Makanan.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi String\Makanan\Insert Makanan.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi String\Makanan\Instr Makanan.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi String\Makanan\Left, Right, Mid, Reverse.PNG$

Minuman

$C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi String\Minuman\Tabel Minuman.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi String\Minuman\ASCII Minuman.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi String\Minuman\Char Minuman.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi String\Minuman\Concat.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi String\Minuman\Insert Minuman.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi String\Minuman\Instr Minuman.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi String\Minuman\Left, Right, Mid, reverse.PNG$

Fungsi Tanggal

$C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi Tanggal\Year.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi Tanggal\Curdate.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi Tanggal\Current TimeStamp.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi Tanggal\Curtime.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi Tanggal\Date_Format.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi Tanggal\Day of Month.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi Tanggal\Dayname.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi Tanggal\Hour.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi Tanggal\Minute.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi Tanggal\Second.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\8 Fungsi String, Fungsi Tanggal, Fungsi Agregasi\Fungsi Tanggal\Select Month.PNG$

9. Gunakan perintah Join untuk menampilkan data dari 2 tabel minimal 50 data yang ditampilkan ditabel yang berbeda – beda.

$C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\9 Join\Langkah 10.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\9 Join\Langkah 1.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\9 Join\Langkah 2.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\9 Join\Langkah 3.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\9 Join\Langkah 4.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\9 Join\Langkah 5.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\9 Join\Langkah 6.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\9 Join\Langkah 7.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\9 Join\Langkah 8.PNG$ $C:\Users\Aras\Documents\Tugas semester 1\Basis data\Tugas besar\9 Join\Langkah 9.PNG$

Teknik Informatika

Kamis, 31 Desember 2015

UAS_BASIS_DATA_EDILMUHAMADARAS_KELAS_B

Labels

About Me

Followers

Popular Posts

Blogger templates

Labels

Labels

Archive

Blogger news

Blogroll

About

Labels