Consider the student-section-takes DB for an education institution:

student(id, name, dept_name, tot_cred)

section(course_id, sec_id, semester, year, building. room_number, time_slot_id)

takes(ID, course_id, sec_id, semester, year, grade)

Give a SQL query for each of the following operations:

a. Find the buildings of sections taken by Shankar. (hint: join tables, Shankar is a student name)

b. Find all id's of students who have total credit of at least 100 or taken a course with course_id: CS-101 (hint: union)

c. Find the names of students who have not taken a course with course_id: CS-101. (hint: set difference)

d. Find the student id's of students with total credits over 80 who have not taken a course with course_id: CS-101. (hint: set difference)

What policies are in place to encourage immigration into the U.S.? What policies are in place to discourage immigration into the U.S.? What do you think of these policies?

Calculate the mean repeat unit molar mass for a sample of poly[ethylene-stat-(vinyl acetate)]that comprises 12.9 weight percentage (wt%) vinyl acetate repeat units. Given that its number-average molar mass is 39.870 g mol. calculate the number-average degree of polymerization of the copolymer.

Answer: mean repeat unit molar mass of the copolymer = 30.67 and the number-average degree of polymerization of the copolymer =1300

How do public issues get on the agenda of the legislature?

1.A moving ball(1) collides elastically with an identical stationary ball (2). Ball(2) shoots off to the right along the x axis. What is the final velocity of ball(1) and the final speed of ball (2)?

-------

2.a massless rigid rod with x1=0, m1=6kg, x2=1, m2=2kg

a.what is xc the centre of mass?

b.A force 8*10^10Ng^ (upward) hits m2 for deltaT=10^-10s.

the instant after, what is the final velocity of m2?

c.what is the final velocity of the center of mass and the final angular velocity about the centre of mass?

To be written in C++. A local movie theater has three ticket windows and two computerized ticket kiosks. Some transactions, such as group discounts, can only be done at the ticket windows. An arriving customer looks at the lines, and chooses to stand in the shortest one that can handle his or her transaction. Group sales take four minutes to process. Normal ticket sales take two minutes at a window and three minutes at a kiosk. Internet ticket sales pickups take one minute at a kiosk and two minutes at a window. Write a simulation of this process, using queues to represent the five lines. The data set should consist of randomly arranged customer arrivals, with 5% group sales, 20% Internet ticket sales pickups, and 75% regular ticket sales. A data set will contain 200 customers. All of the customers tend to arrive shortly before the start of a movie, so we are simplifying the simulation to say that they all arrive at the same time. From this simulation, the theater wants you to determine the maximum length of each line, the average waiting time for each line, and the time required for each line to empty. As a hint, think about using a list to create the data set by adding 10 group, 40 Internet, and 150 regular customers and then shuffling the list. The list is then traversed, transferring each customer to the shortest queue that can handle the customer’s transaction.

Java

Write a program that will define a hierarchy of classes for Insect, Butterfly, Bee, and Mosquito, and define the attributes that are common to all in the superclass, while defining customized attributes in each subclass. Common attributes may include numberOfWings, numberOfLegs, numberOfEyes. Come up with at least 1 additional attribute for each subclass. Define a polymorphic method, fly(), at each level of the hierarchy, which will print the an imaginary sound that the insect will make when it flies. Define a constructor for each class that will receive the number of wings, the number of legs, and the number of eyes.

Next, write a driver class that will create an arrayList of Insect objects. In the arrayList, add an instance of each of the subclasses, Butterfly, Bee, and Mosquito. Once the arrayList is populated, iterate through the arrayList, and call the polymorphic method fly() for each member of the arrayList. Then, end the program.

Two particles, m₁ = 2m and m₂ = m, are suspended on massless cords of the same length l = 1.00 m so that they touch each other (see Fig. below). Particle 1 is displaced to an angle of 30

(Signalling and Screening) What roles do signalling and screening play in a labour market with asymmetric information?

Metallic vanadium, V, can be obtained from its oxide from the reaction below.

