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

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.

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.

h'm 5 days to go before hand in date
I'll pass

Oh come on, it'll be 5 packed days of fun.

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.

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.

pootle flump ur codings are working excelent.

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

@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

and can anyone give me a big list of validation rules???

that sounds like an excellent idea!!!

how about some list of validation rules???????????????????

petulance will get you noplace fast

i am not jokin around dude.

yeah, i know, a deadline will do that to you