Bab 6 LRS PDF

## BAB 6 LOGICAL RECORD STRUCTURED ### A. Pokok Bahasan - Logical Record Structured ### B. Tujuan Belajar - Memahami Logical Record Structured - Mentransformasi Entity Relationship Diagram menjadi Logical Record Structured. ### C. Dasar Teori - Implementasi ERD menghasilkan Logical Record Structu...

## BAB 6 LOGICAL RECORD STRUCTURED ### A. Pokok Bahasan - Logical Record Structured ### B. Tujuan Belajar - Memahami Logical Record Structured - Mentransformasi Entity Relationship Diagram menjadi Logical Record Structured. ### C. Dasar Teori - Implementasi ERD menghasilkan Logical Record Structured (LRS). - LRS merupakan representasi dari struktur record-record pada tabel yang terbentuk dari hasil relasi antar himpunan entitas. #### 1) One to One - **Sopir:** - IDSopir - Nama - Alamat - **Taksi:** - NoPol - Merk - tipe The image provided shows a relationship diagram, with two entities: **Sopir** and **Taksi**. The relationship is one-to-one which means a Sopir can only drive one Taksi, and a Taksi can only be driven by one Sopir. The LRS results in two tables: Sopir and Taksi. This can be visualized as two tables connected by a shared feature, in the image provided, the shared feature is *IDSopir*. #### 2) One to Many - **Dosen:** - NIP - Nama - Alamat - **Mahasiswa:** - NIM - Nama - Alamat The image provided shows a relationship diagram, with two entities: **Dosen** and **Mahasiswa**. The relationship is one-to-many which means a Dosen can be the Wali for many Mahasiswa, but each Mahasiswa has only one Dosen as their Wali. The LRS results in two tables: Dosen and Mahasiswa. This can be visualized as two tables connected by a shared feature, in the image provided, the shared feature is *NIP*. #### 3) Many to Many - **Dosen:** - NIP - Nama - alamat - **Matakuliah:** - KodeMK - Nama - SKS - **Mahasiswa:** - NIM - Nama - Alamat The image provided shows a relationship diagram, with three entities: **Dosen**, **Mahasiswa** and **Matakuliah**. The relationship is many-to-many which means a Dosen can teach many Matakuliah and a Matakuliah can be taught by many Dosen, and a Mahasiswa can study many Matakuliah and a Matakuliah can be studied by many Mahasiswa. The LRS results in three tables: Dosen, Mahasiswa and Matakuliah. This can be visualized as three tables connected by shared features, in the image provided, the shared features are *NIP* and *NIM*. ### D. Latihan 1. Buatlah Logical Record Structured dari optimasi Entity Relationship Diagram yang anda kerjakan pada latihan bab 5!