A multi-campus school wants to perform analytics on classes held during the past 5 years. The school wants to know which classes filled up the quickest across all campuses and which classes filled up the quickest at each campus. The school also wants to know if there is a relationship between the number of passing students and the speed in which a class taught by a particular teacher fills. If the school could only choose one type of database to store the data on one server, which type would be best suited for this task?
Explanation: A relational database, even though it has multiple, connected tables, can reside on one server and would be best for this type of data. A local database is typically used to collect and store local data, for example, a database of all movies and music for a particular family. A flat database would most likely not be used in a multi-location school to store student data such as this. Hadoop is best to use when distributing processing power across server clusters.