Tugas Membuat ERD

Soal :

 

Anda adalah seorang database administrator di sebuah universitas.Anda harus mendesain ERD tentang mahasiswa yang mengambil mata kuliah. Untuk data mahasiswa harus mencakup profil dan data akademik mahasiswa. Daftar matakuliah seperti kode MK, nama MK, SKS, Semester dan Prodi.

 

 

jawaban  : 

 

Hasil Review Scenario

Conceptual Data Model:
Zoe was about to go into a store to purchase drinks for the birthday party scheduled for that evening. Zoe knows that she needs drinks for 48 people and is expecting the store to accept a check for payment and to provide her with some assistance carrying the product to her car. Zoe wants to have carbonated drinks, non-carbonated drinks, and sugar free drinks. She is expecting to purchase eight six-packs.

Physical Data Model:
Zoe enters the store and discovers the entire drink distribution system is automated. She also discovers that the drinks come in varying package sizes and that she must choose the correct vend-ing option for the products to be disbursed. Drinks are packaged in four-packs, six-packs, and ten-packs.

Aturan dan cara baca ER Diagram menurut Oracle

ERD ( Entity Relationship Diagram) adalah alat untuk diskusi, terutama ketika merancang suatu sistem. Ini memberi Anda dan pelanggan sesuatu untuk bereaksi, memvalidasi, dan memperbaiki.

contoh dari kasus ER diagram yaiut : 
Mahasiswa kadang-kadang terlambat mengembalikan buku, sehingga dikenakan denda. Besarnya denda adalah Rp 500,- per hari keterlambatan. Mahasiswa dianggap terlambat jika mengembalikan buku lebih lama dari 1 minggu.