1. Use PubMed or another abstract database to find an academic journal article on a health topic of interest to you. Read the article to find the answers to these questions:

(a) What was the main study question?

(b) Who participated in the study, where did it take place, and when was it conducted?

(c) What study design was used?

(d) What was the answer to the main study question?

2. Find a recent news story from the popular press about a newly released health research report. Look up and read the scientific article on which the news report was based. Was the news story accurate? Did it leave out any critical information?

3. Do you identify with a particular ethnic group? Do you know of any health conditions that you are at special risk for because of your ethnic background? Are these conditions genetic? Are they related to health behaviors?

4. What are some of the conditions related to poverty that increase the risk of infectious diseases? Noncommunicable disease? Neuropsychiatric disorders? Injuries?

1. Go to FRED database and find data on the 1-year Treasury Rate (GS1) and the GDP Deflator price index (GDPDEF).  For GS1 choose the frequencysetting as “quarterly”; for the (GDPDEF) set the unitssetting to “Percent Change From Year Ago”; and download both data series.  For the questions below assume inflation is a good proxy for inflation expectations.

1. From the current period of data available, compare inflation and the interest rate to what it was in 2010: Q1.  Does the Fisher effect hold? Why or why not?
2. From the current period of data available, compare the inflation and the interest rate to what it was in 1990: Q1.  Does the Fisher effect hold?  Why or why not?

Database

Problem description:1. What is the difference between a candidate key and the primary key for a given relation? What is a superkey?

2. What is a foreign key constraint? Why are such constraints important? What is referential integrity?

3. Answer teach of the following questions. The questions are based on the following relational schema:Emp(eid: integer, ename: string, age: integer, salary: real)Works(eid: integer, did: integer, pct_time: integer)Dept(did: integer, dname: string, budget: real, managerid: integer)

(1) Write the SQL statements required to create the preceding relations, including appropriate versions of all primary and foreign key integrity constraints.

(2) Define the Dept relation in SQL so that every department is guaranteed to have a manager

(3) Write an SQL statement to add John Doe as an employee with eid = 101, age= 32 and salary = 15,000

(4) Write an SQL statement to delete the Three tables: Emp, Works, Dept.

Use Excel to develop a regression model for the Consumer Food Database (using the “Excel Databases.xls”

file) to predict Annual Food Spending by Annual Household Income. Assume a 5% level of significance.

(file here: https://drive.google.com/file/d/13uDUXwoSRZHEUtjMUedu2yjR_4lrLepC/view?usp=sharing )

Must complete all the parts to this problem:

• PART 1: Perform a simple linear regression in Excel to predict Annual Food Spending by Annual Household Income and output the results. Include the Regression Statistics, ANOVA, and table of Coefficients for each model.
• PART 2: Suppose a households annual income is $60,000. Predict how much they spend on food per year. Write the model and show the work to get the answer.
• PART 3: Now, develop a regression model to predict Annual Food Spending by Annual Household Income for those living in the Metro area only and output the results. Include the Regression Statistics, ANOVA, and table of Coefficients for each model.
• PART 4: Suppose a households annual income for those living in the metro area only is $60,000. Predict how much they spend on food per year. Write the model and show the work to get the answer.

The waiting time ?W for accessing one record from a computer database is a random variable uniformly distributed between 00 and 3232 milliseconds.

The read time ?R for moving the information from the disk to the main memory is 88 milliseconds.

The random variable ?X milliseconds is the total access time (waiting time + read time) to get one block of information from the disk.

Before performing a certain task, the computer must access 99 different blocks of information from the disk. (Access times for different blocks are independent of one another.)

The total access time for all the information is a random variable ?A milliseconds.

Compute the following:

- E[X]

- Var[X]

- Standard deviation of A

- P[A>243]

- P[A<192]

Consider Retail Store database which store the details of different items available in the store and the sales of these items to different customers: Schema: Item(ItemNo, ItemName, Category, UnitPrice) Sales(SalesNo, ITemNo, SalesDate, CustomerNo, Qty) Customer(CustomerNo, CustomerName, City, Income, MobileNo) Write the following queries in Relational Algebra:

a) List the No. and Name of items in ‘ABC’ category.

