Tuesday, April 3, 2018

PEMROGRAMAN SQL TUGAS 4

April 03, 2018 – by 63


1.      Susun tabel Pembelian

Field
Type
Size
Ket
Idbeli
Varchar
10
Primary Key
Kdbrg
Varchar
10
Foreign Key
Kdsupp
Varchar
10
Foreign Key
Tglbeli
Date
8

Jmlbeli
Int
8




2.      Isi Data

BL001
Brg001
S003
12 Jan 2018
100
BL002
Brg001
S003
2 Feb 2018
150
BL003
Brg002
S002
7 Feb 2018
1100
BL004
Brg003
S001
26 Feb 2018
250
BL005
Brg002
S002
2 Maret 2018
750



3.      Tampilkan semua data pembelian, dan nama barang

4.      Tampilkan semua data pembelian, nama barang, nama supplier

5.      Tampilkan nama barang, nama supplier, alamat kantor supplier yang pembelian sebelum bulan Maret

6.      Tampilkan kode beli, Nama Barang, Jumlah Barang & Total harga

7.      Tampilkan Nama Barang, harga barangm jumlah barang, total harga yang pembelian sebelum tanggal 15 Februari

8.      Tampilkan Kode barang, nama barang, nama supplier urut berdasarkan total harga dari yang terkecil ke yang terbesar

9.      Tampilkan Jumlah barang dan total harga per bulan Februari

10.  Tampilkan semua transaksi di tahun 2018

