Question: 1) Exercise - Create Use Case Diagram (Include association and generalization relationships. Include primary and supporting actors) for Mobile phone number balance Control Application :
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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help