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 answertables look like:First table: Useruser_id-PKFirstnamelast nameaddresscity phoneSecond: Reservation Reservation_id-PKUser_id-FKstatus_id FKdataOfReservation Third statusOFreservation status_id PK name4-reservation of specific classesreservation_id FKspecific_classes_id FKPrimary key is both (reservatiion_id and specific_classes_id)5-specific classesspecific_classes_id PKdata of classes start time classesfinish time classesduration time id_trainer-FKId_room -FKid-classes6-classesid_classes pktype of classes name of classes7-trainer p_idnameaddress8-roomid_room |
|
|
|
|
|
designing database of reservation system.