1 / 18

BASIS DATA II 3 sks

BASIS DATA II 3 sks. Jenjang Sarjana. Prodi Teknik Informatika Jurusan Teknik Infromatika FST-IST AKPRIND Yogyakarta. Deskripsi. Perkuliahan 13 tatap muka selama 1 semester Pengantar Sekilas Tentang Mata Kuliah Basis Data II Materi Referensi Tata cara perkuliahan Evaluasi

matia
Download Presentation

BASIS DATA II 3 sks

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. BASIS DATA II 3 sks Jenjang Sarjana Prodi Teknik Informatika Jurusan Teknik Infromatika FST-IST AKPRIND Yogyakarta

  2. Deskripsi • Perkuliahan • 13 tatap muka selama 1 semester • Pengantar • Sekilas Tentang Mata Kuliah Basis Data II • Materi • Referensi • Tata cara perkuliahan • Evaluasi • Tugas  50% • UTS  20% • UAS  20% • Presensi  10%

  3. Materi • Pemodelan sistem • Perancangan BD dg teknik ER_M • Perancangan BD dg teknik normalisasi • Integrasi perancangan BD u/ SIM • Optimalisasi rancangan BD • Paket-paket DBMS • Bugs system • Studi Kasus • Proyek Akhir (Presentasi Tugas 04)

  4. Pustaka • Atre, S., 1980, Database : Structured Techniques For Design, Performance And Management With Case Study, Canada, John Wiley & Sons, Inc. • Austing, R.H., 1988, File Organization And Acces, USA, DC Heat & Co. • Courtney, J.F. Jr. and Paradice, D.B., 1988, Database Systems For Management, 1st edition, USA, Times Mirror / Mosby College Publishing • Date, C.J., 1995, An Introduction To Database Systems, Adisson Wesley Publishing, Co., Inc. • Elmasri, R. and Navathe, S., 1994, Fundamental Of Databases System, 2nd edition, Redwood City, The Benjamin Cummings Publishing, Co., Inc. • Harbon, T.R., 1988, File Systems, USA, Prentice Hall, Inc. • Korth, H.F. and Silberschatz, A., 1986, Database Systems Concept, USA, Mc.Graw-Hill International, Co. • Kroenke, D.M., 1983, Database Processing: Fundamental, Design, Implementations, 2nd edition, Chicago, Science Research Associates, Inc.

  5. Kruglinski, D., 1986, Data Base Managament Systems, USA, Mc.Graw-Hill International, Co. • Lomis, E.S., 1989, Data Management And File Structures, USA, Prentice Hall, Inc. • Martin, J., 1975, Computer Database Organizations, parth I, New Jersey, Prentice-Hall, Inc. • Martin, J., 1976, Computer Database Organizations, parth II, New Jersey, Prentice-Hall, Inc. • Parsaye, K., Chignell, M., Khoshafian, S., Wong, H., 1989, Intelligent Databases, Nanada, Jhon Wiley & Sons, Inc. • Stamper, D., 1990, Database Design And Management An Applied Approach, International edition, Singapore, Mc.Graw-Hill International, Co. • Tharp, A.L., 1988, File Organization And Processing, Singapore, John Wiley & Sons, Inc. • Ulman, J.D., 1982, Principles Of Database System, Rockville, Computer Press, Inc. • Wiederhold, G., 1988, Database Design, 2nd edition, Singapore, Mc.Graw-Hill International, Co.

  6. Kompetensi MK • Setelah mengikuti MK ini mahasiswa mampu • melakukan perancangan BD sesuai dg konsep BD yg benar & mengembangkan aplikasi menggunakan DBMS & bhs pemrograman ttt

  7. Pokok Bahasan 01 • Pokok Bahasan • Pendahuluan • Sub Pokok Bahasan • Pengantar • Kaitan MK BD 2 & kurikulum scr keseluruhan 2. Pandangan thd BD 3. DBMS 4. Pengetahuan yg relevan • Kompetensi • Stl mengikuti kuliah ini mhs mampu menjelaskan perbedaan pandangan thd BD, DBMS, pengetahuan yg relevan

  8. Pokok Bahasan 02 • Pokok Bahasan • Pemodelan sistem • Sub Pokok Bahasan 1. Pemodelan sistem 2. Studi kasus pemodelan sistem dg DAD 3. Kaitan antara DAD, HIPO, desain I/P/O & dialog • Kompetensi • Stl mengikuti kuliah ini mhs mampu menjelaskan & menggambarkan model sistem

  9. Pokok Bahasan 03 • Pokok Bahasan • Perancangan BD dg teknik ER_M • Sub Pokok Bahasan 1. Penggambaran ER_D 2. Konversi ER_D ke model relational • Kompetensi • Stl mengikuti kuliah ini mhs mampu memanfatkan model BD ER_M u/ perancangan BD

  10. Pokok Bahasan 04 • Pokok Bahasan • Perancangan BD dg teknik normalisasi • Sub Pokok Bahasan 1. Bentuk-bentuk normal 2. Proses normalisasi • Kompetensi • Stl mengikuti kuliah ini mhs mampu memanfaatkan teknik normalisasi u/ perancangan BD

  11. Pokok Bahasan 05 • Pokok Bahasan • Integrasi perancangan BD u/ SI • Sub Pokok Bahasan 1. Rancangan BD pd tkt sub sistem 2. Integrasi rancangan BD u/ SI • Kompetensi • Stl mengikuti kuliah ini mhs mampu memahami perancangan BD u/ SI

  12. Pokok Bahasan 06 • Pokok Bahasan • Optimalisasi rancangan BD • Sub Pokok Bahasan 1. Pengkodean data 2. Standarisasi data 3. Penanganan data transaksi 4. Validasi I, P, O 5. Integritas data • Kompetensi • Stl mengikuti kuliah ini mhs mampu melakukan optimalisasi rancangan BD

  13. Pokok Bahasan 07 • Pokok Bahasan • Bug Systems • Sub Pokok Bahasan 1. Mengenal bug systems • Redundancy, Inconsistency, Data locking • Delete logic/psysic, Indexing 2. Penanganan bug systems • Kompetensi • Stl mengikuti kuliah ini mhs mampu memahami & mengatasi bug system

  14. Pokok Bahasan 08 • Pokok Bahasan • Studi kasus • Sub Pokok Bahasan • Contoh-contoh studi kasus • Kompetensi • Stl mengikuti kuliah ini mhs mampu merancang BD scr benar menggunakan paket DBMS text base/DOS

  15. Pokok Bahasan 9 • Pokok Bahasan • Proyek Akhir • Sub Pokok Bahasan • Presentasi proyek Akhir • Kompetensi • Stl mengikuti kuliah ini mhs mampu merancang BD scr benar menggunakan paket DBMS visual/windows

  16. ?

  17. Tugas - Tugas

  18. Proyek Akhir

More Related