Reference no: EM131047726
Text: Fundamentals of Database Systems, Elmasri, Ramez; Navathe, Shamkant B.
Chapter: Answer the following questions.
26.34 Consider the COMPANY database described in Figure 5.6 on page 162 of E&N. Using the syntax of Oracle triggers, write the active rules to do the following:
a. Whenever an employee's project assignments are changed, check if the total hours per week spent on the employee's projects are less than 30 or greater than 40; if so, notify the employee's direct supervisor.
Use this command to notify the manager of that an employee has worked more or less hours than expected:
host /usr/sbin/sendmail -t <"Employee " + Essn + " has more or less hours than expected this week">
b. Whenever an employee is deleted, delete the PROJECT tuples and DEPENDENT tuples related to that employee, and if the employee manages a department or supervises employees, set the Mgr_ssn for that department to NULL and set the Super_ssn for those employees to NULL.
26.35 Repeat Exercise 26.34 (prior question) but use the syntax of STARBURST active rules.
26.43 Consider a deductive data base with the following rules:
r1 : ANCESTOR(X, Y) :- FATHER(X, Y)
r2 : ANCESTOR(X, Y) :- FATHER(X, Z), ANCESTOR(Z, Y)
Notice that FATHER(X, Y) means that X is the father of Y; ANCESTOR(X, Y) means that X is the ancestor of Y.
Consider the following fact base:
FATHER(Harry, Issac), FATHER(Issac, John), FATHER(John, Kurt)
a. Construct a model-theoretic interpretation of the above rules using the given facts.
b. Consider that a database contains the above relations FATHER(X, Y), and another relation BROTHER(X,Y), and third relation BIRTH(X, B), where B is the birth date of Person X. State a rule that computes the first cousins of the following variety: their fathers must be brothers
|
What would be the bonds clean price
: Suppose you buy a bond with a 12 percent annual coupon, payable semiannually. You actually pay $ 1,080 for this bond. On the day you buy it, the next coupon is due in 3 months. What would be the bond's clean price?
|
|
Bond issue outstanding with maturity
: IBM has a bond issue outstanding with 14 years to maturity. When originally issued the bond had a par value of $1,000, a stated coupon rate of 12% and 15 years to maturity. Currently, similar risk bonds in the market place are yielding 8%. What would..
|
|
Size of the international market for the product
: an assessment of the segmentation and positioning opportunities in the selected foreign market; an assessment of the size of the international market for the product and a forecast of future demand
|
|
How much of your money will you invest in stock
: A stock market comprises 4600 shares of stock A and 1600 shares of stock B. Assume the share prices for stocks A and B are $15 and $30, respectively. If you have $15,000 to invest and you want to hold the market portfolio, how much of your money will..
|
|
Construct a model-theoretic interpretation
: Construct a model-theoretic interpretation of the above rules using the given facts - State a rule that computes the first cousins of the following variety: their fathers must be brothers
|
|
How would you describe your primary responsibilities
: As a systems analyst on this project, how would you describe your primary responsibilities, and how could you contribute to the quality of the finished product?
|
|
Motivate with the aid of a graph
: motivate with the aid of a graph
|
|
Improves the application of investment rules
: Net present value is just a tool and as with any tool, it can be dangerous in the wrong hands. In what way do the risk based present value improves the application of investment rules?
|
|
Process of using marginal analysis to solve decision problem
: Explain the process of using marginal analysis to solve decision problems with a square matrix (ie actions = states) involving discrete probability distributions describing the states of nature.
|