[benoz]

Hi All...
I need your help please
this is my first project and I am trying to do the analysis after I did my homework in gathering the information

I will attach my work ok?

[mike_bike_kite]

If you attach the original assignment and supply your teacher's email address we should be able to improve the turnaround speed of your homework and get fewer errors.

Mike

[benoz]

Thanks Mike
Actualy I don't have teacher ,that's y am here
you r my teacher now ... it's something related to my work

[pootle flump]

What's your project benoz and what have you got so far?

[mike_bike_kite]

Traditionally people post information saying what their problem is and what they’ve done towards a solution. We then all chip in with wildly different solutions until things finally degrade into religious arguments over how to approach database design. This works well most of the time and keeps us all entertained.

In your particular case do you want us to post solutions first and then you can tell us what the problem is later?

Mike

[pootle flump]

That sounds like a good game.

[mike_bike_kite]

I'm going to go for an EAV solution because this is obviously the type of scenario where EAV is going to shine in the long run.

[Pat Phelan]

At least unti we get some sort of problem specification or a solution to examine, I'm going to contend that there is no solution and that the rest of you are futilely attempting to solve a problem that both doesn't exist and can't be solved.

-PatP

[mike_bike_kite]

That's a very defeatist attitude - at least I've proposed a solution.

[Pat Phelan]

True, but it is important to recognize limits, both your own and in a problem specification.

-PatP

[georgev]

benoz - if you ask us a specific question, we can help you asnwer it.
If you ask us to do the work for you, you are sadly mistaken.

Poots, have you lost your commission fee from Tony Marston or something - I expected a link dump but was sadly mistaken!

There is a solution, but it requires 4 dimensional modelling and the tools for this have yet to be made publically available - you might be able to get a CTP from MSDN, but I doubt it.

[healdem]

being an aging stick in the mud I'm going to propose a rollodex

I think thats should trump the EAV model in terms of usefullness, and as a bonus it even works when the power goes out. And as a final benefit, come der tag and civilisation fails you can always set fire to it and get some use from the design (however briefly)

[benoz]

I am sorry ,I am new in the fourms
any way
here is the file

conceptual.jpg - 0.90MB

1-you will find relation between the contact details table and the invitations table
the idea is: each contact can invite number of contacts from the same table
that means its a recursive relation But i need also to determine the event and the date!!!
so I decided to put these data in another table
now I have host and guests... should I write it as it is ( contact ID) twice??
what's the right solution

2- Every contact from the contact details table has type and every type in the contact types table might be linked to more than 1 contact
that means its M-to-M relation
I've added Contact-Details-Types table between them
is it OK???

thanks

[benoz]

my hand writing is baaaad
don't mention that I knew it

[mike_bike_kite]

My eyes aren't good enough to read your assignment but where do you get the information that states "every contact from the contact details table has type" and later "every type in the contact types table might be linked to more than 1 contact" - I'm just curious.