Order room in school

I have to design database for odering room in hostel of school.But my teacher require that tere is more 7 tables.Plz who can help to supplement table for mydatabase or who have complete Database script about this problem.
Now i am doing with 5 tables :
1.Room
2.Student
3.Assitant
4.Order
5.Rent

What's assistant and rent for?

It's kind of hard to just make up tables, it's kind of a strict requirement... but your teacher must have some type of structure in mind.

What about employee or something? To accomodate for the cleaning staff?
That might be out of scope of your project though.

I'll shoot out ideas... make sure they're in scope of what your teacher has requested.

1. Room = Room (obviously)
2. Student = Person renting Room
3. Order = Linking students to rooms? (I would call this Room_Student)

4. Room type? = Describe the room

5. University?
6. City?
7. Country?


The difference between Room and Room Type is kind of tricky...
Room would be like a number & floor; where as Room Type could give it some type of name, capacity, area (meters squared), bathroom...

Just some thoughts...

- I agree with you about room a type room
- Why do u think that country and city can be 2 tables, can u show how to build with country a city ?
And i did this ,can you give me some ideas :
1. Room (number_room,number_student,number_worker,number_r oomType)
2. Student (number_room,first name,last name,adress,telefone,condition,reservation) --- because if students want to have room in school,they have to live longer than 180km from school to their house
3. Worker (number_worker,first name,last name,adress,telefone,reservation)
4.Reservation (number_reservation,number_room,number_worker,numb er_traveller,datum number_roomType)
5.Rent(number_rent,number_traveller,number_worker, number_student,reservation,rent day,return day)
6.Traveller(number_traveller,first name,last name,adress,telefone,job,reservation) (sotimes traveller can rent room for a short time)
7.Room_Type(number_roomType,type ,price )

I wish I would give ideas soon !!!
Thanx for help