Results 1 to 15 of 15
  1. #1
    Join Date
    May 2008
    Posts
    4

    conceptual model 4 new system

    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?

  2. #2
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    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

  3. #3
    Join Date
    May 2008
    Posts
    4
    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

  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    What's your project benoz and what have you got so far?

  5. #5
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    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

  6. #6
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    That sounds like a good game.

  7. #7
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    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.

  8. #8
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    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

  9. #9
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    That's a very defeatist attitude - at least I've proposed a solution.

  10. #10
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    True, but it is important to recognize limits, both your own and in a problem specification.

    -PatP

  11. #11
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    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.
    George
    Home | Blog

  12. #12
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    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)
    I'd rather be riding on the Tiger 800 or the Norton

  13. #13
    Join Date
    May 2008
    Posts
    4
    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

  14. #14
    Join Date
    May 2008
    Posts
    4
    my hand writing is baaaad
    don't mention that I knew it

  15. #15
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    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.

Posting Permissions

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