Page 1 of 2 12 LastLast
Results 1 to 15 of 26
  1. #1
    Join Date
    Jul 2009
    Posts
    10

    Exclamation Help needed: RESORT RESERVATION SYSTEM DATABASE

    hey everyone. nice forum. our IT teacher has asked us to make a databse for a couple of topics like student, stock, hospitality, resort reservation, video/book library etc. i consulted my tution teacher and he recommended me to do resort reservation system. but i have to idea how to carry on the project smoothly. he on shows the current work done

    tourist info
    t_id
    t_first name
    t_surname
    Gender
    DOB
    nationality
    passport ID
    contact no
    VISA
    blood group [opt]
    med status

    Guide info
    [nearly same as tourist info]
    addditional: qualifications

    room info
    t_id
    bed no
    facilitys
    rent amount
    no of persons

    flight info
    country
    company
    class

    depature info
    dep date
    dep time
    dep loc

    arrival info
    [same as depature info]

    can you guys please give me sopme more infomations. please urgent

    i have to finish this at a dead line of 29 july 09


    regards
    nxym

  2. #2
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    Quote Originally Posted by nxym
    but i have to idea how to carry on the project smoothly
    You need to think about how all the data is going to join up between the different tables (at the moment it doesn't), what are the primary keys and what are the field types. Then just create the database, create the tables and perhaps insert some sample data.

    Quote Originally Posted by nxym
    please urgent. i have to finish this at a dead line of 29 july 09
    Then I guess you should of started this a little earlier. I'm unsure whether English is your first language but, if it is, then I'd suggest you get someone else to type out your homework.

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    h'm 5 days to go before hand in date
    I'll pass
    I'd rather be riding on the Tiger 800 or the Norton

  4. #4
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    Oh come on, it'll be 5 packed days of fun.

  5. #5
    Join Date
    Jul 2009
    Posts
    10
    no dudes. not fully completely. i have to finish up to queries in the database. all the tables. records and queries are supposed to be finished until 29 july. they will show it to my parents that day with my note book.

  6. #6
    Join Date
    Jul 2009
    Posts
    10
    does any of you have a sample of resort reservation i could rely on?????????

  7. #7
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by nxym
    does any of you have a sample of resort reservation i could rely on?????????
    Ah - plagiarism. We love that round here. Rather a sizable project for NZDF though so I'm afraid I'll have to pass.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  8. #8
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by nxym
    does any of you have a sample of resort reservation i could rely on?????????
    there are dozens that you can adapt here: Library of Free Data Models from DatabaseAnswers.org

    note: if you know what you're doing, you can adapt one of them easily (but then you wouldn't really need to adapt one, you'd just write your own), but if you don't know what you're doing, your adaptation will have errors, and if you don't adapt it, it can be traced

    good luck
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  9. #9
    Join Date
    Jul 2009
    Posts
    10
    @r937 i checked the link earlier. but cant find any for RESORT. and i am not gonna do fraud projects. i just wanna refer it. i nearly searched the whole internet for a sample but none. could any of you guys give me a few more tables and fields other than given on the first post. i could get help with my tuition teacher and do queries and other stuff

  10. #10
    Join Date
    Jul 2009
    Posts
    10
    and can anyone give me a big list of validation rules???

  11. #11
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by nxym
    i could get help with my tuition teacher
    that sounds like an excellent idea!!!

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  12. #12
    Join Date
    Jul 2009
    Posts
    10
    how about some list of validation rules???????????????????

  13. #13
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by nxym
    how about some list of validation rules???????????????????
    petulance will get you noplace fast
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  14. #14
    Join Date
    Jul 2009
    Posts
    10
    i am not jokin around dude.

  15. #15
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by nxym
    i am not jokin around dude.
    yeah, i know, a deadline will do that to you

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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