1 / 14

BASIS DATA

BASIS DATA. Oleh Izzatul Umami , S.Ko m. Basis Data. Basis : Markas , Tata urutan , Gudang

keaton
Download Presentation

BASIS DATA

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 OlehIzzatulUmami, S.Kom

  2. Basis Data • Basis : Markas, Tata urutan, Gudang • Data : RepresentasiFaktaDuniaNyata, yang mewakilisuatuobjeksepertimanusia( pegawai, pembeli), hewan, peristiwa, sertaobjek yang tersimpanbaik yang mewakilibunyi, gambardls.

  3. Gambaran Database Disk

  4. OperasiDasar Basis Data • Create Database • Drop Database ( Delete Database ) • Create Table • Drop Or Delete Table • Insert File, field in the Table • Retrieve/Search File (in Field in then Table) • Update File • Delete File

  5. Penerapan Basis DataFungsional • Kepegawaian • Pergudangan ( Inventory ) • Akuntansi • Reservasi ( Perhotelan, KeretaApi ) • Layananpelanggan ( Custumer Care )

  6. Penerapan Basis Data DalamOrganisasi • PerBankan • Asuransi • RumahSakit • ProdusenBarang • IndustriManufaktur • Pendidikan / sekolah

  7. Komponen Data Base • PerangkatKeras ( Hardware ) • SistemOperasi ( operating Sistem ) • Basis Data ( Data Base ) • Sistem ( Aplikasi/ PerangkatLunak ) Pengelola Basis Data ( DBMS ) • Pemakai ( User ) • Aplikasi ( PerangkatLunak Lain BersifatOpsional )Dbase, Borland-Interbase, Ms-Access, MS-SQLServer, Oracle

  8. Level Abstraksi data Memberikanfasilitasantarmuka (interface) yang berbasis user oriented 1. Level Fisik ( Pysical Level ) Level terendahdalampenyimpanan data, ygtersimpandalamhimpunan bit data 2. Level Lojik/ Konseptual ( Conceptual Level ) Yang menggambarkan data yang sebenarnya, sertascrfungsionaltersimpandalam basis data. 3. Level Penampakan ( View Level ) level tertinggi, yang manapenunjukan data hanyaakandiperolehsebagianoleh user.

  9. Bahasa Basis Data ( Database Language) • Data Definition Language ( DDL) Struktur yang mewakilidanmenggambarkanbentukkesuluruhan Basis Data, yang ditujukkandenganbahasa yang khusus, hasilkompilasiDDl, yang tersimpandalam file disebutdenganKamus Data. • Data manipulation Language ( DML ) Penggunakanbahasastruktur data baik insert maupunproses table yang lain, yang bertujuanuntukmengakses data denganlebihmudah, baikdenganproseduralmaupun non prosedural.

  10. Penerapan Basis Data • Model Basis Data Relational sering pula disebut MODEL RELATIONAL atau BASIS DATA RELATIONAL, yang pertama kali dikenalkanolehE.F. Codd

  11. PenerapanDalam Access 2007 NamaTabel Nama Field Type Data

  12. Terapan Basis Data SQL • Set rs = db.Execute("select * from Member where id_Member= '" + UCase(txtkd_member.Text) + "' ") • If rs.RecordCount > 0 Then • Set rs = db.Execute("update Member set Nama='" & UCase(txtnm_Member.Text) & "',Alamat='" & UCase(txtAlamat.Text) & "',No_Telp_Rmh='" & txtTelpRmh.Text & "', No_HP='" & TxtNoHP.Text & "', No_KTP='" & txtKTP.Text & "' WHERE id_Member='" & txtkd_member.Text & "' ") • Else • Set rs = db.Execute("insert into Member values('" & UCase(txtkd_member.Text) & "', '" & UCase(txtnm_Member.Text) & "','" & UCase(txtAlamat.Text) & "','" & txtTelpRmh.Text & "','" & TxtNoHP.Text & "','" & txtKTP.Text & "')") • End If

  13. Normalisasi Data 1. Atributtabel field-field yang merupakanbagiandari tabel yang dibuatdalam database 2. Key danAtributDeskriptif • Super Key • Candidate Key • Key Primer ( Primary Key )

  14. Aplikasi Basis Data

More Related