Need help to decompose.....

warriorvx · #1 (**permalink**) 06-03-09, 12:02

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

mike_bike_kite · #2 (**permalink**) 06-03-09, 12:45

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?

warriorvx · #3 (**permalink**) 06-03-09, 13:09

It is a practice question which was given to us... Yes it does state it is a Many to Many relationship.
Thanks

mike_bike_kite · #4 (**permalink**) 06-03-09, 13:46

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?