Monday, March 6, 2017

Tugas Pemrograman SQL Kelas A,B,C

March 06, 2017 – by 67
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
Firman001@gmail.com
Sup002
Joko Waluyo
07/03/1979
Jl. Bumi Wonosari
024-889772
Pria
Jwal@gmail.com
Sup003
Ilham Wahid
19/8/1982
Jl. Dersalam
0291-889324
Pria
Wahid@gmail.com
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. UnknownMarch 6, 2017 at 7:57 PM

    (201553045)-Fredo Maulana Putra-klas B

    ReplyDelete
  2. UnknownMarch 6, 2017 at 8:01 PM

    201553066-Erna Zulianti-kelas B

    ReplyDelete
  3. UnknownMarch 6, 2017 at 8:06 PM

    201553043-muh suhartomi-kelas b

    ReplyDelete
  4. YUK.... Ke Godong...March 6, 2017 at 8:10 PM

    201553080 ( Dian Tri Raharjo) ‹kelas B>

    ReplyDelete
  5. UnknownMarch 6, 2017 at 8:14 PM

    201553056_Dhimas Aji Wicaksono_Kelas B

    ReplyDelete
  6. nauvalMarch 6, 2017 at 8:20 PM

    201553069_NauvalSa'ieduddin_KelasB

    ReplyDelete
  7. go_blogingMarch 6, 2017 at 8:22 PM

    201553064_Ahmad Isnan Wahyudi_KelasB

    ReplyDelete
  8. M. Nafi'uddinMarch 6, 2017 at 8:22 PM

    201553071_Muhammad Nafi'Uddin_Kelas B

    ReplyDelete
  9. UnknownMarch 6, 2017 at 8:27 PM

    201553079 _ Andrianus_kelas B

    ReplyDelete
  10. Subekti Nur WahyudiMarch 6, 2017 at 8:28 PM

    201553061_Subekti Nur Wahyudi_Kelas B

    ReplyDelete
  11. UnknownMarch 6, 2017 at 8:28 PM

    201553078_Angga Khoirir Riza_Kelas B

    ReplyDelete
  12. UnknownMarch 6, 2017 at 8:38 PM

    201553051_Fat'hul Umam_kelas B

    ReplyDelete
  13. UnknownMarch 6, 2017 at 8:43 PM

    201553060_Sovia_B

    ReplyDelete
  14. Nikita Blog InformationMarch 6, 2017 at 8:55 PM

    201553076_Nikita Tri Ari Santi_B

    ReplyDelete
  15. UnknownMarch 6, 2017 at 9:02 PM

    201553047_Rofiyatun_B

    ReplyDelete
  16. LalalalaaaaMarch 6, 2017 at 9:04 PM

    201553072_Milasita Mangesthiningtyas_B

    ReplyDelete
  17. UnknownMarch 6, 2017 at 9:15 PM

    201553065_Nisrina Ainiyatul Munawaroh_B

    ReplyDelete
  18. UnknownMarch 6, 2017 at 10:42 PM

    201553067_Umi Rahayu_B

    ReplyDelete
  19. UnknownMarch 6, 2017 at 10:58 PM

    201553075_MUNTARAM_B

    ReplyDelete
  20. UnknownMarch 6, 2017 at 11:10 PM

    This comment has been removed by the author.

    ReplyDelete
  21. UnknownMarch 6, 2017 at 11:11 PM

    201553044-Agus Dwi ismawan-Kelas_B

    ReplyDelete
  22. UnknownMarch 6, 2017 at 11:49 PM

    201553063_Oktova Aulia Chasan_Kelas_B

    ReplyDelete
  23. Luthfi Hakim \DC/March 6, 2017 at 11:53 PM

    201553052 Ahmad Luthfi Hakim B

    ReplyDelete
  24. m10March 7, 2017 at 6:26 AM

    This comment has been removed by the author.

    ReplyDelete
  25. Ladang TutorialMarch 7, 2017 at 10:56 AM

    201553011-Arsya Yoga Pratama-kelas B

    ReplyDelete
  26. Lina AnjelinaMarch 7, 2017 at 7:09 PM

    201553058-Lina Anjelina-kelas C

    ReplyDelete
  27. UnknownMarch 7, 2017 at 10:07 PM

    201553049-Shinta Ulfiana-kelas C

    ReplyDelete
  28. UnknownMarch 7, 2017 at 10:07 PM

    201553050-Rita Suryana-Kelas C

    ReplyDelete
  29. UnknownMarch 7, 2017 at 10:10 PM

    This comment has been removed by the author.

    ReplyDelete
  30. Rahasia_IlahiMarch 7, 2017 at 10:14 PM

    201553068-Yulimar Astutik-Kelas C

    ReplyDelete
  31. UnknownMarch 7, 2017 at 11:43 PM

    201553074-M. Yusuf Noor H.-Kelas C

    ReplyDelete
  32. UnknownMarch 7, 2017 at 11:44 PM

    201553074-M. Yusuf Noor H.-Kelas C

    ReplyDelete
  33. My OpinionMarch 8, 2017 at 5:38 PM

    201553038-Bevi maulida k.-kelas C

    ReplyDelete
  34. UnknownMarch 8, 2017 at 5:38 PM

    201553073-Galeh Raka Siwi-Kelas C

    ReplyDelete
  35. UnknownMarch 8, 2017 at 5:39 PM

    201553018-Fiyyalailatun Nayyiroh-Kelas A

    ReplyDelete
  36. UnknownMarch 8, 2017 at 5:40 PM

    201553034-Dimas Iswar B- Kelas A

    ReplyDelete
  37. UnknownMarch 8, 2017 at 5:41 PM

    201553034-Dimas Iswar B- Kelas A

    ReplyDelete
  38. Bela SnowkyMarch 8, 2017 at 5:41 PM

    201553004_Bela Herwati Ningsih_Kelas C

    ReplyDelete
  39. UnknownMarch 8, 2017 at 5:43 PM

    201553007-Jihan Nisrina-Kelas A

    ReplyDelete
  40. My OpinionMarch 8, 2017 at 5:43 PM

    201553038-Bevi maulida k.-kelas C

    ReplyDelete
  41. anisa blogMarch 8, 2017 at 5:44 PM

    201553028-Anisa Ulya-Kelas A

    ReplyDelete
  42. UnknownMarch 8, 2017 at 5:46 PM

    201553022-Dessy Muharfianti Putri-Kelas A

    ReplyDelete
  43. UnknownMarch 8, 2017 at 5:48 PM

    201553037-Yuli Irmawati-Kelas A

    ReplyDelete
  44. UnknownMarch 8, 2017 at 5:49 PM

    201553008_Yusiana Rahma_B

    ReplyDelete
  45. ERLINA NOFIANTIMarch 8, 2017 at 5:50 PM

    201553006_Erlina Nofianti_C

    ReplyDelete
  46. UnknownMarch 8, 2017 at 5:55 PM

    201553023_Fita Choiyanti_C

    ReplyDelete
  47. UnknownMarch 8, 2017 at 5:55 PM

    201553041_nurul Mashfufah_C

    ReplyDelete
  48. IchaRisaMarch 8, 2017 at 5:56 PM

    201553030_Risa Erlinawati_Kelas C

    ReplyDelete
  49. DMarch 8, 2017 at 5:56 PM

    201553001_Farih Daroini_Kelas C

    ReplyDelete
  50. linanovianaMarch 8, 2017 at 6:18 PM

    201553036_Lina Noviana_Kelas A

    ReplyDelete
  51. AnonymousMarch 8, 2017 at 6:20 PM

    201553013_Iman Ardhi Prabowo_C

    ReplyDelete
  52. http://kursuskomputerpati.blogspot.com/?m=1March 8, 2017 at 6:30 PM

    201553015_Toni Alfiyan_Kelas C

    ReplyDelete
  53. Agung Dwi AriyantoMarch 8, 2017 at 6:44 PM

    201553021_Agung Dwi Ariyanto_B

    ReplyDelete
  54. triyaadzani@gmail.comMarch 8, 2017 at 6:57 PM

    201553020_Triya Adzani Maulidina_A

    ReplyDelete
  55. UnknownMarch 8, 2017 at 7:00 PM

    201553017_Novita Dwi Andriyani_Kelas A

    ReplyDelete
  56. 201553032labibashroriMarch 8, 2017 at 7:19 PM

    201553032_Labib Ashrori_B

    ReplyDelete
  57. Muhammad IlhamMarch 8, 2017 at 7:22 PM

    201553027_Muhammad Ilham_Kelas_B

    ReplyDelete
  58. UnknownMarch 8, 2017 at 9:56 PM

    This comment has been removed by the author.

    ReplyDelete
  59. UnknownMarch 8, 2017 at 9:56 PM

    201553003_mohammadkamalalfitra_b

    ReplyDelete
  60. UnknownMarch 8, 2017 at 9:57 PM

    201553014_Farid Yuliyanto_B

    ReplyDelete
  61. UnknownMarch 8, 2017 at 10:08 PM

    201553024_fidiana sekar rizqi_A

    ReplyDelete
  62. RinakhMarch 8, 2017 at 10:10 PM

    201553026_RINA KHOIRUNNISA'_A

    ReplyDelete
  63. RinakhMarch 8, 2017 at 10:10 PM

    This comment has been removed by the author.

    ReplyDelete
  64. UnknownMarch 8, 2017 at 11:14 PM

    201553033_SYAIFUL BAHRI BAYUDA PRADANI_B

    ReplyDelete
  65. UnknownMarch 9, 2017 at 12:09 AM

    201553002_Rusyana Sari_C

    ReplyDelete
  66. Bayu AfrianMarch 9, 2017 at 2:08 AM

    201553012_BAyu Afrian_A

    ReplyDelete
  67. symbiansMarch 9, 2017 at 8:28 AM

    201553025_Luqman Rosid_C

    ReplyDelete

Subscribe to: Post Comments (Atom)