Tugas 1 Basis Data : ERD

Summary

In this video, Adik NPS Kusuma, a student from Universitas Terbuka, explains a database design task for managing academic data in a university system. The task involves creating an Entity-Relationship Diagram (ERD) for a system where students enroll in courses taught by lecturers. The relationships between students, courses, and lecturers are detailed, with a many-to-many relationship between students and courses via a 'KRS' (Kartu Rencana Studi) table. The video also covers the one-to-many relationship between courses and lecturers, showcasing a structured approach to organizing academic data efficiently.

Takeaways

• 😀 The video explains a database assignment focusing on how students enroll in courses offered by a university, emphasizing relationships between students, courses, and professors.
• 😀 Students must take at least one course but can enroll in multiple courses within one semester.
• 😀 Each course can only be taught by one professor, but professors can teach multiple courses.
• 😀 Three main entities identified in the case: students, courses, and professors.
• 😀 Attributes for students include name, address, and program of study (prodi).
• 😀 Courses have attributes like course code, course name, and number of credit hours (SKS).
• 😀 Professors are identified by their faculty and their unique identification number.
• 😀 Relationships include a 'many-to-many' relationship between students and courses, represented by a 'KRS' (Kartu Rencana Studi, or Study Plan Card).
• 😀 The 'KRS' stores additional information like the semester and academic year.
• 😀 A 'one-to-many' relationship exists between professors and courses, with each professor teaching multiple courses, but each course having only one professor.
• 😀 The relational structure of the system enables efficient management of academic data, connecting students to courses and linking professors to courses, facilitating organized academic processes.

Q & A

What is the main focus of the video presented by Adik NPS Kusuma?

The main focus of the video is explaining a database assignment related to an Entity Relationship Diagram (ERD) and its application for a university system that tracks students, courses, and lecturers.

What are the three primary entities identified in the database design?

The three primary entities identified are 'Mahasiswa' (Student), 'Mata Kuliah' (Course), and 'Dosen' (Lecturer).

What attributes are associated with the 'Mahasiswa' (Student) entity?

The 'Mahasiswa' entity has attributes such as 'name', 'address', and 'prodi' (program).

What attributes are associated with the 'Mata Kuliah' (Course) entity?

The 'Mata Kuliah' entity has attributes like 'course code', 'course name', and 'SKS' (credit points).

What attributes are associated with the 'Dosen' (Lecturer) entity?

The 'Dosen' entity has attributes like 'Dosen ID', 'name', and 'faculty'.

What kind of relationship exists between 'Mahasiswa' and 'Mata Kuliah'?

The relationship between 'Mahasiswa' and 'Mata Kuliah' is a 'Many-to-Many' relationship, facilitated through the 'KRS' (Kartu Rencana Studi) table.

What is the role of the 'KRS' table in this database design?

The 'KRS' table serves as the junction table that links students to the courses they take, while also storing additional information such as semester and academic year.

What relationship exists between 'Mata Kuliah' and 'Dosen'?

The relationship between 'Mata Kuliah' and 'Dosen' is a 'One-to-Many' relationship, where each course is taught by one lecturer, but a lecturer can teach multiple courses.

Can you explain the example involving the student 'Budi'?

In the example, the student 'Budi' is enrolled in two courses: 'Basis Data' (taught by Lecturer A) and 'Algoritma' (taught by Lecturer B). This results in two separate records in the 'KRS' table, each linking 'Budi' to a different course and its respective lecturer.

What is the significance of the database design in managing academic data?

The database design ensures that academic data is organized efficiently, making it easier to manage student enrollments, track courses, and associate each course with its lecturer. It supports processes such as grade management and scheduling.