Tugas Pemrograman SQL Kelas A,B,C
7 Maret 2017
Desain Tabel, pada database yang sudah dibuat minggu kemarin
Tabel Supplier
Field
|
Type
|
Size
|
Keterangan
|
Kdsup
|
Varchar
|
10
|
Primary Key
|
Nmsup
|
Varchar
|
50
|
|
Tgllhr
|
Date
|
8
|
|
Alamatkantor
|
Varchar
|
50
|
|
Telpkantor
|
Varchar
|
15
|
|
Jekel
|
Varchar
|
15
|
|
Email
|
Varchar
|
20
|
Isi Data
Kdsup
|
Nmsup
|
Tgllhr
|
Alamatkantor
|
Telpkantor
|
Jekel
|
Email
|
Sup001
|
Firman Ilahudin
|
12/04/1980
|
Jl. Gondang Manis
|
0291-5546738
|
Pria
|
|
Sup002
|
Joko Waluyo
|
07/03/1979
|
Jl. Bumi Wonosari
|
024-889772
|
Pria
|
|
Sup003
|
Ilham Wahid
|
19/8/1982
|
Jl. Dersalam
|
0291-889324
|
Pria
|
Tampilkan data
a. Tampilkan Data Supplier yang kantornya daerah Dersalam
b. Tampilkan Data Email Supplier yang rumahnya daerah gondangmanis
c. Tampilkan Data Supplier yang rumahnya daerah Semarang
Tambahkan kasus menampilkan data sendiri, sehingga genap 10 soal
#Tugas dikerjakan, dan di upload di blog masing2, paling lambat jumat jam 11.00
#Kirim alamat blog ke email arif_plstuff@yahoo.com dengan subject
PSQLA_Nim_H2, PSQLB_Nim_H2, PSQLC_Nim_H2
(201553045)-Fredo Maulana Putra-klas B
ReplyDelete201553066-Erna Zulianti-kelas B
ReplyDelete201553043-muh suhartomi-kelas b
ReplyDelete201553080 ( Dian Tri Raharjo) ‹kelas B>
ReplyDelete201553056_Dhimas Aji Wicaksono_Kelas B
ReplyDelete201553069_NauvalSa'ieduddin_KelasB
ReplyDelete201553064_Ahmad Isnan Wahyudi_KelasB
ReplyDelete201553071_Muhammad Nafi'Uddin_Kelas B
ReplyDelete201553079 _ Andrianus_kelas B
ReplyDelete201553061_Subekti Nur Wahyudi_Kelas B
ReplyDelete201553078_Angga Khoirir Riza_Kelas B
ReplyDelete201553051_Fat'hul Umam_kelas B
ReplyDelete201553060_Sovia_B
ReplyDelete201553076_Nikita Tri Ari Santi_B
ReplyDelete201553047_Rofiyatun_B
ReplyDelete201553072_Milasita Mangesthiningtyas_B
ReplyDelete201553065_Nisrina Ainiyatul Munawaroh_B
ReplyDelete201553067_Umi Rahayu_B
ReplyDelete201553075_MUNTARAM_B
ReplyDeleteThis comment has been removed by the author.
ReplyDelete201553044-Agus Dwi ismawan-Kelas_B
ReplyDelete201553063_Oktova Aulia Chasan_Kelas_B
ReplyDelete201553052 Ahmad Luthfi Hakim B
ReplyDeleteThis comment has been removed by the author.
ReplyDelete201553011-Arsya Yoga Pratama-kelas B
ReplyDelete201553058-Lina Anjelina-kelas C
ReplyDelete201553049-Shinta Ulfiana-kelas C
ReplyDelete201553050-Rita Suryana-Kelas C
ReplyDeleteThis comment has been removed by the author.
ReplyDelete201553068-Yulimar Astutik-Kelas C
ReplyDelete201553074-M. Yusuf Noor H.-Kelas C
ReplyDelete201553074-M. Yusuf Noor H.-Kelas C
ReplyDelete201553038-Bevi maulida k.-kelas C
ReplyDelete201553073-Galeh Raka Siwi-Kelas C
ReplyDelete201553018-Fiyyalailatun Nayyiroh-Kelas A
ReplyDelete201553034-Dimas Iswar B- Kelas A
ReplyDelete201553034-Dimas Iswar B- Kelas A
ReplyDelete201553004_Bela Herwati Ningsih_Kelas C
ReplyDelete201553007-Jihan Nisrina-Kelas A
ReplyDelete201553038-Bevi maulida k.-kelas C
ReplyDelete201553028-Anisa Ulya-Kelas A
ReplyDelete201553022-Dessy Muharfianti Putri-Kelas A
ReplyDelete201553037-Yuli Irmawati-Kelas A
ReplyDelete201553008_Yusiana Rahma_B
ReplyDelete201553006_Erlina Nofianti_C
ReplyDelete201553023_Fita Choiyanti_C
ReplyDelete201553041_nurul Mashfufah_C
ReplyDelete201553030_Risa Erlinawati_Kelas C
ReplyDelete201553001_Farih Daroini_Kelas C
ReplyDelete201553036_Lina Noviana_Kelas A
ReplyDelete201553013_Iman Ardhi Prabowo_C
ReplyDelete201553015_Toni Alfiyan_Kelas C
ReplyDelete201553021_Agung Dwi Ariyanto_B
ReplyDelete201553020_Triya Adzani Maulidina_A
ReplyDelete201553017_Novita Dwi Andriyani_Kelas A
ReplyDelete201553032_Labib Ashrori_B
ReplyDelete201553027_Muhammad Ilham_Kelas_B
ReplyDeleteThis comment has been removed by the author.
ReplyDelete201553003_mohammadkamalalfitra_b
ReplyDelete201553014_Farid Yuliyanto_B
ReplyDelete201553024_fidiana sekar rizqi_A
ReplyDelete201553026_RINA KHOIRUNNISA'_A
ReplyDeleteThis comment has been removed by the author.
ReplyDelete201553033_SYAIFUL BAHRI BAYUDA PRADANI_B
ReplyDelete201553002_Rusyana Sari_C
ReplyDelete201553012_BAyu Afrian_A
ReplyDelete201553025_Luqman Rosid_C
ReplyDelete