Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2012
    Posts
    1

    Post Help in creating E R Diagram

    Dear Members I was trying to create an E R Diagram for question given below, now I am struck in middle. If someone can tell me how to proceed further I will be very thankful to him.

    A project handling organization has persons identified by PER ID and a
    LAST NAME. Persons are assigned to departments identified by DEP NAME. Persons work on projects and each project has a PROJ ID and a PROJ BUDGET. Each project is managed by one department and a department may manage many projects. But a person may work on only some (or none) of the projects in his or her departments. Identify the entities and relationship for this organization and construct an E R diagram


    I have Identified the-
    1- Entities--- Persons, Departments, Project
    2- Atributes of Entities-- Persons( Id Number and Last Name), Departments( Depart_Name), Project (Project_Id, Project_Budjet)
    3-- Relationship-- Person to Department is Many to One because many Persons work in a Department. Project to Department is also Many to one because many projects can be managed by a Department. Person to Project is one to many.

    Have I identified the Entities and Relations right If not please tell where?

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    if person to project is one-to-many, that means that each project can have only one person on it

    does that sound right?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •