The tourism department want to record its data in digital format. The information consists of monuments...
Fantastic news! We've Found the answer you've been seeking!
Question:
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.
Expert Answer:
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
Related Book For
Accounting Information Systems basic concepts and current issues
ISBN: 978-0078025334
3rd edition
Authors: Robert Hurt
Posted Date:
Students also viewed these accounting questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
can someone solve this Modern workstations typically have memory systems that incorporate two or three levels of caching. Explain why they are designed like this. [4 marks] In order to investigate...
-
Laura Leasing SA signs an agreement on January 1, 2022, to lease equipment to Plote AG. The following information relates to this agreement. 1. The term of the non-cancelable lease is 3 years with no...
-
How is the fact that an electromagnetic wave in space never slows down consistent with the conservation of energy?
-
The average electric power P entering a load varies jointly as the resistance R of the load and the square of the effective voltage V, and inversely as the square of the impedance Z.
-
This case arose after Felix DeWeldon, a well-known sculptor and art collector, sold three paintings to Robert McKean in 1994. Felix DeWeldon declared bankruptcy in 1991. In 1992, DeWeldon, Ltd.,...
-
Assume that IBM leased equipment that was carried at a cost of $150,000 to Sharon Swander Company. The term of the lease is 6 years beginning January 1, 2011, with equal rental payments of $30,044 at...
-
8. A straight section of railroad track crosses two highways 400 m and 600 m from an intersection. Find the dimensions of the largest rectangular lot that can be laid out in the triangle formed by...
-
Task 1: Pedestrian Stoplight Many crosswalks have a stoplight that tells pedestrians when they can cross the street. They use three phases: 1. "Go" - solid green 2. "Don't start" - flashing red 3....
-
Consider a research funding game in which two government agencies, the U.S. Department of Energy (DoE) and the Defense Advanced Research Projects Agency (DARPA), each decide which of two research...
-
Q6. (2 points) Section 4.1 Question 21: The tail of a language is defined as the set of all suffixes of its strings, that is, tail (L) = {y xy = L for some x = *}. Show that if L is regular, so is...
-
Explain the intricacies of network stack implementation within operating systems, covering topics such as packet processing, socket management, and protocol handling, while ensuring scalability and...
-
A test rocket is fired vertically upward from a well. A catapult gives it initial speed 62 m/s at ground level. Its engines then fire and it accelerates upward at 4.0m/s2 until it reaches an altitude...
-
A test rocket is fired vertically upward from a well. A catapult gives it initial speed 90 m/s at ground level. Its engines then fire and it accelerates upward at 3.5m/s2 until it reaches an altitude...
-
A silver ring whose cross-sectional area is 4,524 cm2 is about to be melted, so it will heat up around 300 C. If we assume that it does not melt, how much will its cross-sectional area vary from its...
-
Read Case Study Google: Dont Be Evil Unless and answer the following: Given its mission of providing information to the world, should Google censor searches in China?
-
a. Is Jim acting professionally? Explain your response. b. Which of the four schools of ethical thought does Jim follow? Explain your response. c. Is the CFOs proposed action ethical?
-
Explain what is happening in each transaction presented in the previous exercise. For example, in transaction ( a ), the company is paying its share of payroll taxes.
-
Multiple choice. Please refer to the case in Problem 12 as you respond to these questions. 1. In a systems flowchart, which of the following is most likely to be depicted with a predefined process...
-
Provide mechanical and molecular definitions of work and heat minor effect on the principles being illustrated). Assume compression ratio \(=9.0: 1\);...
-
A gas turbine engine operates between minimum temperature \(T_{1}\) and maximum temperature \(T_{3}\). Show that the optimum pressure ratio for maximum work output is...
-
Assume the maximum pressure ratio. Determine the efficiency and work ratio of the cycle in P17.1. \([0.75,0\). P17.1. A gas turbine engine operates between minimum temperature \(T_{1}\) and maximum...
Study smarter with the SolutionInn App