The tourism department want to record its data in digital format. The information consists of monuments...

 

Transcribed Image Text:

The tourism department want to record its data in digital format. The information consists of monuments of tourist interest, their location and history. Monuments are classified according to historical, religious and architecture importance. The list of facilities available at each sport is also available. This give (1) living accommodation in terms of hotels, their names, category and the number of rooms available and (ii) local transport facilities in terms of service provider name, tours with their tariff and timing. Draw an E-R diagram by identifying the entities, relationships, attributes, cardinality. Also mention the assumption, if needed. Draw the relational model of the above question with constraints and assumption if needed. The tourism department want to record its data in digital format. The information consists of monuments of tourist interest, their location and history. Monuments are classified according to historical, religious and architecture importance. The list of facilities available at each sport is also available. This give (1) living accommodation in terms of hotels, their names, category and the number of rooms available and (ii) local transport facilities in terms of service provider name, tours with their tariff and timing. Draw an E-R diagram by identifying the entities, relationships, attributes, cardinality. Also mention the assumption, if needed. Draw the relational model of the above question with constraints and assumption if needed.

Answer rating: 100% (QA)

Solution Here is a possible answer to your question based on the information you provided Please note that this is not a complete or definitive answer and you should do your own research and analysis ... View the full answer