1. Create a table with name “S_YOURStudentID” with the following fields with required constraints. Screenshots are to be attached.                                                                                              

For example, if your botho student id is 1212121, your table name should be “S_1212121”.                                  

1. Student id
2. Student Name
3. Age
4. Gender
5. City
6. Course name
7. Module Name
8. Internal mark 1
9. Internal mark 2
10. Internal mark 3
11. Total internal mark

2. Insert minimum 10 records/rows to the table. Input the data based on Question 5. Screenshots are to be attached.                                                                                                                             
3. Create two users and assign different default and temporary table spaces. Screenshots are to be attached for each step.                                                                                                             
4. Create two roles named admin and user. Admin has the full privileges to access the table and user has only the READ privileges to the table. Screenshots are to be attached for each step.            
5. Write a SQL query for the following scenario. Screenshots with queries and outputs are to be attached

1. Write a Query in SQL to list all the students.
2. Write a Query in SQL to list all the name of students of six characters long and name starts with ‘A’ and ends with ‘S’
3. Write a Query in SQL to display all the information of the students together with the Total Internal mark.
4. Write a Query in SQL to list the students whose gender is ‘male’ and the age is above 25.
5. Write a Query in SQL to list the students whose total internal mark is greater than 80.

A school psychologist wishes to study the influence of three new curricula plans on the history achievement of junior high school students. Although the groups of students were selected on a fairly random basis, the psychologist has learned that there is considerable disparity among the groups with respect to verbal aptitude.

What is the appropriate design to use in this study?

Why is the design you named about appropriate?

List ALL variables involved in this design

State the appropriate research question

A school psychologist wishes to study the influence of three new curricula plans on the history achievement of junior high school students. Although the groups of students were selected on a fairly random basis, the psychologist has learned that there is considerable disparity among the groups with respect to verbal aptitude.

What is the appropriate design to use in this study?

Why is the design you named about appropriate?

List ALL variables involved in this design

State the appropriate research question

A school psychologist wishes to study the influence of three new curricula plans on the history achievement of junior high school students. Although the groups of students were selected on a fairly random basis, the psychologist has learned that there is considerable disparity among the groups with respect to verbal aptitude.

What is the appropriate design to use in this study?

Why is the design you named about appropriate?

List ALL variables involved in this design

State the appropriate research question

A school psychologist wishes to study the influence of three new curricula plans on the history achievement of junior high school students. Although the groups of students were selected on a fairly random basis, the psychologist has learned that there is considerable disparity among the groups with respect to verbal aptitude.

What is the appropriate design to use in this study?

Why is the design you named about appropriate?

List ALL variables involved in this design

State the appropriate research questionv

A school psychologist wishes to study the influence of three new curricula plans on the history achievement of junior high school students. Although the groups of students were selected on a fairly random basis, the psychologist has learned that there is considerable disparity among the groups with respect to verbal aptitude.

What is the appropriate design to use in this study?

Why is the design you named about appropriate?

List ALL variables involved in this design

State the appropriate research question

A school psychologist wishes to study the influence of three new curricula plans on the history achievement of junior high school students. Although the groups of students were selected on a fairly random basis, the psychologist has learned that there is considerable disparity among the groups with respect to verbal aptitude.

What is the appropriate design to use in this study?

Why is the design you named about appropriate?

List ALL variables involved in this design

State the appropriate research question

A school psychologist wishes to study the influence of three new curricula plans on the history achievement of junior high school students. Although the groups of students were selected on a fairly random basis, the psychologist has learned that there is considerable disparity among the groups with respect to verbal aptitude.

What is the appropriate design to use in this study?

Why is the design you named about appropriate?

List ALL variables involved in this design

State the appropriate research question

A school psychologist wishes to study the influence of three new curricula plans on the history achievement of junior high school students. Although the groups of students were selected on a fairly random basis, the psychologist has learned that there is considerable disparity among the groups with respect to verbal aptitude.

