Three relational schemas are given below.  Customer (customerID, email, address, age) Product (productID, name, description) Order (productID, productQuantity, customerID, shippingDate) NOTE: Express each of the provided information needs as a relational algebra query using only projection (π), selection (σ), renaming (ρ), inner joins (⋈), set union/intersection (∪,  ∩), and division (/). You may write your queries using either the symbol (i.e. π) using the ‘Insert Math Equation’ option or the operations’ word terminology (i.e. projection). (1) Find the ID’s of customers which have ordered a quantity greater than 50 of any product. (2) Find the ID’s of products which have been ordered by a customer between 18 and 24 years old (inclusive).

You are a geneticist who is analyzing a human pedigree for a new disease and discover that the disease occurs with the same frequency in both sexes and that 25% of the children from two unaffected heterozygous parents have the disease. This disease is displaying _________ _________ inheritance. (please fill two words separated by space only, please dont use special characters)

Huntington’s disease (HD) is caused by a mutation in the Huntingtin gene. The disease has an average age of onset of 35 and the majority of individuals that are affected are heterozygotes.  What is the probability that a 30-year-old man with no symptoms and who is the son of a man that has HD and a mother who does not will have a child that will have the mutant HD allele?

3) Consider the following fragment: legitimate code            if data is Friday the 13th;                  crash_computer();            legitimate code What type of malicious software is this?

6) In order to implement a DNS amplification attack, the attacker must trigger the creation of a sufficiently large volume of DNS response packets from the intermediary to exceed the capacity of the link to the target organization. Consider an attack where the DNS response packets are 500 byes in size (ignoring framing overhead). How many of these packets per second must the attacker trigger to flood a target organization using a 0.5-Mbps link? (2 points) A 2-Mbps link? (1 point) Or, a 10-Mbps link? (1 point) If the DNS request packet to the intermediary is 60 bytes in size, how much bandwidth does the attacker consume to send the necessary rate of DNS request packets for each of these three cases (0.5-Mbps, 2-Mbps, and 10-Mbps)? (3 points) How many times is the amplification attack over (or, based on) the DNS request? (1 point) 

The model below uses 11 factors to try to predict the quality of wine (from users ratings in an App).  Which factor is most significant? SUMMARY OUTPUT Regression Statistics Multiple R 0.743620952 R Square 0.552972121 Adjusted R Square 0.423569313 Standard Error 0.8676918 Observations 50 ANOVA   df SS MS F Significance F Regression 11 35.39021571 3.217292 4.273262 0.000378 Residual 38 28.60978429 0.752889 Total 49 64         Coefficients Standard Error t Stat P-value   Intercept -128.7875174 186.3285262 -0.69119 0.49365 Fixed Acidity -0.15757251 0.213770645 -0.73711 0.465582 Volatile Acidity -1.77494925 1.118665087 -1.58667 0.120875 Citric Acid -0.502495176 1.169723269 -0.42958 0.669924 Residual Sugar -0.085626394 0.183183516 -0.46744 0.642858 Chlorides -8.058523185 3.80827852 -2.11605 0.040949 Free Sulfur Dioxide -0.01930349 0.023698641 -0.81454 0.420411 Total Sulfur Dioxide 0.000282401 0.009041403 0.031234 0.975246 Density 136.7438906 189.8231622 0.720375 0.475702 pH -1.477145969 1.740309883 -0.84878 0.401317 Sulphates 0.460415706 0.808816205 0.569246 0.572539 Alcohol 0.592295943 0.2253036 2.628879 0.012295  

Using the model above we became curious if drill type and depth interacted so that the slope of the drilling time with depth changed depending on the type of drilling.  To test this a new model was made that included a type*depth term to examine the interaction between time and depth.  A partial regression output is below.   Y = Drill time of a 5 ft segment in minutes Depth = Depth of the hole in ft when the 5 ft segment was begun Type = Wet = 1, Dry = 0 Depth*Type = Depth interaction with Type ANOVA   df SS MS F Significance F Regression 3 7.43385E-25 Residual 96 Total 99 179.6004         Coefficients Standard Error t Stat P-value     Intercept 6.002882 0.215886 27.80576 1.02E-47 Type 1.909135 0.305309 6.253116 1.11E-08 Depth 0.004459 0.001474 3.025864 0.003182 Type*Depth 0.001538 0.002084 0.737888 0.462382     What conclusion below can be reached?

In response to low blood glucose levels, the pancreas produces the hormone glucagon. Glucagon functions by binding to molecules on the surface of liver cells, causing changes in cellular activity that lead to the release of glucose into the blood. The proteins to which glucagon binds are ____.​

To visualize objects smaller than those that can be resolved by a light microscope, a(n) ____ microscope is used.

​Bacteria and archaea were originally classified as prokaryotes because they ____; however, it is now known that archaea ____.