63 comments:

  1. Umar_rudinApril 4, 2018 at 12:41 AM

    Nama : Muhammad Umar Rudin
    Nim : 201653078
    Kelas : C

    ReplyDelete
  2. UnknownApril 4, 2018 at 1:29 AM

    Nama : Irvan Ariyanto
    Nim : 201653124
    Kelas : C

    ReplyDelete
  3. UnknownApril 4, 2018 at 1:34 AM

    Nama :Dave Andre Setiawan
    NIM :201653094
    Kelas:C

    ReplyDelete
  4. UnknownApril 4, 2018 at 1:55 AM

    Nama : Khoirin Nida
    NIM : 201653087
    Kelas : C

    ReplyDelete
  5. UnknownApril 4, 2018 at 2:03 AM

    Nama : Ragil Raka Laksmana]
    NIM : 201653083
    Kelas : C

    ReplyDelete
  6. UnknownApril 4, 2018 at 2:03 AM

    Nama : Ricky adhitya
    NIM : 201653128
    Kelas :C

    ReplyDelete
  7. Andini Dwi FebriyantiApril 4, 2018 at 2:04 AM

    Nama : Andini Dwi Febriyanti
    Nim : 201653084
    Kelas : C

    ReplyDelete
  8. deaenno.blogspot.comApril 4, 2018 at 2:06 AM

    Nama : Maulidya Rahma
    NIM : 201653066
    Kelas : C

    ReplyDelete
  9. UnknownApril 4, 2018 at 2:06 AM

    Nama : habib maulana R
    NIM : 201653051
    Kelas : C

    ReplyDelete
  10. UnknownApril 4, 2018 at 2:06 AM

    Nama :ichsan ade s
    Nim :201653091
    Kelas :c

    ReplyDelete
  11. UnknownApril 4, 2018 at 2:07 AM

    Nama : Alifah Yuliana
    Nim : 201653092
    Kelas: C

    ReplyDelete
  12. UnknownApril 4, 2018 at 2:08 AM

    Nama : Yusuf Mubarok
    Nim : 201653059
    Kelas : C

    ReplyDelete
  13. A'I_DarkwoodApril 4, 2018 at 2:10 AM

    nama:dawud fatahillah
    nim:201653079
    kelas:c

    ReplyDelete
  14. UnknownApril 4, 2018 at 2:10 AM

    Nama : Reza Caroline
    NIM : 201653098
    Kelas :C

    ReplyDelete
  15. Ulin NuhaApril 4, 2018 at 2:11 AM

    Nama : Muhammad Ulin Nuha
    Nim : 201653053
    Kelas : C

    ReplyDelete
  16. UnknownApril 4, 2018 at 2:11 AM

    Nama : Moch. Febrian Syahbana
    NIM : 201653054
    Kelas : C

    ReplyDelete
  17. UnknownApril 4, 2018 at 2:12 AM

    Nama : Trihatmojo Adi P
    Nim :201453113
    Kelas :C

    ReplyDelete
  18. UnknownApril 4, 2018 at 2:13 AM

    Nama : Vina Variana
    Nim : 201653075
    Kelas : C

    ReplyDelete
  19. UnknownApril 4, 2018 at 2:13 AM

    Bonang Harto Wironoto
    201453139
    C

    ReplyDelete
  20. Saputra FirdausApril 4, 2018 at 2:14 AM

    Nama : Saputra Firdaus
    Nim : 201653103
    Kelas :C

    ReplyDelete
  21. Saputra FirdausApril 4, 2018 at 2:15 AM

    Nama : Alfitasari
    Nim :201653101
    Kelas :C

    ReplyDelete
  22. Saputra FirdausApril 4, 2018 at 2:15 AM

    Nama : Ade Amelia
    Nim :201653097
    Kelas :C

    ReplyDelete
  23. F1ll10April 4, 2018 at 2:16 AM

    Nama : yudha aris k.
    Nim : 201653047
    Kelas : C

    ReplyDelete
  24. UnknownApril 4, 2018 at 2:16 AM

    Nama: Anis Maghfiroh
    Nim: 201653080
    Kelas : C

    ReplyDelete
  25. LovaneoApril 4, 2018 at 2:17 AM

    Nama: Lovaneo monia shambayon
    Nim: 201653057
    Kelas:C

    ReplyDelete
  26. UnknownApril 4, 2018 at 2:31 AM

    nama : rizal emir pohan
    nim ; 201653133
    kelas : c

    ReplyDelete
  27. Zainal ArifinApril 4, 2018 at 2:43 AM

    Presensi
    Nama: ZAINAL ARIFIN
    Nim: 201653070
    Kelas:C

    ReplyDelete
  28. UnknownApril 4, 2018 at 11:02 PM

    Nama : Muhammad Ali Firdaus
    NIM : 201653058
    Kelas : PSQL (C)

    ReplyDelete
  29. UnknownApril 5, 2018 at 6:26 PM

    Nama : Shella Rachma Octaviana
    NIM : 201653009
    Kelas: PSQL(D)

    ReplyDelete
  30. UnknownApril 5, 2018 at 11:39 PM

    Nama :Andika Prabowo
    nim :201653019
    Kelas :PSQL (D)

    ReplyDelete
  31. UnknownApril 6, 2018 at 6:09 PM

    Nama : Mila Siti Rukmana
    Nim : 201653048
    Kelas : C

    ReplyDelete
  32. Mochamad Alvin ArdikusumaApril 9, 2018 at 8:04 PM

    Nama : Mochamad Alvin Ardikusuma
    Kelas : A
    NIM : 201653031

    ReplyDelete
  33. UnknownApril 9, 2018 at 8:07 PM

    Nim : 201653060
    Nama : Angga Prayogi
    Kelas : A

    ReplyDelete
  34. andrew antoApril 9, 2018 at 8:08 PM

    NAMA : Andrew Anto
    NIM : 201653027
    KELAS : A

    ReplyDelete
  35. abdul hafid alaudinApril 9, 2018 at 8:08 PM

    Nama : Abdul Hafid Alaudin
    Kelas : A
    Nim : 201653030

    ReplyDelete
  36. ddddddddddApril 9, 2018 at 8:09 PM

    Nama : Muhammad yusuf Aji Wijaya
    Nim : 201653055
    Kelas : A

    ReplyDelete
  37. N3wBi3April 9, 2018 at 8:12 PM

    Nama : Choirul Anam
    Nim : 201653028
    Kelas : A

    ReplyDelete
  38. cah patiApril 9, 2018 at 8:19 PM

    Nama : Yongki Rudianto
    Nim : 201653040
    Kelas : A

    ReplyDelete
  39. AKHI KHOIRIL ANAMApril 9, 2018 at 9:13 PM

    Nama : Akhi Khoiril Anam
    Nim : 201653033
    Kelas : A

    ReplyDelete
  40. UnknownApril 10, 2018 at 12:50 AM

    Nama : Yusuf Niko Saputra
    Nim. : 201653125
    Kelas: B

    ReplyDelete
  41. GelangApril 10, 2018 at 12:51 AM

    nama : gilang ramadhan
    nim : 201653095
    kelas : B

    ReplyDelete
  42. ibnuabdulazizApril 10, 2018 at 12:52 AM

    Nama: Ibnu Abdul Aziz
    Nim : 201653113
    Kelas : B

    ReplyDelete
  43. rifka dwiApril 10, 2018 at 12:53 AM

    Nama : Rifka Dwi A
    Nim : 201653081
    Kelas: B

    ReplyDelete
  44. UnknownApril 10, 2018 at 12:53 AM

    Nama :monika qatrun nada shabiha
    Nim 201653086
    Kelas : B

    ReplyDelete
  45. UnknownApril 10, 2018 at 12:53 AM

    Nama : Luthfi Abdurrohman
    NIM : 201653132
    KELAS : B

    ReplyDelete
  46. UnknownApril 10, 2018 at 12:53 AM

    Muhammad Rodhi
    201653071
    B

    ReplyDelete
  47. AnonymousApril 10, 2018 at 12:54 AM

    Nama : Suti Rahayu
    Nim : 201653111
    kelas B

    ReplyDelete
  48. UnknownApril 10, 2018 at 12:54 AM

    Nama : Irfan Maulana
    Nim :201653131
    kelas :B

    ReplyDelete
  49. UnknownApril 10, 2018 at 12:54 AM

    Nama : Hakim wahyu s
    Kelas: B
    Nim : 201653102

    ReplyDelete
  50. AnonymousApril 10, 2018 at 12:54 AM

    Nama :Ahmad andi saputro
    Nim :201653130
    Kelas:B

    ReplyDelete
  51. Zuhairina Izzatu AmaliaApril 10, 2018 at 12:55 AM

    Nama : Zuhairina Izzatu Amalia
    NIM : 201653126
    Kelas: B

    ReplyDelete
  52. UnknownApril 10, 2018 at 12:55 AM

    Nama: elfrida aprillyana
    Nim : 201453109
    Kelas : B

    ReplyDelete
  53. UnknownApril 10, 2018 at 12:56 AM

    NAMA : AFRIANTITO
    NIM : 201653073
    KELAS :B


    ReplyDelete
  54. meizora putriApril 10, 2018 at 12:56 AM

    Nama : Meizora Putri
    Nim : 201653110
    Kelas : B

    ReplyDelete
  55. UnknownApril 10, 2018 at 1:02 AM

    NAMA : ELFRIDA APRILLYANA
    NIM : 201453109
    KELAS : B

    ReplyDelete
  56. zulfaahApril 10, 2018 at 1:04 AM

    Nama : Zulfa Himmatul Ulya
    Nim 201653052
    Kelas : B

    ReplyDelete
  57. RatihzuliaApril 10, 2018 at 1:06 AM

    Nama : Ratih Zulia Pratiwi
    NIM : 201653104
    Kelas : B

    ReplyDelete
  58. zufiApril 10, 2018 at 1:16 AM

    Nama : Zufi Maghriza
    Nim. : 201653089
    Kelas : B

    ReplyDelete
  59. Noor RohmadApril 10, 2018 at 1:17 AM

    Nama : Noor Rohmad
    NIM : 201653088
    Kelas : B

    ReplyDelete
  60. UnknownApril 10, 2018 at 1:19 AM

    Nama : Rizki PW
    NIM : 201653108
    Kelas : B

    ReplyDelete
  61. UnknownApril 10, 2018 at 1:21 AM

    Nama : naning Yuyun
    NIM : 201653107
    Kelas : B

    ReplyDelete
  62. Johana Dwi ApriliaApril 11, 2018 at 11:59 PM

    Nama : Johana Dwi
    Nim : 201653100
    B

    ReplyDelete
  63. Hasan olshopApril 19, 2018 at 6:44 PM

    Nama : Khasan musthofa
    Nim : 201653042
    Kelas : D

    ReplyDelete

Subscribe to: Post Comments (Atom)