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

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 09:00
Which best describes the condition under which the unicode output is the same as plain text?
Answers: 3
question
Computers and Technology, 24.06.2019 17:00
What are some examples of what can be changed through options available in the font dialog box? check all that apply. font family italicizing bolding pasting drop shadow cutting character spacing special symbols
Answers: 2
question
Computers and Technology, 24.06.2019 21:50
Maddie is traveling to india and would like to document her trip for friends and family to access online. what tool would be best? app blog listserver web page
Answers: 1
question
Computers and Technology, 25.06.2019 16:00
What is the play area? a. the frame editor b. the area the player will see in the game screen c. the area right next to an active object d. the area that keeps track of events in a game
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
question
Mathematics, 13.03.2021 03:50
Questions on the website: 13722367