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
desing for odering rooms in university
Moderator: General Moderators
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
-oh,it is a mistake ,number_studenttimvw 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...
-@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???
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
If you are getting marks on how complicated your database is, I think your teacher needs to rethink his approach
. 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?
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?
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
- 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
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?
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)