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. 201553061_Subekti Nur Wahyudi_Kelas B

    ReplyDelete
  10. 201553078_Angga Khoirir Riza_Kelas B

    ReplyDelete
  11. 201553051_Fat'hul Umam_kelas B

    ReplyDelete
  12. 201553072_Milasita Mangesthiningtyas_B

    ReplyDelete
  13. 201553065_Nisrina Ainiyatul Munawaroh_B

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

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

    ReplyDelete
  16. 201553011-Arsya Yoga Pratama-kelas B

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

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

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

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

    ReplyDelete
  21. 201553018-Fiyyalailatun Nayyiroh-Kelas A

    ReplyDelete
  22. 201553004_Bela Herwati Ningsih_Kelas C

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

    ReplyDelete
  24. 201553022-Dessy Muharfianti Putri-Kelas A

    ReplyDelete
  25. 201553001_Farih Daroini_Kelas C

    ReplyDelete
  26. 201553015_Toni Alfiyan_Kelas C

    ReplyDelete
  27. 201553017_Novita Dwi Andriyani_Kelas A

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

    ReplyDelete
  29. 201553003_mohammadkamalalfitra_b

    ReplyDelete
  30. 201553026_RINA KHOIRUNNISA'_A

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

    ReplyDelete
  32. 201553033_SYAIFUL BAHRI BAYUDA PRADANI_B

    ReplyDelete