Hello There,

This is discussion Question

For Advanced Database Systems

Question:

(a) Please define what a “trigger” is. If your answer is from the textbook, please state which page of the textbook from which you got the definition. If your answer is not from the textbook, please also include the complete reference.

(b) Please define what “PL/SQL” is. If your answer is from the textbook, please state which page of the textbook from which you got the definition. If your answer is not from the textbook, please also include the complete reference.

(c) Please define what a “transaction” is. If your answer is from the textbook, please state which page of the textbook from which you got the definition. If your answer is not from the textbook, please also include the complete reference.

(d) Please define “concurrency control” in database operations. If your answer is from the textbook, please state which page of the textbook from which you got the definition. If your answer is not from the textbook, please also include the complete reference.

Thank you

Physicians at a clinic gave what they thought were drugs to 860860 patients. Although the doctors later learned that the drugs were really placebos, 5656 % of the patients reported an improved condition. Assume that if the placebo is ineffective, the probability of a patients condition improving is 0.530.53. Test the hypotheses that the proportion of patients improving is >0.53

On January​ 1, 2018, bonds with a face value of $ 79,000 were sold. The bonds mature on January​ 1, 2028. The face interest rate is 8​%. The bonds pay interest semiannually on July 1 and January 1. The market rate of interest is 12​%. What is the market price of the bonds on January​ 1, 2018? The present value of​ $1 for 20 periods at 6​% is 0.312. The present value of an ordinary annuity of​ $1 for 20 periods at 6​% is 11.47. The present value of​ $1 for 20 periods at 4​% is 0.456. The present value of an ordinary annuity of​ $1 for 20 periods at 4​% is 13.59. ​(Round your final answer to the nearest​ dollar.)

A.79,000
B.82,160
C.60,893
D.78,968

How do I make this sort in true alphabetical order instead of ascii(ABCabc) order? I am trying to get AaBbCc. Currently I get ABCabc. please help... here is the code using VB:

Public Class frmTransfer

    Dim strSortArray() As String

    Private Sub txtInput_TextChanged(sender As Object, e As EventArgs) Handles txtInput.TextChanged

        Dim intUpper As Integer

        Dim intCount As Integer

        intUpper = Len(txtInput.Text) - 1       REM -1 because array starts at 0

        For Each chr As Char In txtInput.Text       REM for each chr(character) entered as a character in the text box

            If ((Asc(chr) > 64) And (Asc(chr) < 91)) Or ((Asc(chr) > 96) And (Asc(chr) < 123)) Or ((Asc(chr) > 31) And (Asc(chr) < 65)) Then     REM If the character entered is a letter

                ReDim Preserve strSortArray(intUpper)           REM preservers previous data and adds new slot to array

                strSortArray(intCount) = chr            REM sets the array at position intCount equal to chr

                intCount = intCount + 1                 REM increases intCount by 1

            End If

        Next chr

    End Sub

    Private Sub btnTransfer_Click(sender As Object, e As EventArgs) Handles btnTransfer.Click

        Dim X As Integer

        Dim Y As Integer

        Dim temp As String

        For X = LBound(strSortArray) To (UBound(strSortArray) - 1)

            For Y = LBound(strSortArray) To (UBound(strSortArray) - 1)

                If Asc(strSortArray(Y)) > Asc(strSortArray(Y + 1)) Then

                    ' exchange the items

                    temp = strSortArray(Y)

                    strSortArray(Y) = strSortArray(Y + 1)

                    strSortArray(Y + 1) = temp

                End If

            Next Y

        Next X

        lblOutput.Text = String.Join("", strSortArray)

    End Sub

End Class

As a healthcare provider in physical therapy, athletic training, or as an exercise scientist and personal trainer you will be exposed to individuals who smoke or have an addiction to nicotine. For this assignment, I would like you to write approximately 2 paragraphs describing the physiological effects caused by smoking tobacco and relating these effects to ganglionic stimulation.

10. What are the three monetary policy tools of the Fed? Briefly describe how each tool can be used to implement an expansionary monetary policy and a contractionary monetary policy.

In what ways would the role of a manager working in a nonstandard international assignment arrangement differ from that of a typical expatriate manager?

Write a Bash script called move that could replace the UNIX command mv. 'move' tries to rename the source file (using the UNIX command mv), but if the destination file exists, appends an index number, a sort of version number, to the destination file. So if the user types:

move a.txt b.txt

and b.txt already exists, move will rename the file to b.txt.1. If b.txt.1 already exists, move must rename the file to be b.txt.2, and so on, until the file can be successfully renamed with a name that does not already exist.

This is what I have so far but for some reason instead of indexing the filenames .1, .2, .3 it does .1, .1.1, .1.1.1 which I am confused on how to fix.

#!/bin/bash

if [ -f "$1" ] && [ -f "$2" ]; then
x = 1

while [ -f $2"."$x ]
do
x=$((x+1))
done

mv $1 $2"."$x

else
mv $1 $2
fi

1. Write program in C language using Pthreads API to simulate the real problem, the Sleeping Teaching Assistant, using what we have studied IPC and synchronization. Refer to Section 5.9.4 for specific instructions on mutex lock and semaphore.
2. If there are multiple files in your submission, you need to provide a makefile.
3. Include the compilation command with required options at the very beginning of your code.

he Sleeping Teaching AssistantA university computer science department has a teaching assistant (TA) whohelps undergraduate students with their programming assignments duringregular ofFce hours. The TA’s ofFce is rather small and has room for only onedesk with a chair and computer. There are three chairs in the hallway outsidethe ofFce where students can sit and wait if the TA is currently helping anotherstudent. When there are no students who need help during ofFce hours, theTA sits at the desk and takes a nap. If a student arrives during ofFce hoursand Fnds the TA sleeping, the student must awaken the TA to ask for help. If astudent arrives and Fnds the TA currently helping another student, the studentsits on one of the chairs in the hallway and waits. If no chairs are available, thestudent will come back at a later time

HF(g) + H2O(l) = H3O+(aq) + F-(aq)

In the following equilibrium in a closed system, indicate how the equilibrium is shifted by the indicated stress:

(a) Additional HF(g) is added to the system.
(b) Water is added.
(c) Ca(NO3)2 solution is added, and CaF2 precipitates. (d) The volume is reduced.
(e) KOH is added.
(f) A catalyst is added.

: Write a paragraph to reflect on what you have learned about Microsoft access in terms of the difference between relational databases versus spreadsheets. Discuss ways in which a relational database could be useful for your work (if you have a job) or for your personal or professional projects (if you are a full-time student)

Consider two markets: the market for cat food and the market for dog food. The initial equilibrium for both markets is the same, the equilibrium price is $3.50$3.50, and the equilibrium quantity is 35.035.0. When the price is $9.75$9.75, the quantity supplied of cat food is 59.059.0 and the quantity supplied of dog food is 107.0107.0. For simplicity of analysis, the demand for both goods is the same.

Using the midpoint formula, calculate the elasticity of supply for dog food. Please round to two decimal places.

Why is business ethics unavoidable?