Write a query to display the name of the department that has the maximum staff count order by department name. Refer the below schema diagram: College Management System(CMS) Department Student...


Write a query to display the name of the department that has the maximum staff count order by department name.<br>Refer the below schema diagram:<br>College Management System(CMS)<br>Department<br>Student<br>department id number-- PK<br>department_name varchar(30)<br>department_block_number number<br>O4student_id number --> PK<br>student_name varchar(30)<br>address varchar(40)<br>city varchar(30)<br>department_id number --> FK<br>PK-- Primary Key<br>FK-- Foreign Key<br>Subject<br>Staff<br>subject_id number -PK<br>subject_name varchar(30)<br>subject_code varchar(10)<br>staff_id number -- FK<br>staff_id number --> PK<br>staff_name varchar(30)<br>王<br>department_id number--> FK<br>Mark<br>value number<br>subject_id number--> PK,FK +<br>student_id number-->PK,FK<br>王<br>

Extracted text: Write a query to display the name of the department that has the maximum staff count order by department name. Refer the below schema diagram: College Management System(CMS) Department Student department id number-- PK department_name varchar(30) department_block_number number O4student_id number --> PK student_name varchar(30) address varchar(40) city varchar(30) department_id number --> FK PK-- Primary Key FK-- Foreign Key Subject Staff subject_id number -PK subject_name varchar(30) subject_code varchar(10) staff_id number -- FK staff_id number --> PK staff_name varchar(30) 王 department_id number--> FK Mark value number subject_id number--> PK,FK + student_id number-->PK,FK 王

Jun 04, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here