Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kwacz23
Starting Member
44 Posts |
 Posted - 2012-01-24 : 16:51:14
|
hello.
I have a problem with designing database of system reservation. is that make any sense what I have done below? I have several tables. the main problem for my is the first tables about reservation. I dont know how to connect the 4 tables such as client,reservation,reservation specific, classes and specific classes.
I only need help for designing. I thing I can deal with constraints.
If my description is not clear please ask I will answer
tables look like:
First table: User
user_id-PK
Firstname
last name
address
city
phone
Second: Reservation
Reservation_id-PK
User_id-FK
status_id FK
dataOfReservation
Third statusOFreservation
status_id PK
name
4-reservation of specific classes
reservation_id FK
specific_classes_id FK
Primary key is both (reservatiion_id and specific_classes_id)
5-specific classes
specific_classes_id PK
data of classes
start time classes
finish time classes
duration time
id_trainer-FK
Id_room -FK
id-classes
6-classes
id_classes pk
type of classes
name of classes
7-trainer
p_id
name
address
8-room
id_room
|
|
|
|
|
|
designing database of reservation system.