1. Recall that a database has many types of users, each of whom may require a different view of the database. The database user responsible for creating database accounts in a DBMS like Oracle is called the:
   1. The database administrator (DBA)
   2. Database end user
   3. DBMS system builder
   4. Database designer
   5. none of the above

2. Which of the following can be an example of a multi-valued attribute in ER modeling of a database?

1. address
2. last name
3. middle name
4. country
5. none of the above

3. One limitation of traditional file system, which runs programs with data, that is solved by using a database management system is:
   1. Provision of data independence
   2. Separation of data from program using the three data level architecture
   3. Replication of data and programs
   4. Use of the internet
   5. none of the above
      
4. In a database, integrity constraints must not be violated after any database update. Given a database table with schema Customer (Id, Fname, Lname, phone), which has a state having the two tuples <1, ‘Mark’, ‘Adam’, ‘416-555-2233’> and
   <2, ‘Pat’, ‘Moore’, ‘519-333-6161’>, what integrity constraint is violated by inserting the following new tuple into Customer
   <1, NULL, ‘Hardy’, ‘226-222-1234’>.
   1. Semantic Integrity constraint
   2. Foreign key referential integrity constraint
   3. Primary Key integrity constraint
   4. All of the above
   5. none of the above

Tunnel Problem

You are going to build a tunnel 10 miles long with a shaft at one end and a portal at the other. It is part of the first phase of the gateway tunnel to New York.

* The shaft is 185 ft. deep to the invert of the tunnel and 22 ft. excavated diameter.

* The tunnel is 26 ft. excavated diameter in competent sandstone and limestone.

* The profile of the shaft is as follows: From the surface down- 15 feet of fill; 30 feet of sand and clay; 20 feet of silty gravel; 40 feet of limestone and 80 feet of sandstone.

* Groundwater is 35 feet down.

* The tunnel runs for 5 miles in sandstone and 5 miles in limestone.

Determine the following:

1. Using a TBM, how long will it take to excavate the tunnel?

2. Will blasting need to be done anywhere? If so, where?

what is the total future value six years from now of $50 received in one year, 200received in two years and $800 received in 6 years if the discount rate is 8%

Use the Happy1 variable.  Suppose someone claims the population mean is 55 and the standard deviation is 10.

For now, assume both of the claims about the population are correct.

1a. Given the assumed pop. mean and st.dev, calculate the probability of observing a value above the number for the first data point.

In Java:

Write two advanced sorting methods of your choice: (Shell Sort OR Radix Sort) AND (Merge Sort OR Quick Sort). If you choose Shell Sort, experiment with different incremental sequences to see how they affect the algorithm's run time efficiency (count the number of comparisons and exchanges). If you choose to implement Radix Sort, answer the following question as well: Can you write a version of Radix Sort for String objects? If yes, explain how. If not, explain why.

Assume that input data is generated randomly and stored in a text file.

You will experiment with your program in two steps:

Step 1: Experimenting with a prototype data (integers from 1 to 10) to ensure that your implementation works correctly and the results match expectations. The results must be reported in a table format (not generated by the program, but collected manually from multiple program runs) in the a Word document as follows:

                 best case         worst case        average case

          char.1...char.N   char.1...char.N   char.1...char.N

alg.1        ...       ...             ...     ...                 ...      ...

alg.2        ...       ...             ...     ...                 ...      ...

  ...  

alg.N      ...       ...              ...     ...                 ...      ...

Step 2: Experimenting with large data sets of 2000 elements. The results must be reported in the same table format.

In addition, in the report, explain the empirical results generated by your program comparing them to the known theoretical results paying special attention to any discrepancies which must be clearly explained.

Must submit for grading: the java code, the random text file(s) generated by an independent module (you may need multiple random text files to better characterize the average efficiency of the respective algorithm), AND MOST IMPORTANTLY the report as explained above a Word document.

using python

