Question: Which integrity control, domain, assertions ,or triggers, would you apply in each of the following scenario listed below and how? Authorization rules Encryption

Which integrity control, domain, assertions ,or triggers, would you apply in each of the following scenario listed below and how?

• Authorization rules

• Encryption

• Authentication schemes

a. A field salary for all employees in a firm can only take values between $5000 and $50000.

b. A table Stock has a column Qty_at_hand and at any given time, the average of all values in this column should not exceed 100.

c. A business rule states that in a particular database table ONEDATA, there should exist at least one row.

d. A bank’s business rule states that if an account holder attempts to withdraw more than one million dollars in a day that transaction should not be processed and the management should be notified immediately.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Database Management Systems Questions!

This question concerns lexical grammars. (a) Tree Adjoining Grammars contain two types of elementary tree. (i) What are these trees called? [1 mark] (ii) If one were building a grammar for English...

Business problem Our company does car rental business and has several locations with different addresses (address consist of street or rural route with the number, city, state and zip code). The cars...

Integrity Constraints Consider the following relational schema. An employee can work in more than one department; the act time field of the Works relation shows the percentage of time that a given...

John and Sally are discussing a client s system of internal control, and how that system relates to financial statement assertions. John advises Sally that despite what he has been told, he doesn t...

Photograph four different internal controls you observe on campus or in your place of employment. 3 internal controls must be processing integrity controls from Chapter 1 3 . And one internal control...

Please help!! The third column needs to be filled out, like the top row. The definitions of each relevant application are provided as well. Any help you can give would be great. Thank you! Relevant...

Consider the following relational schema. An employee can work in more than one department; the pct time field of the Works relation shows the percentage of time that a given employee works in a...

Problem 2. (Based on Exercise 5.10) [50 pts] Consider again the following relational schema. An employee can work in more than one department; the pct time field of the Works relation shows the...

Depreciation information for Apex Chemicals Company is given in BE9-3. Assuming the declining-balance depreciation rate is double the straight-line rate, compute annual depreciation for the first and...

The ends A & B of a rod of 20 cm have the temperature 80oC and 80oC entire steady state prevails. enteil steady Changed to 400 X 60c a rod 20cm, long, steady state prevails. the temporaleeres 30C...

From the employer's perspective, which of the following is a challenge of paying employees Multiple Choice Employee self - maintenance of personnel records. A chance that the employee will lose their...

Phoenix Plastic Inc. has accumulated the following data over a six-month period: Separate the machine-related costs into their fixed and variable components, using the high-lowmethod. Machine Hours...