Question: Task 2.b: Active Rules Using Triggers I. The University student data centre that is responsible for entering student details and enrolment details works from

Task 2.b: Active Rules Using Triggers I. The University student data centre

Task 2.b: Active Rules Using Triggers I. The University student data centre that is responsible for entering student details and enrolment details works from Monday 9.00 am Friday 5.00 pm. The system must be protected (don't allow any changes on appropriate tables) and only allow minimum operations from Friday 5.00 pm to Monday 8:00 am. For example, students' details or enrolment details are only added or amended during office hours. Database activities are monitored all the time, create an active rule to stop such activities and display appropriate messages. 5% II. University can only accommodate a limited number of students for each section. Create an active rule to display an appropriate message on the screen to warn the DBA while the enrolment is nearing its capacity and also when it has reached the capacity limit.

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 Databases Questions!

Case Questions 1. What are some of the pros and cons for each development project? What should United Beverages take into account when deciding which product(s) to develop? 2. Assume that the total...

Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...

Read the case study and answer the question below with a one page response. What does a SWOT analysis reveal about the overall attractiveness of Under Armours situation? Founded in 1996 by former...

Recently you have been appointed as a Database Administrator ( DBA ) in a University. As part of your job, you have to manage, monitor and log the database activities in their Student Management...

Task 3: Procedure, Functions Triggers and Active Rules in Oracle 50% Recently you have been appointed as a Database Administrator (DBA) in a University. As part of your job, you have to manage,...

create a value stream map for the mailroom categories 1-3 (page 6). Start your value stream map woth delivery of the mail to ING. . Additional information: Assume 1000 pieces of mail for your...

could you please help me Accountung Theory and practice course assignment? i have to do next week monday. Please i need your help i have to choose 3 articles below and apply acoounting theory. I...

Hello, Sarah could you please help me Accountung Theory and practice course assignment? i have to do next week monday. Please i need your help i have to choose 3 articles below and apply acoounting...

answer the following questions. 1. Analyze The Pub's competitive environment and macroenvironment. 2. Answer the following questions. a. What are the two most significant driving forces of change in...

The following data are taken from the comparative balance sheets of Mayberry Billiards Club, which prepares its financial statements using the accrual basis of accounting. Members are billed based...

Determine whether u, v, and w lie in the same plane when positioned so that their initial points coincide. u = (- l, - 2, l),v = (3, 0, - 2),w = (5, - 4,0)

Life insurance agent has given certain authority to act for their insurance company The authority is specifically conveyed to that person through the contract with the insurance known as

From the tenth floor of her office building, Katherine Rally watches the swarms of New Yorkers fight their way through the streets infested with yellow cabs and the sidewalks littered with hot dog...

Jake Nguyen runs a nervous hand through his once finely combed hair. He loosens his once perfectly knotted silk tie. And he rubs his sweaty hands across his once immaculately pressed trousers. Today...

In March 2013 the management team of Londonderry Air (LA) met to discuss a proposal to purchase five shorthaul aircraft at a total cost of $25 million. There was general enthusiasm for the...

During the current month, Barnum Company incurs the following manufacturing costs: a. Purchased raw materials of $13,000 on account. b. Incurred factory labor of $40,000. Of that amount, $31,000...

In March 2018, the management team of Londonderry Air (LA) met to discuss a proposal to purchase five shorthaul aircraft at a total cost of $25 million. There was general enthusiasm for the...

Which of the following is a reason that traditional control methods often do not work? Question 6 Select one: a . They put effectiveness over efficiency. b . They tend to measure the part rather than...

Suppose that in response to a threatened antidumping duty of t, the Foreign monopoly raises its price by the amount t. a. Illustrate the losses for the Home country. b. How do these losses compare...

Use the table that follows to answer this question. Treat the country listed as the home country, and the United States as the foreign country. Suppose the cost of the market basket in the United...

No U.S. tire producers joined in the request for the tariff on tires in 2009. Rather, the petition for a tariff on tires imported from China was brought by the United Steelworkers of America, the...

A multiple regression equation yields the following partial results. a. What is the total sample size? b. How many independent variables are being considered? c. Compute the coefficient of...

In a multiple regression equation, two independent variables are considered, and the sample size is 25. The regression coefficients and the standard errors are as follows. b1 = 2.676 sb1 = 0.56 b2 =...

Cellulon, a manufacturer of home insulation, wants to develop guidelines for builders and consumers on how the thickness of the insulation in the attic of a home and the outdoor temperature affect...