Hi All
How to set up tables to the following
Group of Colleges
The Examination Halls
I want to work for this book halls / hours / days / week
All alone on the College
College of Veterinary Medicine, for example where the halls / 1/2/3/4/5/6 / Hall 1 reserved from 9 am on Sunday for the day 08/10/2012

Hi,

Not sure if this will cover all your requirements, but it could be a start:

tblColleges
CollegeID, PK
CollegeName
etc...

tblCollegeHalls
CollegeHallID, PK
CollegeID, FK
HallName
etc...

tblHallReservations
ReservationID, PK
CollegeHallID, FK
StartDate
EndDate
etc...

Just my 2 cents...

You need a table of colleges. Make sure you include the CollegeID as the Primary Key.
You also need a table of ExaminationHalls. Again, make sure you include the ExaminationHallID as the Primary Key.

You may also need a table of Examinations. Again,make sure you include the ExaminationID as the Primary Key.

Then you'll need a junction table that relates the colleges, examinations, and ExaminationHalls. Include the date and time fields for each scheduled exam.

That ought to be enough to start.

Hi
theDBguy
And how my son relations


Hi
GroverParkGeorge

End not only reservation but exams those halls

I'm afraid I don't understand your question.

The relationships are indicated by the tags "PK" (primary key) and "FK" (foreign key).

Just my 2 cents...

An example of one college only

I want to put the information in the field of the hall
For example, took advantage of the Hall by Dr. Miller

theDBguy

Yesterday, a witness Shirk film I came to my mind

Thanks!

I'll leave you in the capable hands of the DB Guy.

GroverParkGeorge

I think that
Painting a beautiful GroverPark and dangerous
Greetings to you

Hi,


You shouldn't worry about how to display the information yet. The first thing to do is get the table structures correct before worrying about how users will use the database.

If you're not familiar with relational database designs, take a look at this Wiki article on Normalization and Crystal's Access Basics tutorials.

Just my 2 cents...

Hi Shirk

DBguy

I could not set up tables
I read the topic did not understand something

Hi DBguy


Can I do to impose referential integrity
With respect to the three tables above.

Yes, you can, and it's actually highly recommended.

Have you read Crystal's tutorials above?

Hi DBguy

I have read the lessons
I understand the little ones

Okay, that's good to hear. Start designing your tables and then post what you come up with, and then we'll give you some comments about it.

Sounds good?

Hi DBguy

OK OK
I am ready

So, after you build your tables, post them here so we can take a look and give you feedback.

Hi DBguy

This is an example of the database and I explained in the file PDF
Also what I need

Any other ideas you

Okay, that's a good start but you're not quite there yet. Remember to always have a primary key in your tables and use the Autonumber field for it. Using a text field for a primary key is not really a good idea.

In your reservations table, I would suggest storing both the date and time in the StartDate and EndDate fields. That way, you won't need an extra field called "Time," which is a *reserve* word by the way, which could cause problems later on. Also, try to put a few more data in the tables for testing to make sure we can see the whole picture.

Go back and take a look at the table structure I recommended earlier.

Just my 2 cents...

Hi All
DBguy

The first tables do not work well
But by the time I want to make reservation for the room already so I added the time

If you are referring to the table structure I recommended, please explain why you think they don't work in your case.



I recommend adding the time to the dates instead of in a separate field. For example, the StartDate would have something like 5/18/2012 8:00 PM, and the EndDate would have something like 5/18/2012 9:00 PM for a 1-Hour reservation.

Just my 2 cents...

Show me Cubuma error when adding a second College

Hi,


Not sure what error you were getting but I tried to add a second college and did not get any error.

On a different note, the CollegeID field in your table tblCollegeHalls should be a Number instead of Text. Same thing with the field CollegeHallID in tblHallReservations, it should be a Number, not a Text.

After you fix those, go back to your Relationship Window and set Referential Integrity for all your relationships.

These steps are in Chapter 4 of Crystal's Access Basics Tutorials.

Just my 2 cents...

Hi All
I will do as explained to me /DBguy
And I also thank Michael for helping me
Thank you very much for all


Another question
Is it possible to work each College Table

ummm... if you've been following the advice here, you will have only ONE College Table.

Please explain your question, and perhaps post a description of your current (or proposed) table structure.

Hi azhar,




We are all happy to help.



As John pointed out, it's best to keep all your College info in only one table.

Good luck with your project.

Hi All
Thank you all very much