SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Member
    Join Date
    Feb 2005
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Can sumone helpt me with this Entity Relation Diagram?

    Jus want to know if im doing this right... how many tables do i need for this.. and the names of the tables

    heres what she says to do...


    -----------------------------------------------------------------------------------------------------------------------
    Entity – Relationship Diagram.





    Using the following business case assumptions – create an E-R diagram with cardinality and conditionality that would satisfy these requirements.



    A company has a number of employees. The attributes of EMPLOYEE include Employee_ID (identifier), Name, Address and Birthdate. The company also has several projects. Attributes of PROJECT include Project_ID (identifier), Project_Name, and Start-Date.



    Each employee may be assigned to one or more projects, or may not be assigned to a project. A project must have at least one employee assigned and may have any number of employees assigned. An employee’s billing rate may vary by project and the company wishes to record the applicable billing-Rate for each employee assigned to a particular project.

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,350
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    sorry, we won't do your homework

    if you show us what you've done so far, and ask specific questions, you might get some feedback and suggestions, but nobody's going to do your work for you

    harsh, i know, eh
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    SitePoint Member
    Join Date
    Feb 2005
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Its not homework....



    sumone pm me with the help i need.. i will email u anything u need need!!1


    from software to music...

  4. #4
    SitePoint Member
    Join Date
    Feb 2005
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    so far i have 3 Tables


    Employees....Projectes...And Billing Rates is that right?


Bookmarks

Posting Permissions

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