subject

Using the same data model and physical database created in Phase 1, please write queries using mySQL and Mongo. Each of your queries should generate a result set that proves or disproves the following statements. Pick 5 out of the 10 statements to write your queries in mySQL. Write queries using Mongo for 3 out of the 10 statements. If you need more than one SQL statement to prepare an answer, explain your rationale for doing so in the report. Query that contains one SQL statement will generally result in a higher score for that response.1. Daily prices can be higher for properties with more bathrooms2. Weekly prices can be lower for properties with lesser bedrooms3. Strict cancellation policies are best for properities with high review scores4. Properties with high review scores for cleanliness have higher daily prices than properties with high review scores for location5. Properties with the higher review scores for location had higher occupancy rates6. Lower security deposits and cleaning fees lead to better review scores7. Properties with higher daily prices also charge higher security deposits and cleaning fees8. Properties allowing higher number of extra people have higher occupancy rates9. Properties with higher number of reviews had lower review scores overall and for location.10. Properties in the best locations charge highest daily pricesTo create your project database in Mongo, you can either use the raw dataset or the database you created in mySQL. The Mongo database does not have to be in 3NF, but mySQL database needs to be in 3NF.

ansver
Answers: 1

Other questions on the subject: Computers and Technology

image
Computers and Technology, 22.06.2019 10:30, robert7248
You have a large, late-model pick-up truck with a rear seat. the pick-up truck weighs 6,500 pounds. the florida seat belt law
Answers: 1
image
Computers and Technology, 24.06.2019 01:30, kellygaytan
Suppose a cpu with a write-through, write-allocate cache achieves a cpi of 2. what are the read and write bandwidths (measured by bytes per cycle) between ram and the cache? (assume each miss generates a request for one block.)
Answers: 1
image
Computers and Technology, 24.06.2019 14:30, heathersloan274
Which computer network component connects two different networks together and allows them to communicate? a is a node (or a device) that connects two different networks together and allows them to communicate.
Answers: 1
image
Computers and Technology, 25.06.2019 05:10, andyboehm7411
What is the disadvantage of a mesh topology?
Answers: 1
You know the right answer?
Using the same data model and physical database created in Phase 1, please write queries using mySQL...

Questions in other subjects:

Konu
Mathematics, 15.01.2021 01:00
Konu
History, 15.01.2021 01:00
Konu
Mathematics, 15.01.2021 01:00