A company database needs to store information about employees (identified by ssn, with salary and phone as attributes), departments (identified by dno, with dname and budget as attributes), and children of employees (with name, age, and relationship to the employee as attributes). Employees work in departments; each department is managed by an employee; a child must be identified uniquely by name when the parent (who is an employee; assume that only one parent works for the company) is known. We are not interested in information about a child once the parent leaves the company.

Please provide me SQL statements to create the corresponding relations and capture as many of the constraints as possible.

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? and (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. 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. 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