Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2011
    Posts
    1

    ER Diagram help.....

    Hey guys am in real need of help here i need to create a single Entity-Relationship diagram for the following:

    StaffNo
    Staff_Start_Date
    First_Name
    Last_Name
    DOB
    Home_Address
    Home_Tel
    MobileNo
    WorkNo
    Gender
    NatInsNo
    Staff_Salary

    Course_Name
    CourseNo
    Course_Start
    Course_End

    Staff_ID, First_Name, Surname, DOB, Address, Tel, Mobile_No, Work_No, Gender, National_Insurance, Salary,(CourseNo, Course_Name, Course_Start, Course_End))

    Personal = (StaffID, First_Name, Last_Name, DOB, Address, Tel, Mobile, Gender, NatInsNo)
    Contact = (First_Name, Last_Name, Address, Tel, Mobile,)
    Course = (CourseNo, Course_Name, Course_Start, Course_End)
    Salary = (NatInsNo, First_Name, Last_Name, Address)

    To simplify the diagram, it says only show entities, relationships, primary and foreign key attributes,Identify the main relationships between entities described in part represent each relationship in your ER diagram, clearly labelling each relationship.State the degree of each of the relationships described in part Decompose any many to many relationships, replacing them with new entity types and relationships


    i just don't know were to start though

    any help would be great

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by lfc1825 View Post
    i just don't know were to start though
    start by identifying your main entities

    get a piece of paper and draw a box for each entity

    thenh identify the relationships between your entities

    draw a line between related boxes on the diagram

    then if you have any further questions, show us what you've drawn first
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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