Page 1 of 2 12 LastLast
Results 1 to 15 of 16

Thread: db

  1. #1
    Join Date
    Dec 2011
    Posts
    8

    db

    Design a database for developing the following system.

    1. The details of various resource persons contacted for various events at institute are to be stored at a central database by the respective coordinators from their respective places.
    2. There should be facility to change the details if required.
    3. A facility to view the resource persons details in some order (like technical experts, management experts, communication skills experts, etc).
    4. A facility to view the details in different orders (gender wise, year wise, events wise, etc).
    5. Sending e-cards to the resource person on their birthdays, new year, etc.

    could any one one help me out??
    plzzzz

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by raiyeee View Post
    could any one one help me out??
    plzzzz
    of course

    what was your question?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    certainly
    try:
    Google
    I'm sure one of these could meet your requirements
    I'd rather be riding on the Tiger 800 or the Norton

  4. #4
    Join Date
    Dec 2011
    Posts
    8

    database design

    Design a database for developing the following system.

    1. The details of various resource persons contacted for various events at institute are to be stored at a central database by the respective coordinators from their respective places.
    2. There should be facility to change the details if required.
    3. A facility to view the resource persons details in some order (like technical experts, management experts, communication skills experts, etc).
    4. A facility to view the details in different orders (gender wise, year wise, events wise, etc).
    5. Sending e-cards to the resource person on their birthdays, new year, etc.

  5. #5
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by raiyeee View Post
    Design a database for developing the following system.
    this looks exactly like post #1 in this thread

    reposting the homework assignment is ~not~ going to induce anyone to do the work for you

    how about you try to do it yourself, post what you come up with, and then ask if you have a specific question
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  6. #6
    Join Date
    Dec 2011
    Posts
    8

    db

    hi...
    i want to design the database...
    in order to design the database
    1.we need to gather the information
    2.draw the E-R diagrams
    3.convert E-R diagrams to relational model..
    and finally this must be in a normalized form...
    is it correct??
    or is there any extra information to follow in order to design a database??
    Last edited by raiyeee; 12-25-11 at 09:57.

  7. #7
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    yes, that's correct

    "gather the information" seems to be complete, i.e. it's the assignment as you posted it, right?

    okay, so you're on step 2, draw the ER diagram
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  8. #8
    Join Date
    Dec 2011
    Posts
    8

    db

    thnq...for ur reply...

  9. #9
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    ur wlcm...for urs too
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  10. #10
    Join Date
    Dec 2011
    Posts
    8

    db

    hi..
    i hv a doubt...can anyone plz tel me??

    what is the use of associative entity...??
    whn to use this??

    and

    can an entity hv 2 relationships??
    and those two relationships can relates single entity??

  11. #11
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    what is the use of associative entity...??

    to associate other entities in a complex relationship

    whn to use this??

    whenever you want to associate entities in a complex relationship

    can an entity hv 2 relationships??

    yes

    and those two relationships can relates single entity??

    yes


    aren't you glad we cleared that up, eh
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  12. #12
    Join Date
    Dec 2011
    Posts
    8

    db

    sry..iam not cleared with that answer....

    can u plz gv me the example ..whn and where to use associative entity??

    is associative entity itself relation and entity??
    Last edited by raiyeee; 12-27-11 at 08:00.

  13. #13
    Join Date
    Dec 2011
    Posts
    8

    hi

    Hi Everybody,
    Today, Some one asked me this question. I just made myself to say him back. But i was not satisfied with my answer. Now i am asking the same question here. I hope i will get proper response for this question. India has a large number of engineers and scientists graduating every year. There is a concern of lack of exposure to local problems and technological innovation to solve them. What would you say to solve this issue? What role can the corporate sector play to help drive solve local technological problems? What is your opinion about?

  14. #14
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by raiyeee View Post
    can u plz gv me the example ..whn and where to use associative entity??
    Code:
    CREATE TABLE one_entity
    ( id  INTEGER NOT NULL PRIMARY KEY
    , foo VARCHAR(9) NOT NULL
    );
    
    CREATE TABLE two_entity
    ( id  INTEGER NOT NULL PRIMARY KEY
    , bar VARCHAR(37) NOT NULL
    );
    
    CREATE TABLE one_two_associative_entity
    ( one_id INTEGER NOT NULL
    , two_id INTEGER NOT NULL 
    , FOREIGN KEY ( one_id ) REFERENCES one_entity ( id )
    , FOREIGN KEY ( two_id ) REFERENCES two_entity ( id )
    , PRIMARY KEY ( one_id, two_id )
    , INDEX buckle_my_shoe ( two_id, one_id )
    , startdate DATETIME NOT NULL
    );
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  15. #15
    Join Date
    Dec 2011
    Posts
    8

    db

    thnq vry much

Posting Permissions

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