We are designing a university database system that will be accessed by multiple uses, namely University Administrators,
Question:
We are designing a university database system that will be accessed by multiple uses, namely University Administrators, Contact Tracers, and Facility Managers. University Administrators: are interested in ranking departments based on the average time people who belong to that department spend in the regions controlled by the department (the larger the time more hardworking, the people in that department). In particular, they want to visualize a leaderboard showing each department and its rank based on the average time (total time of all visits/number of unique users). A department with the highest average time is ranked no. 1, second highest no. 2 and so on. Note that time spent at a location during one visit is given by (end_time - start_time). build a view for University Administrator and show the result using the select * from view command:
International Business
ISBN: 9781292274157
8th Edition
Authors: Simon Collinson, Rajneesh Narula, Alan M. Rugman