What is the appropriate design to use in this study?

Why is the design you named about appropriate?

List ALL variables involved in this design

State the appropriate research questionv

Consider a damped forced mass-spring system with m = 1, γ = 2, and k = 26, under the influence of an external force F(t) = 82 cos(4t).

a) (8 points) Find the position u(t) of the mass at any time t, if u(0) = 6 and u 0 (0) = 0

. b) (4 points) Find the transient solution uc(t) and the steady state solution U(t). How would you characterize these two solutions in terms of their behavior in time?

c) (4 points) Find the amplitude R and the phase angle δ for this motion and express U(t) as a single trigonometric term: U(t) = R cos(ωt − δ).

d) (4 points) Justify the following description of what happens: “the transient motion uc(t) dies out with the passage of time, leaving only the steady state periodic motion U(t)

which two of the following study design are best for assessing temporality, please select two?
a)cohort
b)experimental
C) cross sectional
d) ecological
E) case control

Discuss how ”Kurt lewin's” and “Bridges’ model” of transition might be used by a leader and what role he might play as a change agent while people are transiting from one stage to another. ( 400 words)

Higher unemployment caused by the recession and higher gasoline prices have contributed to a substantial reduction during 2008 in the number of vehicles on roads, bridges, and in tunnels. According to The Wall Street Journal (April 28, 2009), the reduction in demand for toll bridge and tunnel crossing created a serious revenue problem for many cities. In New York, the number of vehicles traveling across bridges and through tunnels fell from 23.6 million in January 2008 to 21.9 million in January 2009. “That drop presents a challenge, because road tolls subsidize MTA subways, which are more likely to be used as people get out of their cars.” In an apparent attempt to rise toll revenue, the MTA increased tolls by 10 percent on the nine crossings it controls.

Puzzle #4

Five friends each wrote a letter to Santa Claus, pleading for certain presents. What is the full

name of each letter-writer and how many presents did he or she ask for? Kids’ names: Danny,

Joelle, Leslie, Sylvia, and Yvonne. Last names: Croft, Dean, Mason, Palmer, and Willis. Number

of presents requested: 5, 6, 8, 9, and 10.

Clues:

1. Danny asked for one fewer present that the number on Yvonne’s list.

2. The child surnamed Dean asked for one more present than the number on the list written by

the child surnamed Palmer.

3. Sylvia’s list featured the fewest presents, and the letter written by the child surnamed Willis

featured the highest quantity.

4. Joelle asked for one fewer present than the number specified in the Croft child’s letter.

Make your grid to solve:

Croft

Dean Mason Palmer Willis

5

6

8

9

10

Danny

Joelle

Leslie

Sylvia

Yvonee

5 presents

6 presents

8 presents

9 presents

10 presents

Your final answers to puzzle 4:

I need a Java application with a GUI that includes the following requirements:

• Three classes minimum
• At least one class must use inheritance
• At least one class must be abstract
• Utilization of “get set” method. (get; set; =  is related to how variables are passed between different classes. The get method is used to obtain or retrieve a particular variable value from a class. A set value is used to store the variables. The whole point of the get and set is to retrieve and store the data values accordingly). See below for example of the get set method. V V V V V V V V V V V V V V V
• toString method
• polymorphism
• JavaFX front end – as you will see, JavaFX will allow you to create a GUI user interface.
• The User Interface must respond to events.
• If the application requires a data backend, you can choose to use a database or to use text files. I would prefer text files.
• Error handling - The application should be able to handle invalid data.

I was thinking of something with an ordering system for a restaurant, or something with a school, students, instructors, ID’s, grades, and GPA’s.  

The deliverables needed will be the code and GUI, along with a UML that shows the classes.

Example of get; set; method.

{
abstract class Photo
{
public double Height { get; set; }
public double Width { get; set; }

public double Price { get; set; }

public abstract void DisplayPhotoInfo();

}
}

List some preventive and control measures for students regarding alcohol and drugs abuse