Computers and Technology, 16.06.2021 07:20, jebjeb6124

CASE STUDY TRIGGERS: BIIT software house wants to maintain a database of its employees, projects assigned to employees and accounts. Database schema is given below.
1- EMPLOYEE( eid, eName, eAge, eCity, eRank, eDep) 2- PROJECT ( pid, pName, pBonusAmout)
3- Project_Allocation ( eid, pid)
4- ACCOUNTS ( eid, Year, Month, Basic_Salary, Project_Bonus)
5- ACCOUNTS_BACKUP( eid, Year, Month, Basic_Salary, Project_Bonus) 6- LOG( srNo, table_name , Date, Time, event, no_of_rows_effected)

Perform following tasks

a- Whenever a record is inserted or updated from ACCOUNTS table, it must also be inserted / updated in ACCOUNT_BACKUP table as well. Do not allow user to delete any record from ACCOUNTS or ACCOUNTS_BACKUP table. On insertion in ACCOUNTS table, Project_Bonus will be calculated by system on the basis of projects assigned to employee.
b- Make sure primary foreign keys must not violate in any table. You must use triggers to apply any type of constraints. All keys are mentioned at the end.
c- LOG table will maintain every activity of Database. Whenever a record is inserted, updated or deleted in database. All data regarding event will be stored in LOG table.

Answers: 3

Show answers

Other questions on the subject: Computers and Technology

Computers and Technology, 23.06.2019 15:20, headshotplayzcod

In a game with three frames, where will the objects on layer 1 appear? a. next to the play area b. in the middle of the game c. behind everything else d. in front of everything else

Answers: 1

continue

Computers and Technology, 23.06.2019 21:40, gaby06

Simon says is a memory game where "simon" outputs a sequence of 10 characters (r, g, b, y) and the user must repeat the sequence. create a for loop that compares the two strings. for each match, add one point to user_score. upon a mismatch, end the game. sample output with inputs: 'rrgbryybgy' 'rrgbbrybgy'

Answers: 3

continue

Computers and Technology, 24.06.2019 02:00, akatherine1738

What is a loop? a. a collection of function definitions at the top of a program b. a line of code that defines a variable and assigns it a value c. a program that opens the turtle graphics window d. a block of code that repeats a specific number of times

Answers: 1

continue

Computers and Technology, 24.06.2019 04:30, NEUROPHARMACOLOGICAL

The ieee 802.11: defines standards for wireless local area network (wlan) communication protocols. identifies various computers or devices connected to a network. verifies any resource attached to another computer on a network that is different from the computer to which the user is logged on. connects multiple local area networks (lans) and wide area networks (wans).

Answers: 2

continue

Do you know the correct answer?

CASE STUDY TRIGGERS: BIIT software house wants to maintain a database of its employees, projects as...