Section outline

  • Week 5

    • Students must
      Mark as done

      QUIZ 1

    • quiz icon
      Quiz 1 Question Section O-2
      Students must
      View

      • Syllabus: Lecture 1 to 4
      • MCQ question
      • Marks: 15
      • Time: 45 minutes

    • Lecture 8

      Learning Outcome:
      • Scenario to ER model conversion Example,  


    • url icon
      Scenario to ERD Conversion Section O-2 (Google meet discussion) Part 2 URL
      Not available unless: You belong to DBMS Section O-2
    • resource icon
      Exercise on Scenario to ERD Conversion (Slide)-2 File
    • url icon
      Use LucidChart to implement your work in 10 Minutes URL
    • forum icon
      Exercise On ERD model Forum
      Students must
      View
      Make forum posts: 1

      Construct an ER Diagram for Company having the following details :

      • Company organized into DEPARTMENT. Each department has unique name and a particular employee who manages the department. Start date for the manager is recorded. Department may have several locations.
      • A department controls a number of PROJECT. Projects have a unique name, number, and a single location.
      • Company's EMPLOYEE name, ssno, address, salary, and birth date are recorded. An employee is assigned to one department, but may work for several projects (not necessarily controlled by her dept). Number of hours/week an employee works on each project is recorded; The immediate supervisor for the employee.
      • Employee's DEPENDENT are tracked for health insurance purposes (dependent name, birthdate, relationship to employee).