Scribd Logo
Upload

Welcome to Scribd!

  • 76K views

    Scenario To ER Diagram - Step by Step Solution

    Uploaded by

    Md Saidur Rahman Kohinoor
    When anyone need to draw a Entity Relationship Diagram from an scenario, then he feel some trouble to organize the whole things. Here, describe step by step to point out the requirement from scenario and effectively draw the ER Diagram.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Scenario To ER Diagram - Step by Step Solution

    Uploaded by

    Md Saidur Rahman Kohinoor
    76K views5 pages
    When anyone need to draw a Entity Relationship Diagram from an scenario, then he feel some trouble to organize the whole things. Here, describe step by step to point out the requirement from scenario and effectively draw the ER Diagram.

    Original Title

    Scenario to ER Diagram- Step by Step Solution

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    When anyone need to draw a Entity Relationship Diagram from an scenario, then he feel some trouble to organize the whole things. Here, describe step by step to point out the requirement from scenario and effectively draw the ER Diagram.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    76K views5 pages

    Scenario To ER Diagram - Step by Step Solution

    Uploaded by

    Md Saidur Rahman Kohinoor
    When anyone need to draw a Entity Relationship Diagram from an scenario, then he feel some trouble to organize the whole things. Here, describe step by step to point out the requirement from scenario and effectively draw the ER Diagram.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 5
    At a glance
    Powered by AI
    The key takeaways are the steps involved in creating an entity relationship diagram (ERD) from a scenario, which include identifying entities, relationships, attributes, primary keys, and drawing the diagram.

    The steps involved in creating an ER diagram from a scenario are: 1) Identify entities 2) Find relationships 3) Draw rough ERD 4) Fill in cardinality 5) Define primary keys 6) Draw key-based ERD 7) Identify attributes 8) Map attributes 9) Draw fully attributed ERD

    The different entity types described in the scenario are: University, Faculty, School, Program, Course, Lecturer, and Student.

    Scenario to ER Diagram: Step by Step solution Example

    The Scenario:
    A University contains many Faculties. The Faculties in turn are divided into several Schools. Each School
    offers numerous programs and each program contains many courses. Lecturers can teach many different
    courses and even the same course numerous times. Courses can also be taught by many lecturers. A
    student is enrolled in only one program but a program can contain many students. Students can be
    enrolled in many courses at the same time and the courses have many students enrolled.

    Step 1 - Identify Entities


    The entities in this scenario are
    University
    Faculty
    School
    Program
    Course
    Lecturer
    Student

    Step 2 - Find relationships


    University Faculty School
    University

    Program Course Lecturer Student

    contains

    Faculty
    School
    Program

    divided
    into
    offers

    employs
    contains
    taken
    by

    Course
    Lecturer
    Student

    taught
    enrolled enrolled

    Step 3 - Draw rough ERD


    SR KohinooR| www.facebook.com/kohinoor11

    Step 4 - Fill in cardinality

    The university contains many faculties


    Each faculty is divided into several schools
    Each school offers numerous programs
    Each program contains many courses
    Each school employs many lecturers
    Lecturers can teach many courses
    Lecturers can teach the same course many times
    Courses can be taught by more than one lecturer
    A student is enrolled in only one program
    Students can be enrolled in many courses at the same time
    Courses have many students enrolled

    SR KohinooR| www.facebook.com/kohinoor11

    Step 5 - Define primary keys


    The primary keys could be
    University University name
    Faculty Faculty name
    School School name
    Program Program code
    Course Course number
    Lecturer Employee number
    Student Student number

    SR KohinooR| www.facebook.com/kohinoor11

    Step 6 - Draw key-based ERD

    In this step any many-to-many relationships have to be eliminated. In the ERD so far
    there are two relationships that fall into this category. They are Lecturer Course and
    Course Student. As you can see Associative entities have been included to rectify the
    situation.

    SR KohinooR| www.facebook.com/kohinoor11

    Step 7 - Identify attributes


    In the scenario there are no attributes indicated, so it is up to the analyst to ascertain
    what data needs to be kept about each particular entity.
    For example other attributes for Lecturer could be

    Employee Name
    Employee Address
    Speciality

    Step 8 - Map attributes


    An example of mapping the attributes would be
    Attribute

    Entity

    Attribute

    Entity

    Employee_name

    Lecturer

    Faculty_name

    Faculty

    Employee_number

    Lecturer

    Student_number

    Student

    Course_number

    Course

    Student_name

    Student

    Step 9 - Draw fully attributes ERD

    Now, add attributes of all entities. This is an example of what all the entities should look
    like when they have been fully attributed.

    <<<<<<<<<<<<<<<<<<<<<<<<<<<<<< Best of Luck >>>>>>>>>>>>>>>>>>>>>>>>>>>>>

    SR KohinooR| www.facebook.com/kohinoor11

    You might also like