Blog

[1] Some useful resources: MySQL Documentation Structured Query Language (SQL) Practice Resources [2] All of the queries are based on the following “global company” scenario: cs4400 global banking description.pdf [3] Submit your answers using this format (one of these per quiz question): create view examQuery as …fill in your proposed answer here…; This is the same format that you’ve used when practicing with the company autograder in class over the past few weeks, the only exception being that you’ll be using “examQuery” instead of “practiceQuery”.  You are NOT permitted to use any other code (e.g., extra views, functions, stored procedures, with clauses, etc.) to form your queries on this exam. [4] Also, please be sure to use the “as” operator to rename any duplicate columns in the select clauses of your queries.  All column names must be unique for our evaluation system.  The column names aren’t actually evaluated by our testing system, but leaving duplicate column names in a single query can cause the evaluation and testing of your submission to fail. [5] There are no sorting requirements for this exam.  Some of the PDFs might show the expected result set for the initial database state in a sorted just to make it easier for you to compare your answers.  The rows in your result set don’t have to match the order of the rows as shown in the output.  The column order in your result set, however, must match the column order shown in the output for your query to be fully correct. [6] Finally, all of the queries involve the select command.  Do not submit any other queries or transactions involving these commands or their variants: insert, update, delete, create (other than creating views to save your queries), alter, or drop.

A population of 16 frogs has the following number of frogs of different genotypes:   AA = 5, Aa = 6, aa = 5, What is the frequency of the AA genotype in this population?

Directions: The following question is based on the food web (below). Which organism out of the given options acquires energy from both a primary consumer and a secondary consumer?

Directions: The following question is based on the food web (below). Which organism out of the given options acquires energy from  a tertiary consumer?

In the image below, the X axis represents the range of values of shell size in a population of snails, and the Y axis represents the frequency distribution of this trait in the population.  The frequency is shifting over time toward a single extreme phenotype, large shells.  Which type of natural selection would this be?

A population of rattlesnakes in central Arizona had 283 individuals in 2010. When reexamined in 2013, the population grew to 427. Calculate the growth rate r for the rattlesnake population over this 3-year period.   

In the image below, the X axis represents the range of values of shell size in a population of snails, and the Y axis represents the frequency distribution of this trait in the population.  The frequency is shifting over time toward both extremes (large and small shells) and away from the intermediate phenotype (medium shells).  Which type of natural selection would this be?

You are working with local conservation agencies to monitor a key population of javelina living in the Sonoran Desert (pictured below). Previous studies estimate that the typical carrying capacity of javelina populations is 500 individuals. You estimate the population size of javelina in this area to be 80 individuals in 2009 and 130 individuals in 2010. Based on this information, estimate the number of javelina in the population in the year 2011. If your calculation has decimals, round up if your decimal is 0.5 or larger, round down if your decimal is below 0.5.  Hint: start by calculating r for 2010, then use the appropriate growth formula to find what the new population size will be in 2011.  Because this is a population with a carrying capacity, you should use the logistic growth model.

What are your overall thoughts and feelings regarding the subject of Math? Do you enjoy completing math problems, or is it something you struggle with? If you have any concerns, share them in your response.

UDP and TCP use 1s complement for their checksums. Suppose you have the following three 8-bit bytes: 01010011, 01100110, 01110100. What is the 1s complement of the sum of these 8-bit bytes? Show all work. How does the receiver detect errors?