Subject: Database Management System Solution

Part A

·         Consider the following table in your database.

employeeID
Name
age
salary
101
Syikin
23
2500
102
Ahmad
32
3000
103
Imman
44
5000
104
Fazrin
27
2700
 

CONSTRUCT SQL queries for following questions:

·         Total of all the salaries from table ‘employee’.

·         Grouping both salary and employee IDs table.

·         Re arrange the table in order the results will be in descending order, from highest salary to lowest.

·         List all data from table ‘employee’.

·         Update where .

·         List Name and age where .

·         Insert new data into table ‘employee’ value (105, ‘Rina’, 29, 2800).

Delete data from table employee where .

·         Explain the following term with appropriate example of SQL syntax for each term

·         CREATE ROLE

·         DROP ROLE

·         SET ROLE

 

Part B

Make a presentation slide about the topic below, Minimum of 5 slides

Discuss all you know about TRIGGERS and Give examples for SQL queries