Databases | SQL | Oracle | MS Access Answers

In the below-mentioned example, there is an EMP Table having records of EMP_NAME, EMP_NO, SALARY, MANAGER_ Dep.

Now, you have to perform the following operations by using the commands INSERT INTO, DELETE, UPDATE and SELECT in detailed SQL code by following the main steps:

⦁ Firstly, you insert the data by using the command INSERT INTO.

⦁ Then, you have to update the SALARY record of Saqib by 80,000 to 85,000 by using the command UPDATE.

⦁ Finally, and delete the record of Shahid from the table by using the command DELETE.

EMP_NAME EMP_NO SALARY MANAGER_ Dep

Haseeb 1 70,000 Marketing

Saqib 11 80,000 Accounts

Shiraz 12 65,000 HR

Shahid 13 80,000 Supply chain

atm management system code in sql server

atm management system code in sql

 How to reflect the real-time update of the information of the management system module?

1.     How is the interactive operation of the library's online management system, especially the information update module operated by borrowing back?

atm managment system in sql

advanced level atm management system project in sqlserver

with front end design

Implement the following procedures/functions/triggers

Tasks

4. Function which displays for a given employees (the function must take one parameter: employee_id) all his/her tasks which are still open and number of days left to the deadline date. If the deadline data has been exceeded for some task it should be indicated as ‘deadline exceeded’

5. Function which returns all current employees working on a given position (postiton_id should be function parameter). The function should display employee_id, first name, last name, salary, start date, department id, department date.

6. Procedure giveRaise which gives 15% raise for employee(s) who did the most number of tasks during last twelve months.

7. Trigger which does not allow to fire an employee who has at least one open task. The trigger should run after update statement on the Employment table which tries to set the end_date column on some date value.

1. Consider a case of NEWSPAPER HAWKER in your society and design ERD with Physical data Model. Also, design a complete database using ERD.
2.  
3. NOTE: Consider different newspapers on the basis of language, frequency, pages, regional / nationwide, etc.

Write SQL code that create a report that ask the user to enter publisher’s name in any case and in any form (entering full name or part there of) and it must retrieve all the books details published by this specific publisher. It must display isbn, title, author name, date published, total copies, total price.

Important Facts:     

✓ Page width must be 132 and page length 19

✓ The code must not display the number of records retrieved and it must not verify the value entered. ✓ Reset all the format that you created

✓ Use local currency for prices

✓ Negative marking will apply if columns aliases are used within the query statement.