Results 1 to 7 of 7
  1. #1
    Join Date
    Jun 2009
    Posts
    4

    Need help to decompose.....

    Hey, I am just starting off with this concecpt.
    If you have two Relationships that Many to Many how would you decompose the two?

    First One:
    Employee
    EmployeeID as PK
    LastName
    FirstName
    StreetAddress
    City

    Second One:
    Job
    JobTitle as PK
    Description

  2. #2
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    Regards need help to decompose : best bet is not to be buried as this reduces the number of scavengers that can get to you, once they're finished then it will be insects, bacteria and fungi that will clear up the rest. If you have to be buried then don't go down to deep as temprature and oxygen levels decrease as you go down. An interesting novel on the subject is Being Dead by Jim Crace.

    Regards tables : this doesn't look like a many to many relationship to me - why do you think it is. Can you print the whole coursework?

  3. #3
    Join Date
    Jun 2009
    Posts
    4
    It is a practice question which was given to us... Yes it does state it is a Many to Many relationship.
    Thanks

  4. #4
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    I can understand how many employees might have the same job title but is it likely that one employee would have many job titles?

    What have you been taught to do if it is many to many?

  5. #5
    Join Date
    Jun 2009
    Posts
    4
    Many-to-Many (M:N) relationships must be decomposed into a new entity and two relationships
    Thats all I know....

  6. #6
    Join Date
    Jun 2009
    Posts
    4
    Actually I think i got it!
    Thanks!

  7. #7
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    my mission is complete

Posting Permissions

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