Script for Group 6 College ER diagram Activity- DBMS

// https://www.canva.com/design/DAFxIwCjids/D-DKhcIdHI7wwSRat0eO1w/edit?utm_content=DAFxIwCjids&utm_campaign=designshare&utm_medium=link2&utm_source=sharebutton



//Introduction:
Good day, everyone. We are Group6, and today, we're thrilled to present the Entity-Relationship (ER) diagram for our college database. This diagram plays a pivotal role in organizing and visualizing the relationships between entities within our database.

//Entities:
In our database, we've identified four key entities: Department, Course, Instructor, and Student. Each entity plays a unique role and holds various attributes to store essential information.+

//Relationships and Cardinality:
Let's go into the relationships connecting these entities, as well as the cardinality which describes the nature of these connections.

    Department and Course (Mandatory Many):
    First, we have the relationship between Department and Course. Each department can offer any number of courses, which is represented by the Mandatory Many cardinality.

    Instructor and Department (Mandatory Many):
    The second relationship, Instructor and Department, shows that many instructors can work in a department, but each instructor can work in only one department. This Mandatory Many cardinality keeps our database organized.

    Instructor and Course (Optional Many):
    Moving on, the Instructor and Course relationship indicates that an instructor can take any number of courses, but each course can only be taken by one instructor. This is an Optional Many relationship.

    Student and Course (Mandatory Many):
    Lastly, the Student and Course relationship demonstrates that students can enroll in any number of courses, and each course can have many students. This 'Mandatory Many' connection is crucial for managing student enrollments.

//Attributes:
Now, let's briefly touch upon the attributes that help define these entities.

    Department attributes are include 'dept_name' and 'dept_adrs.' it means department name and address

    Course attributes consist of 'course_name,' 'course_code,' and 'course_time.'

    Instructor attributes  within this category are 'prof_name' and 'prof_id' as attributes.

    Student: We used composite entities are characterized by attributes for 'student_name' (comprising first_name, mid_name, and last_name), then followed by simple attribute which is 'birthdate,' 'student_loc,' and 'student_cont.#' . So that's all


//Outro
As we come to the end of our presentation. We hope you now have a clear understanding of the Entity-Relationship (ER) diagram for our college database.If you have any further questions related to our database or this presentation, please feel free to ask. We appreciate your time and attention today. Thank you!