desing for odering rooms in university

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
hrubos
Forum Contributor
Posts: 172
Joined: Sat Oct 07, 2006 3:44 pm

desing for odering rooms in university

Post by hrubos »

I have to do a database about reservation in a university but my teacher require that i have to have mor 7 tables and they are complicated.I have wrote about it but i stiil want to give some idea form everybody in forum :

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 don't know i can post this here ,if i have wrong,i am really sorry !!!
hrubos
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

Are those the seven tables you were told to have or did you come up with them? What is with the number 7?
timvw
DevNet Master
Posts: 4897
Joined: Mon Jan 19, 2004 11:11 pm
Location: Leuven, Belgium

Post by timvw »

I find it hard to understand that:

- the attribute 'room_number' is really an attribute of a student... (Since only the students that life more than 180km from the school can have one...)
- each room has a student_number...

and so on...
hrubos
Forum Contributor
Posts: 172
Joined: Sat Oct 07, 2006 3:44 pm

Post by hrubos »

timvw wrote:I find it hard to understand that:

- the attribute 'room_number' is really an attribute of a student... (Since only the students that life more than 180km from the school can have one...)
- each room has a student_number...

and so on...
-oh,it is a mistake ,number_student
-@Everal : follow my teacher, i have to design a complicated database ,and more tables more mraks i can get.But i have tried, i only can design this.I want to ask somebody who can have other idea for my database and so evrybody can check agian for me that i designed well???
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

If you are getting marks on how complicated your database is, I think your teacher needs to rethink his approach :wink:. Seriously, a good design implies a less complicated database structure. It can still be richa and robust, but it should be somewhat simple to understand.

One of the more complex database structures I worked on involved a vehicle management system that allowed for varying levels of administration. It had 38 tables (with each table no bigger than 8 fields) and was set up in a pretty normalized way. How can you apply a normalized, multi-level access control structure to your chosen theme in a way that makes it simple, yet complex enough to earn high marks?
hrubos
Forum Contributor
Posts: 172
Joined: Sat Oct 07, 2006 3:44 pm

Post by hrubos »

or after i have done, do u have think about other problem about odering in hostel of school?
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

Easiest thing to do is look at:
  • What will folks be doing
  • Who is doing what
  • How are they doing it
  • When will they do it
Those few questions by themselves should be able to help get you started on a good number of tables.
User avatar
Christopher
Site Administrator
Posts: 13596
Joined: Wed Aug 25, 2004 7:54 pm
Location: New York, NY, US

Re: desing for odering rooms in university

Post by Christopher »

Well ... so far this project has two requirements that I can identify:

1. I have to do a database about reservation in a university
2. my teacher require that i have to have mor 7 tables and they are complicated.

We also have some possible concepts like Room, Worker, Reservation, Rent, Traveller and Room Type. These could be objects or properties or attributes.

And some rules like "because if students want to have room in school,they have to live longer than 180km from school to their house and "sotimes traveller can rent room for a short time"

So hrubos, can you explain to us all the things that this application is supposed to do?
(#10850)
Post Reply