Zookal
Zookal

We’d love to hear any feedback or comment from you!

© 2011-2021 Zookal Pty Ltd

View question and answer

From our collection of questions and answers
Engineering · Computer Science
Question details
Database system help
1. Lets suppose there are twenty shop stores and 50,000 students in Wuhan University, and we want to build a database based on MySOL to maintain the daily purchase businesses in Wuhan University. Please use SQL to realize the following targets. a) Please build a schema including at least two entities, saying Store and Student, and a relationship Purchase, such that the main purse details and the main characters of stores (including their department region number) and students (including their names, country name, student number, etc.) can be modeled properly Query the three tables to extract the total purchase amount of a shop store with its name Ziqiang chaoshi in the department region Technology Region. Query the three tables to extract your total purchase amount in all shop stores in the year 2018. Query the three tables to extract the yearly purchase amounts of all the shop stores in the department region Technology Region, and group and sort the amounts by year b) e) d) Following question IV-1, next we consider all of the universities in China, including 1,000 universities like Wuhan University a) Please estimate the transactions per second in IV-1, and claim whether its possible to 2. accommodate all records in a data center consisting a single MySQL server. If we were to run the queries IV-1-b-IV-1-d based on a single MySQL server, please estimate how long these queries will take If we want to speed up these queries based on Hive or Spark, how to build a FLAT schema? And, give the corresponding queries based on the flat schema. (Please give the translated queries based on either SOL or Hive QL) b) c)
Answer
Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.

Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.Find step-by-step answers from expert tutors to questions asked by students like you. Start 14-day free trial.