Write an AFTER Insert trigger for the following Employee table. Check Date of Birth and calculate age. Update AGE field with calculated value in Employee_Info table

• Employee (Emp_ID int, DOB date)

• Employee_Info (Emp_ID int, Fname char, Lname char, Age int)

• Set variable Current_Date to CURDATE()

• Substract DOB from Current_Date to find Age

--Know how to nest subqueries: in, not in, some, all, and exists. Know how to nest queries in the from clause. Be able to use the with clause. Be able to use scalar subqueries.
--Know how to use correlation variables in subqueries.
--Know how to use case in queries.
--Know how to insert, delete, and update using subqueries.

Study guide please give examples

A JavaFX question

a method called generate2Num(Pane, pane){};

A botton "botton1" that botton.setOnAction(e-> {}); calling generate2Num method and show the numbers on Scene.

Every time the user clicks botton1, the updated number will show on the Scene.

I just wanna know how can I update my data by click the button.

Please show the code , thank you

1. The probability of aneuploidy offspring is greatest for?

a. Non disjunction in meiosis

b. Non disjunction in meiosis I and II

c non disjunction in meiosis I

d non disjunction in meiosis II

2. Individuals having one complete set of chromosomes in addition to the normal diploid complement are termed:

a tetraploid

b trisomic

c triploid

d aneuploid

What are the historical and theoretical origins of non-governmental, non-profit, and faith-based?  

Determine the boiling point of a solution if the molality of a non-ionizing and non-volatile solute was 0.592 mol/kg. (The boiling point elevation constant for water is 0.51oC/m.)

Determine the freezing point of a solution is the molality of a non-ionizing solute was 0.467 mol/kg. (The freezing point depression constant for water is 1.86 ^oC/m.)

What is the mole fraction of Compound A in a mixture containing 2.56 g of compound A (MM = 175.4 g/mol) and 5.7 g of Compound B(MM = 216.1g/mol)?

What is the molality of Compound A in a solution containing 8.98 g of Compound A(MM = 110.4 g/mol) and 98.86 g of water (MM = 18.0 g/mol)?

Determine the molarity when 21.9 g of Compound A (MM = 148.8 g/mol) are dissolved into enough water to make a solution of 684 mL. (Do not include units.)

What is the percent by mass of copper in an alloy containing 3.35 g of copper and 7.47 g of nickel?

What is the mass of a compound needed to make a 249.0 mL of a solution with a molarity of 4.67 M? The molar mass of the compound is 156.9 g/mol. (Do not include units)

Regarding Python and Scripting

1. What SQL clause is used to combine rows from two or more tables, based on a related column in a relational database.

Question options:

2. The highlighted portion of this program output indicates ____________.

Tracks:

(u'Thunderstruck', 20)

(u'My Way', 15)

Question options:

3. In technical descriptions of relational databases, the concept of column is formally referred to as ____________.

Question options:

4. What is wrong with this SELECT statement?

SELECT FirstName LastName

FROM TableName

Question options:

5. What is meant by this error message in the SQL query window:

Cannot insert explicit value for identity column in table 'Tracks'

Question options:

6. What is returned by this SQL SELECT statement?

SELECT LoginID, JobTitle, BirthDate

FROM Employee                                                       

WHERE JobTitle Like '%Engineer%'                   

Question options:

7. An integer that is automatically assigned by the database to link rows from different tables together is referred to as ______________.

Question options:

8. Which of the following conclusions about the table Follows is INCORRECT?

CREATE TABLE Follows

(from_id INTEGER, to_id INTEGER, UNIQUE(from_id, to_id) )

Question options:

ou are the Senior Systems Administrator for a community based charity. Your charity is involved in locating and providing accommodation, mental health services, training and support services to disadvantaged people in the community. Your charity currently runs a small datacentre that has some 50 x86 64 bit servers running mainly Windows Server 2008 R2 for desktop services, database and file services. It also has about 10 Red Hat Enterprise Linux 5 servers for public facing Web pages, services and support. Your charity is considering joining a community cloud provided by a public cloud vendor in order to provide a number of applications to all 500 support staff and administrative users. The community cloud would also be used to store the charity’s 200TB of data. This data contains a considerable amount of confidential information about the people to whom the charity provides services. A small number of the charity’s applications are mission critical and the data that those applications use is both confidential and time sensitive. The cloud vendor has made a presentation to management that indicates that operational costs will drop dramatically if the cloud model is adopted. You are asked to assess whether this model is in the best interests of the business. 1. Describe the steps that you would take to do a Risk Management assessment of this proposal. 2. Ramgovind, Eloff and Smith proposed in their 2010 paper that an information security analysis should include the requirements of Identification and authorisation, authorisation, confidentiality, Integrity, non-repudiation and availability. Discuss whether these requirements are adequate for a proper security assessment for a proposed move to an IaaS model for the charity. 3. A potential migration to the Cloud raises many issues around Governance. Discuss the governance issues that you see arising from a migration of on-premise servers to an IaaS model. 4. The charity’s board has proposed a move to migrate its servers to an IaaS model. Discuss the methods that you would propose to the board to assess the SLA of the Cloud Provider. 5. The board has decided, as an initial step, to move the office automation and database servers to the AWS cloud in order to begin the migration process, and test their strategy. Describe the steps that you would include in the plan to migrate these services.

looking for more specific answer for question 4 and 5