1) Exercise - Create Use Case Diagram (Include association and generalization relationships. Include primary and supporting actors) for Mobile phone number balance Control Application:

10 points

2) Exercise Create Prototype of entity relationship diagram for the following tables:

10 points

DEPARTMENT (Dep_ID, Dep_Name, Dep_Location)

EMPLOYEES (Emp_ID, Emp_Name, Job_Name, birth, Salary, departament_block)

3) Write SQL query Using tables in question 2 add new employee in IT departament.

10 points

4) Write SQL query Using tables in question 2 show number of epmployees in each departament.

10 points

5) Write SQL query - Using tables in question 2 and JOIN operator to find the all employees name, birth, department name, department block from the given tables and group all employees by departments.

10 points