b$)$ The Relational Database Schema for The Company Database:

$--$ Q$1)$ retrieve the number of projects per department $($or per department number$).$

$--($That is$,$ retrieve the number of projects that each department controls.$)$

$--$ then order the results by department number in descending order.

$--$ Q$2)$ retrieve their first name, last name, and address of employees

$--$ who live in the city named 'Milwaukee',

$--$ Order the result by last name in the ascending order and

$--$ then by their first name in the descending order.

$--$ Q$3)$ retrieve department whose name's fifth character is $\text{'}$w$\text{'}$

$--$ Q$4)$ retrieve the number of employee per project number.

$--$ then retrieve only the project number whose number of employees is more than $3.$

$--$ Q$5)$ replace the department name whose department number is $8$ with AI$.$