1 / 10

ERD (Entity Relationship Diagram) Diagram Hubungan Entitas

ERD (Entity Relationship Diagram) Diagram Hubungan Entitas. An entity-relationship diagram (ERD) is a specialized graphic that illustrates the relationships between entities in a database ( adalah grafis khusus yang menggambarkan hubungan antara entitas dalam database )

asta
Télécharger la présentation

ERD (Entity Relationship Diagram) Diagram Hubungan Entitas

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. ERD (Entity Relationship Diagram)Diagram Hubungan Entitas

  2. An entity-relationship diagram (ERD) is a specialized graphic that illustrates the relationships between entities in a database • (adalah grafis khusus yang menggambarkan hubungan antara entitas dalam database) • (http://databases.about.com/cs/specificproducts/g/er.htm) • An entity-relationship diagram is a data modeling technique that creates a graphical representation of the entities, and the relationships between entities, within an information system. • (Diagram Hubungan Entitas adalah teknik pemodelan data yang menciptakan representasi grafis dari entitas, dan hubungan antara entitas, dalam suatu sistem informasi) • (http://searchcrm.techtarget.com/definition/entity-relationship-diagram) • An entity relationship diagram is a graphical documentation of a database's tables, fields, and the relationships between tables in the database. • (Sebuah diagram hubungan entitas adalah dokumentasi grafis dari tabel-tabel database, field, dan hubungan antara tabel dalam database) • (http://wiki.answers.com/Q/What_is_an_Entity_Relationship_diagram_for_library_management_database) • The entity is a person, object, place or event for which data is collected. • The relationship is the interaction between the entities. • Bergunauntukmemodelkan data yang akandisimpan/diolahsehingga pihak pengembang dan pengguna bisa sama-sama mengecek kelengkapannya. • Sesudahmemodelkan data dalambentuk ERD, selanjutnya diagram tersebutakandipetakanuntukmenjadi database.

  3. ERD often use symbols to represent three different types of information. Boxes are commonly used to represent entities: Diamonds are normally used to represent relationships and Ovals are used to represent attributes.

  4. SOURCE: http://erw.dsi.unimi.it/diagram.html

  5. Source: http://creately.com/diagram/example/h7iin2581/E-R+Diagram+for+Hotel+management+system

  6. SOURCE: http://creately.com/diagram/example/h7cw0wrb1/+E-R+Diagram+of+Library+Management+System

  7. Kembali, dan Mengembalikan Pinjaman Suatu saat pinjam koleksi lagi Perjalanan ke Perpustakaan Perjalanan Pulang Pustakawan Memproses Peminjaman Koleksi Pustakwan Melaksanakan Jasa/Layanan Proses Jasa: Layanan Perpustakaan

  8. KOLEKSI BIB DATA BIB_ID CREATING DATE ISBN/ISSN LANGUAGE CREATOR CLASS_NUMBER AUTHOR TITLE STAT. OF RESP. GMD EDITION PUBLICATION PHYSICAL DES. SERIES TITLE GENERAL NOTE SUBJECT HEADINGS OTHER AUTHORS ITEM(S) ITEM_ID CREATOR TITLE LOCATION ITEM TYPE ITEM STAT. DATE ADDED NOTE PRICE SOURCE INVENT. NUMBER SUPPLIER CURR.USE TOTAL.USE STATUS STATUS CODES STATUS DESC. ITEM TYPE DESCRIPTION LOAN PERIOD GRACE PERIOD CHARGES DAILY/HOURLY RENT/FINE MINIMUM FINE MAXIMUM FINE FIRST NOTICE NOTICE FREQUENCY MAX # OF NOTICES PRIORITY LEVEL MAX # RENEWALS HOLD EXTENT RECALL EXTENT RECALL MIN. LOAN RECALL PERIOD RECALL RATE PROCESSING FEE LOST FUND DAMAGED FUND HOLD FEE-PLACE HOLD FEE-PICKUP HOLD FEE-EXPIRE USER TYPE DESCRIPTION PATRON PRIORITY ADDRESS CHECK EXPIRATION LOAN PERIOD GRACE PERIOD CHARGE RATE FIRST NOTICE NOTICE FREQUENCY MAX # OF NOTICES MAX # OUT MAX CLAIM RTNS MAX UNPAID FINES MAX # OVERDUES MAX # RENEWALS CARD FEE PTYPE AT ROLLOVER HOLD FEE-PLACE HOLD FEE-PICKUP HOLD FEE-EXPIRE LOAN TRANSACTION USER NAME BARCODE BORROWING DATE DUE DATE TITLE BARCODE ITEM NOTE AUTHOR PERSONAL NAME NUMERATION DATE ASS. WITH NAME DATE OF WORK FULLER FORM OF NAME ANGGOTA USER/MEMBER USER_ID NAME HOME ADDRESS CITY ZIP CODE TELEPHONE BARCODE E-MAL USER_TYPE USER_STAT. DATE ADD./MOD/EXP GURDIAN NAME HOME ADDRESS CITY ZIP CODE CURR. USE TOTAL USE NOTE PUBLICATION PUB. PLACE PUBLISHER PUB. DATE SUBJECT TOPICAL TERM GEN. SUBDIVISON CHON. SUBDIVISION GEO. SUBDIVISION SOURCE OF SUBJECT TERM

  9. KOLEKSI akses OPAC BIB DATA BIB_ID CREATING DATE ISBN/ISSN LANGUAGE CREATOR CLASS_NUMBER AUTHOR TITLE STAT. OF RESP. GMD EDITION PUBLICATION PHYSICAL DES. SERIES TITLE GENERAL NOTE SUBJECT HEADINGS OTHER AUTHORS ITEM(S) ITEM_ID CREATOR TITLE LOCATION ITEM TYPE ITEM STAT. DATE ADDED NOTE PRICE SOURCE INVENT. NUMBER SUPPLIER CURR.USE TOTAL.USE STATUS STATUS CODES STATUS DESC. ITEM TYPE DESCRIPTION LOAN PERIOD GRACE PERIOD CHARGES DAILY/HOURLY RENT/FINE MINIMUM FINE MAXIMUM FINE FIRST NOTICE NOTICE FREQUENCY MAX # OF NOTICES PRIORITY LEVEL MAX # RENEWALS HOLD EXTENT RECALL EXTENT RECALL MIN. LOAN RECALL PERIOD RECALL RATE PROCESSING FEE LOST FUND DAMAGED FUND HOLD FEE-PLACE HOLD FEE-PICKUP HOLD FEE-EXPIRE akses USER TYPE DESCRIPTION PATRON PRIORITY ADDRESS CHECK EXPIRATION LOAN PERIOD GRACE PERIOD CHARGE RATE FIRST NOTICE NOTICE FREQUENCY MAX # OF NOTICES MAX # OUT MAX CLAIM RTNS MAX UNPAID FINES MAX # OVERDUES MAX # RENEWALS CARD FEE PTYPE AT ROLLOVER HOLD FEE-PLACE HOLD FEE-PICKUP HOLD FEE-EXPIRE LOAN TRANSACTION USER NAME BARCODE BORROWING DATE DUE DATE TITLE BARCODE ITEM NOTE AUTHOR PERSONAL NAME NUMERATION DATE ASS. WITH NAME DATE OF WORK FULLER FORM OF NAME ANGGOTA USER/MEMBER USER_ID NAME HOME ADDRESS CITY ZIP CODE TELEPHONE BARCODE E-MAL USER_TYPE USER_STAT. DATE ADD./MOD/EXP GURDIAN NAME HOME ADDRESS CITY ZIP CODE CURR. USE TOTAL USE NOTE PUBLICATION PUB. PLACE PUBLISHER PUB. DATE SUBJECT TOPICAL TERM GEN. SUBDIVISON CHON. SUBDIVISION GEO. SUBDIVISION SOURCE OF SUBJECT TERM

More Related