help

[silviadana]

I need help with Conceptual Data Model for Hotel Reservation. Yes, I looked at databaseanswer but my problem is not the same.

My problem sounds like this

The hotel reservation company wishes to realize a system for managing hotel bookings. After hotel affiliation, it will be registered in the computer system with the following data: name, address, category (1*......5*), services offered by the hotel + practiced room prices.
The prices practiced by each hotel are influenced by
- room category (Standard, deluxe)
- Number of beds (1 to 4)
- Period
The system won't record the list of all rooms from each hotel

This is only the first part, before the client who can make a reservation for one single room each time.

Now, I don't know how to make my Conceptual data model.
I think that my tables are

Country (Country_ID,CountryName)
District(District_ID,DistrictName, Country_ID)
City(City_ID, CityName, District_ID)
Category (Category_ID, CAtegoryName)
Hotel (Hotel_ID, City_ID,Category_ID, HotelName)
Services (Service_ID, ServiceName)
HotelServices (Hotel_ID,Service_ID)
RoomType(Type_ID, TypeName,NumberofBeds)
RoomCategory( Category_ID, CAtegoryName)
Rooms(Hotel_ID,Type_ID, CAtegory_ID, NumberofRooms, Description)
Period(Period_ID, Date_s, Date_e)
Rates (Hotel_ID,Type_ID, CAtegory_ID, Period_ID, Rate)

Sorry if I put this kind of question, but I can't realize which is the right way to do the CDM

 

[DCrake]

This sounds very much like home work or an assignment, am I correct?

 

[silviadana]

This sounds very much like home work or an assignment, am I correct?

Yes, but I asked only for help to understand how it works,and I think the best way to learn is when somebody is telling you were you are wrong.
We were told that is recommended to reduce relationships (associations) to binary (not ternary or higher)
And I can't figure out how to do this when the number of rooms differ for each hotel + type+category.
And the room price is given also by the hotel, type, category and period