Part : Answer the following guestions: Q1: A state university stores all student
ID: 395818 • Letter: P
Question
Part : Answer the following guestions: Q1: A state university stores all student data in a database. The collected data includes each student's first name, last name, age, gender, major, nationality, and so forth. The process component of the information system performs all sorts of analysis on this data. For example, the university's DBMS has a built-in query capability that can generate the following information: How many students are in each major? Which major is the fastest growing? What is the average age of the student body? Among the international students, which country is home to the highest number of students? What is the ratio of male to female students in each major? Explain how the university could use the information effectively? b. Give an example of three additional queries the university should run and why?Explanation / Answer
Ans 1 a. The university can effectively use this information to achieve the following:
Ans 1 b. The additional queries that the university should run should be as follows:
Ans 2 a. Netflix could steal blockbuster business in a short period of time because of the following reasons:
Ans 2 b. Three ideas which could help Netflix increase market share and profitability are as follows:
“*As per guidelines can answer up to 4 questions or 4 parts.”