#You've been sent a list of names. Unfortunately, the names
#come in two different formats:
#
#First Middle Last
#Last, First Middle
#
#You want the entire list to be the same. For this problem,
#we'll say you want the entire list to be Last, First Middle.
#
#Write a function called name_refixer. name_refixer should have two
#parameters: an output filename (the first parameter) and the
#input filename (the second parameter). You may assume that every
#line will match one of the two formats above: either First Middle
#Last or Last, First Middle.
#
#name_refixer should write to the output file the names all
#structured as Last, First Middle. If the name was already structured
#as Last, First Middle, it should remain unchanged. If it was
#structured as First Middle Last, then Last should be moved
#to the front and a comma should be added after it.
#
#The names should appear in the same order as the original file.
#
#For example, if the input file contained the following lines:
#David Andrew Joyner
#Hart, Melissa Joan
#Cyrus, Billy Ray
#
#...then the output file should contain these lines:
#Joyner, David Andrew
#Hart, Melissa Joan
#Cyrus, Billy Ray

#Add your code here!

#The code below will test your function. You can find the two
#files it references in the drop-down in the top left. If your
#code works, output_file.txt should have the text:
#Joyner, David Andrew
#Hart, Melissa Joan
#Cyrus, Billy Ray
name_refixer("output_file.txt", "input_file.txt")
print("Done running! Check output_file.txt for the result.")

#If you accidentally erase input_file.txt, here's its original
#text to copy back in (remove the pound signs):
#David Andrew Joyner
#Hart, Melissa Joan
#Cyrus, Billy Ray

During the past 10 years, the percent returns on two mutual funds (aggressive and passive) expressed in percentages were as follows:

Note that this is a sample of returns.

a) Compute the expected return for the two funds. Round your answers to two decimal places.

Aggressive =  

Passive =  

b) Compute the variance and standard deviation of the returns of the two funds. Round your answers to two decimal places.

Variance:

Aggressive =  

Passive =  

Standard Deviation:

Aggressive =  %

Passive =  %

During the past 10 years, the percent returns on two mutual funds (aggressive and passive) expressed in percentages were as follows:

Note that this is a sample of returns.

a) Compute the expected return for the two funds. Round your answers to two decimal places.

Aggressive =  

Passive =  

b) Compute the variance and standard deviation of the returns of the two funds. Round your answers to two decimal places.

Variance:

Aggressive =  

Passive =  

Standard Deviation:

Aggressive =  %

Passive =  %

Great Plains Roofing and Siding Company, Inc., sells roofing and siding products to home repair retailers, such as Lowe’s and Home Depot, and commercial contractors, the owner is interested in studying the effects of several variables on the value of singles sold($000). The marketing manager is arguing that the company should spend more money on advertising, while a market researcher suggests it should focus more on making its brand and product more distinct from its competitors.

The company has divided the United Stated into 26 marketing districts. In each district it collected information (Please check the Data for Homework on Moodle) on the following variables: volume of sales (in thousands of dollars), advertising dollars (in thousands), number of active accounts, number of competing brands, and a rating of district potential.

Please conduct regression analysis and demand estimation (show all five steps and the details), then give the managers some suggestions.

(For computing elasticity, assume Adv=8. Number of accounts=30, number of competitors=12, market potential=8)

Great Plains Roofing and Siding Company, Inc., sells roofing and siding products to home repair retailers, such as Lowe’s and Home Depot, and commercial contractors, the owner is interested in studying the effects of several variables on the value of singles sold($000). The marketing manager is arguing that the company should spend more money on advertising, while a market researcher suggests it should focus more on making its brand and product more distinct from its competitors. The company has divided the United Stated into 26 marketing districts. In each district it collected information (Please check the Data for Homework on Moodle) on the following variables: volume of sales (in thousands of dollars), advertising dollars (in thousands), number of active accounts, number of competing brands, and a rating of district potential. Please conduct regression analysis and demand estimation (show all five steps and the details), then give the managers some suggestions. (For computing elasticity, assume Adv=8. Number of accounts=30, number of competitors=12, market potential=8) Sales Ad Dollars