Monday, March 6, 2017

Tugas Pemrograman SQL Kelas A,B,C

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
Tambahkan 7 data lagi, sehingga genap 10 



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

67 comments:

  1. (201553045)-Fredo Maulana Putra-klas B

    ReplyDelete
  2. 201553066-Erna Zulianti-kelas B

    ReplyDelete
  3. 201553043-muh suhartomi-kelas b

    ReplyDelete
  4. 201553080 ( Dian Tri Raharjo) ‹kelas B>

    ReplyDelete
  5. 201553056_Dhimas Aji Wicaksono_Kelas B

    ReplyDelete
  6. 201553069_NauvalSa'ieduddin_KelasB

    ReplyDelete
  7. 201553064_Ahmad Isnan Wahyudi_KelasB

    ReplyDelete
  8. 201553071_Muhammad Nafi'Uddin_Kelas B

    ReplyDelete
  9. 201553079 _ Andrianus_kelas B

    ReplyDelete
  10. 201553061_Subekti Nur Wahyudi_Kelas B

    ReplyDelete
  11. 201553078_Angga Khoirir Riza_Kelas B

    ReplyDelete
  12. 201553051_Fat'hul Umam_kelas B

    ReplyDelete
  13. 201553072_Milasita Mangesthiningtyas_B

    ReplyDelete
  14. 201553065_Nisrina Ainiyatul Munawaroh_B

    ReplyDelete
  15. This comment has been removed by the author.

    ReplyDelete
  16. 201553044-Agus Dwi ismawan-Kelas_B

    ReplyDelete
  17. 201553063_Oktova Aulia Chasan_Kelas_B

    ReplyDelete
  18. This comment has been removed by the author.

    ReplyDelete
  19. 201553011-Arsya Yoga Pratama-kelas B

    ReplyDelete
  20. 201553049-Shinta Ulfiana-kelas C

    ReplyDelete
  21. 201553050-Rita Suryana-Kelas C

    ReplyDelete
  22. This comment has been removed by the author.

    ReplyDelete
  23. 201553074-M. Yusuf Noor H.-Kelas C

    ReplyDelete
  24. 201553074-M. Yusuf Noor H.-Kelas C

    ReplyDelete
  25. 201553038-Bevi maulida k.-kelas C

    ReplyDelete
  26. 201553073-Galeh Raka Siwi-Kelas C

    ReplyDelete
  27. 201553018-Fiyyalailatun Nayyiroh-Kelas A

    ReplyDelete
  28. 201553034-Dimas Iswar B- Kelas A

    ReplyDelete
  29. 201553034-Dimas Iswar B- Kelas A

    ReplyDelete
  30. 201553004_Bela Herwati Ningsih_Kelas C

    ReplyDelete
  31. 201553007-Jihan Nisrina-Kelas A

    ReplyDelete
  32. 201553038-Bevi maulida k.-kelas C

    ReplyDelete
  33. 201553022-Dessy Muharfianti Putri-Kelas A

    ReplyDelete
  34. 201553037-Yuli Irmawati-Kelas A

    ReplyDelete
  35. 201553030_Risa Erlinawati_Kelas C

    ReplyDelete
  36. 201553001_Farih Daroini_Kelas C

    ReplyDelete
  37. 201553013_Iman Ardhi Prabowo_C

    ReplyDelete
  38. 201553017_Novita Dwi Andriyani_Kelas A

    ReplyDelete
  39. This comment has been removed by the author.

    ReplyDelete
  40. 201553003_mohammadkamalalfitra_b

    ReplyDelete
  41. 201553024_fidiana sekar rizqi_A

    ReplyDelete
  42. 201553026_RINA KHOIRUNNISA'_A

    ReplyDelete
  43. This comment has been removed by the author.

    ReplyDelete
  44. 201553033_SYAIFUL BAHRI BAYUDA PRADANI_B

    ReplyDelete