Assume the following relations are given,

Student: <StudentiD, Name, Surname, Major, YearStarted>

Write necessary queries for the followings:

1- Create the table and define necessary constraints (primary key, null constraint, etc.).

2- Insert at least 5 records into the table using Insert SQL.command.

3- Select all students having a major of Computer Engineering, print their name and student ID.

4- Update starting year of all Engineering students to 2015 (use like clause).

5- Delete all student with starting year less than 2010.

6- List all records and verify the results.

7- Drop the table.

A statistics student wondered whether there might be a relationship between gender andcommuting methods among students at a high school. He surveyed 200 the high school students (92 males and 108 females) he happened to encounter around campus, asking each of them about their typical way of commuting to the college. The data from this survey appears below:

1. List the appropriate conditions for this test and explain why each has (or has not) been satisfied:

2. Compute the P-value for this test

3. State an appropriate conclusion for this test

How do I do this in R Studio?

1 Students who performed poorly on a City of New York Skills Assessment Test were enrolled in a summer math program. Scores of 10 students before and after the summer program were recorded.

They were:

Before = 18,18,21,18,18,20,23,23,21,17

After = 24,25,33,29,33,36,34,36,34,27

(Scores for individual students are in the same order in each list.) Did the NYC summer math program improve student performance significantly?

8. How many points did student scores improve on average? (hint: consult the output from question 1; it’s OK to simply write this answer – it did come from R output.)

9. What is the 95% confidence interval for the parameter of average score improvement? (hint: consult the output from question 1; it’s OK to simply write this answer – it did come from R output.)

1. Consider the following relations. The primary keys are underlined. All attributes are of type string if not indicated otherwise.

 Student(s_ID, s_name, s_degree: integer, advisorID, d_ID)

 Lecture(l_ID, l_name,l_degree: integer, p_ID, d_ID)

 Register(s_ID,l_ID,score: integer, Semester)

 Professor(p_ID,p_name, d_ID)

 Department(d_ID, d_name, address)

a. Find the names of professors who have taught in every semester.

b. List the names of lectures that the CISE department offers but that are taught by a professor whose department is not CISE.

c. Find the names of students who got the highest score in the lecture ‘Databases’.

d. Find the names of students who have registered every lecture of the CISE department.

e. Find the names of students who got more than 90 in the ‘DB’ lecture and less than 70 in the ‘Algorithm’ lecture.

A presidential candidate's aide estimates that, among all college students, the proportion p who intend to vote in the upcoming election is at least 70%. If 158 out of a random sample of 235 college students expressed an intent to vote, can we reject the aide's estimate at the 0.1 level of significance?Perform a one-tailed test. Then fill in the table below.Carry your intermediate computations to at least three decimal places and round your answers as specified in the table. (If necessary, consult a list of formulas.)

***IN C++***

Create student structure with the following fields:



Name (cstring or null-terminated character array)



Student ID (int – unique random value between 1000 and 9999)



grade (char – Values A thru F)



birthday (myDate – random value: range 1/1/2000 to 12/31/2005)



Home Town (string)

Create an array of pointers to students of size 10.

Example: Student *stuPtr[10];

Write a function that populates the array with 10 students.

Example: populate(stuPtr);

Write a display function that displays the contents of the array on the screen as shown below –

nicely formatted and left justified.

The displayed list should be nicely formatted with column names like this: All columns should

be left-justified.

Name

Student ID

Grade

Birthday

Home Town

Tom Thumb

1002

C

January 1, 2002

Small Ville

Fred Flintstone

1995

D

February 3, 2003

Bedrock

Sponge Bob

2987

B

June 3, 2001

Bikini Bottom

Create a menu that shows the following options:

1)

Display list sorted by Name

2)

Display list sorted by Student ID

3)

Display list sorted by Grade

4)

Display list sorted by Birthday

5)

Display list sorted by Home Town

6)

Exit

You need to write a sorting function for each of the menu items – 5 options needs 5 functions.

Note:

You must create a function that returns a date between a range of 2 dates.

You will use the myDate class in this program – you will not create any other class. The Student

structure is NOT a class.

Take advantage of your myDate class that you just wrote. Also, it might be helpful to create a

new function that returns a string for the date format:

string myDate::toString( );

After listening to the Crash Course video below and reading Chapter 28 on fiscal policy, discuss the pros and cons of the Keynesian versus classical economist approach to fiscal policy. Which approach do you favor? Why? Does your answer depend on the current state of the economy, such as whether or not the economy is in a deep recession or growing at a trend rate? https://www.youtube.com/watch?v=otmgFQHbaDo&list=PL8dPuuaLjXtPNZwz5_o_5uirJ8gQXnhEO&index=8

v

1. Create a graph (either a histogram, box plot or stem and leaf plot … pick just one). Your graph could have either 5, 6 or 7 classes, depending on how you set it up. Create a table and list the class boundaries and the frequency in each class. You must explain to me in detail if you used fewer than 5 classes or more than 7 classes.

Three hundred children attending an elementary school in Ethiopia without any prior history of malaria were each assigned at random to one of two groups after the investigators sought appropriate parental consent. The children in the first group received a new vaccine for malaria, and the children in the other group received a saline solution. After one year, the incidence of malaria was computed among the children based on whether they had received the vaccine or not. The children receiving the vaccine had a substantially lower incidence of malaria as a group than the children receiving the saline solution, thereby confirming the anticipated efficacy of the vaccine. What type of study is this?

• A. Randomized Controlled Trial
• B. Prospective Cohort Study
• C. Retrospective Cohort Study
• D. Case-Control Study

The following statement describes which phase of an RCT?

"Studies that gather preliminary data on effectiveness (whether the drug works in people who have a certain disease or condition). For example, participants receiving the drug may be compared with similar participants receiving a different treatment, usually an inactive substance (called a placebo) or a different drug. Safety continues to be evaluated, and short-term adverse events are studied."

• A.

  Phase 1

• B.

  Phase 2

• C.

  Phase 3

• D.

  Phase 4

1) Match the following to their description:

A. Shows the rate at which a study population decreases due to individuals dying or becoming lost to follow-up.

B. Shows mortality experience of all persons born during a particular year.

C. Shows the future life expectancy of persons born during the year, and the remaining life expectancy of persons who have reached a particular age.

1. Cohort Life Table

2. Period Life Table

3. Survival Curves

2. Match the following types of cohort studies to their description:

A. Exposure is collected in the present and individuals are followed into the future to examine outcomes.

B. Exposure is collected from the past and individuals are followed into the present to examine outcomes.

C. Exposure is collected in the present and the past and individuals are followed into the future to examine outcomes.

1. Prospective

2. Retrospective

3. Historical Prospective

3. Match the following elements of an experimental study to their description.

A. The investigator, participant, and/or statistician does not know who has placebo and who has the intervention of interest.

B. Participants start off in either one group or another, then a wash-out period ensues, and then patients are switched to the other group.

C. There is no randomization of subjects into one group or another.

1. Blinding
2. Cross-Over Design

3. Quasi-Experimental