b) Count the No. of categories from which the items were bought by the customer ‘Mohan Kumar’

c) List the customers who has bought all the items of ‘ABC’ category

Internal auditors sometimes check random samples of transactions within a database. Suppose that in a particular set of transactions, 2% contain an error of some kind. The auditor takes a random sample of 20 transactions for checking. Let X denote the number of transactions found to be in error in the sample.

(a) State the probability distribution of X (including the values of all parameters) and find the probability that 2 transactions are found to be in error.

(b) If three or more transactions are found to be in error then a larger sample is taken for checking. How often will this happen? (Use the appropriate template).

(c) What assumption is required for the validity of the above answers?

A private kindergarten, Happy Learning, wants to build a database to manage their operations. You were assigned to create an initial design based on the following customer description of their operations.

There are 3 age levels in the kindergarten (turtles, foxes and monkeys). At each level there 3 classes (red, blue and green). For a class we keep a code based on the initial of group color and level (e.g. RT for red turtles, GF for green foxes). Each class has a room number and a phone number. Also, each class has a maximum capacity (between 25 and 31). Also, we will keep brief directions to the class location in the building.

For a student we will keep the name, any nickname, date of birth, address, and the class in which the student is currently enrolled. We will process students based on their first and last name, or nickname, if present. We will process the address based on the city, zipcode and street to identify recruiting areas.

For each student we will keep information about one or more parents (or caretakers). A parent may have several students enrolled in the kindergarted. For a parent (or caretaker) we will keep the name, home phone number, mobile phone number, work phone number, the personal email and relationship to the child (e.g. father, mother, grandfather). At least one type of phone is required, but some parents may not provide all types of phone numbers. Some parents do not provide emails. We will process parents based on their last name.

Each class has a teacher assigned. A teacher is assigned to a single class. For a teacher we keep the name, home phone number, work email, personal email, the graduated college and their major. All the teachers must have a bachelor degree. We will process teachers based on their first and last name.

Create data for the purchase of an automobile.  There should be 10 automobiles in your database.  You can get this from the newspaper or go online and find a site that will give you some possible purchases.

You should use the following fields:   Manufacturing, Model, Year, Doors, Cylinders and Sales Price.

1. Print the spreadsheet you created for your data.

2. Create and print 2 pivot tables to find some information you need to help you make your decision.

3. Do a VLOOKUP and a HLOOKUP for the purchase selected. Print a copy of your formula and the result.

4. Use MATCH command to find what position your decision appears on the spreadsheet. Highlight your decision on your spreadsheet.

A college records the module registration information of their students in a database named College.mdb,which contains three tables,STUDENT,MODULE andMODULE_REG. A student may enroll in the same module as many times as they like. However, they can only enroll each module at most once in each semester. The design of the three tables are shown below:

Table STUDENT

Table MODULE_REG

Table MODULE

Download the database file College.mdbfrom Moodle. Rename it as College_Lxx_syyyyyy.mdb(where Lxxis your class andsyyyyyyis your student number, e.g. College_L01_s170001.mdb/College_L01_s170001.accdb) and complete the following tasks.

(a) Create a primary key of the table MODULE_REG.                                                                (1 mark)

(b)   Establish the relationships between the tables STUDENT,MODULE andMODULE_REG.      (1 mark)

(c)    Create queries to perform the following tasks:

1. Display the student IDs, studentnames (including both first name and last name), as well as the code and name of modules that each student had enrolled in the secondsemester of 2019. Arrange the records in ascendingorder of the student IDs. Save the query as Q1.
   Note: You mustnotshow the semester and the year in the output.                            

(ii) Display the total number of students in each gender. Save the query as Q2.              

3. Produce a list of module codes, module names, and the total number of enrollment records of each module. Arrange the records in ascendingorder of the total number of enrollment records of each module. Save the query as Q3.

Produce a list of module codes, module names, student names (including both first name and last name), and student IDs of enrolled students for all modules with module codes beginning with “COM” being registered in the firstsemester of 2019. Arrange the records in ascendingorder of module codes. Save the query as Q4.
Note: You mustnotshow the semester and the year in the output.