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 22:30
One of your customers wants you to build a personal server that he can use in his home. one of his concerns is making sure he has at least one backup of their data stored on the server in the event that a disk fails. you have decided to back up his data using raid. since this server is for personal use only, the customer wants to keep costs down. therefore, he would like to keep the number of drives to a minimum. which of the following raid systems would best meet the customer's specifications? a. raid 0 b. raid 1 c. raid 5 d. raid 10
Answers: 3
question
Computers and Technology, 23.06.2019 02:50
There’s only one game mode that stars with the letter β€˜e’ in cs: go. which of the options below is it?
Answers: 1
question
Computers and Technology, 23.06.2019 22:20
What is a programming method that provides for interactive modules to a website?
Answers: 1
question
Computers and Technology, 25.06.2019 01:00
Regular maintenance is a key component of automotive lift safety.
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, 14.10.2019 15:00
question
Biology, 14.10.2019 15:00
question
Mathematics, 14.10.2019 15:00
question
Mathematics, 14.10.2019 15:00