V₂O₅(s) + 5Ca(l) = 2V (s) + 5CaO(s)

If 100. g of V₂O₅ is reacted with 500.0 g of Ca, how many grams of V can be produced?

Consider the following reaction

A(aq) <=> 2B(aq) Kc= 9.07x10^-6 at 500K

If a 4.90 M sample of A is heated to 500 K, what is the concentration of B at equilibrium?

(C++ program)

Write and Design a Star Class definition.

Attribute of a Star are :
- radius
- age
- coordinates in space: x,y.z
Behaviors of a Star are:
- calculateVolume()
- calculateSurfaceArea()
- calculateCircumference()
- DisplayCoordinates()
- DisplayStar()

be sure to supply constructor() method(s) and all your set() and get() methods. The above is only a generic description of the class Star. You will need to design the datatypes, method return values, method parameters, etc...

Sphere Formulas in terms of radius r:

• Volume of a sphere:
  • V = (4/3)πr³
• Circumference of a sphere:
  • C = 2πr
• Surface area of a sphere:
  • A = 4πr²

, you will be writing a simple calculator program that gets input from the user, does some calculation, and outputs the results to the user. Your program must have at least one input and at least one output, but you can choose the type of calculator you want to write. Some examples are:

Converting Celsius to Fahrenheit,

Questions 28-35 are related to the following The following table is the regression summary output for a model depicting the impact of years of schooling (EDUCTION) on hourly wage rate (WAGE). SUMMARY OUTPUT Regression Statistics Multiple R 0.47100 R Square Adjusted R Square 0.22106 Standard Error Observations 1000 ANOVA df SS MS F Significance F Regression 1 284.5202001 2.3433E-56 Residual 142.4243578 Total 999 182662.1158 Coefficients Std Error t Stat P-value Lower 95% Upper 95% Intercept 1.6551 -3.8378 0.0001 -9.6000 -3.1041 EDUCATION 0.0000 Use the following calculations first: ∑xy = 310428.68 x = EDUCATION n = 1000 y = WAGE x̅ = 13.907 y̅ = 20.83103 ∑x² = 204011 28 The model predicts that wage rises by _______ for each additional year of schooling. a $2.16 b $2.11 c $2.05 d $1.95 29 The predicted WAGE for 16 years of schooling is, a $26.44 26.44 b $25.67 25.67 c $24.92 24.92 d $23.93 23.93 30 SSE = ______ a 142139.51 b 140718.11 c 139310.93 d 137917.82 31 The measure of closeness of fit, or measure of dispersion of observed expenditure on food around the regression line is, a 10.24 b 11.93 c 12.12 d 12.85 32 The fraction of the variations in WAGE explained by years of schooling is, a 0.2218 b 0.2440 c 0.2562 d 0.2690 33 se(b₁) = ______ a 0.312 b 0.225 c 0.198 d 0.116 34 The test statistic to test the hypothesis that years of schooling has no impact on wage is, a 18.227 b 16.868 c 14.645 d 9.936 35 The upper end of the 95% interval estimate for the population slope parameter is, a 3.16 b 2.95 c 2.18 d 1.88

Solve the following programming problems using object-oriented programming in Java. Provide the problem code and screenshot of the test run.

COIN TOSSING: Write a program that simulates the toss of a coin. Provide a menu of two options: toss and quit. Count the number of times each side of the coin appears and display the results after each toss. The program should have a method called flip() that is called, takes no arguments and returns a Coin enum value (HEADS or TAILS).

GUESS THE NUMBER: Write a program that plays a game of guess the number. Generate a random integer between 1 and 500. When the player inputs a number, evaluate if the number is too low or too high and let the user know. When the user guesses the number correctly, display how many tries it took for the user to correctly guess the number.

Create a method that receives the guess number as a parameter and returns true if the user guessed the number correctly and false if the user hasn’t guessed the number. The evaluation of high or low should occur in the method.

You can pass the value of the randomly generated number to the method or declare it as static before the main method.