Prompt: Using the SEC’s EDGAR database, search for a large public company and download the most recent Form 10-K. This form contains all the information that must be reported annually to the SEC. Within this form, ensure that it includes footnotes, the management discussion and analysis (MD&A) sections, review each of the previously listed sections, and discuss any off-balance sheet financing, management concerns, management’s expectations for the future, and anything interesting or out of the ordinary. Feel free to supplement your search with current articles that discuss your chosen company and the industry in which it operates.

Specifically, the following critical elements must be addressed:

I. Company Selection: Select and name the public company along with the fiscal year-end of the annual report that includes footnotes and the management discussion and analysis (MD&A) sections. - Company Apple

II. Footnotes: Review the footnotes of the financial statements and describe off-balance sheet financing in general or with specific examples provided within the Form 10-K of the selected company (e.g., operating lease or through special purpose entities).

III. Management Discussion and Analysis (MD&A): Review the MD&A of the annual report. Management often discusses issues of concern in this area of their report. They also include projected financial statements, which may suggest ideas about the firm’s potential for future earnings.

a. Describe any management concerns listed and/or explain anything you find interesting or out of the ordinary.

b. Describe any projections and/or future expectations of the management.

The database for a pet supply company includes the following table, named tblCollar, that contains product data for pet collars. The ItemDesc and Color fields contain text. The ItemNum, Price, and Quantity fields contain numbers.

Which of the following clauses would allow a user to select the records for collars with a cost of between 10 and 20?

Write a SQL script to add another table to your database. Include these fields in

your Product table:

          ProductID should be the Primary Key. It is an auto-increment field.

          The Price field stores prices to 7 significant digits and to 2 decimal places.

          Add at least ten records to the Product table using INSERT.

1) Use Excel to develop a regression model for the Consumer Food Database (using the “Excel Databases.xls” file on Blackboard) to predict Annual Food Spending by Annual Household Income for those living in the Metro area only.   

Suppose a household in the metro area has an annual income of $60,000. Predict how much they spend on food per year. Write your answer as a number (do not include the $ sign or comma) and round to 2 decimal places.

Researchers investigating temperament in dogs have a database of reactivity scores from a population of N = 1000 puppies.  The reactivity scores are normally distributed with a mean of mu = 175 and a standard deviation of sigma = 20; higher scores indicate higher reactivity (that is, the puppy is more likely to become aroused by novel stimuli).

Dr. Kobe is also conducting temperament testing, but his local shelter is much smaller than Dr. Santos’.  Thus, he is only able to obtain a sample size of n = 20 puppies.

a. What is the likelihood that Dr. Kobe will obtain a mean reactivity score of 168 or lower?

b. What is the likelihood that Dr. Kobe will obtain a mean reactivity score of 190 or higher?

c. Why should the probability of obtaining a sample mean less than M = 165 be larger for Dr. Kobe than Dr. Santos?

Create a database with two tables as follows:- Students - StudentID, Name, Program FeePayment - StudentID, Date, Description, Amount 1. Create a stored procedure that receives all the details of a student including fees and proceeds to insert insert the student details into the student details and the fee payment into the FeePayment table. All the operations should be done within a single transaction in a stored procedure. Note that the stored procedure works like a function that receives parameters. Copy and submit your code for creating the tables as well as your stored procedure code in a word document.

Use Excel to develop a regression model for the Hospital Database (using the “Excel Databases.xls” file on Blackboard) to predict the number of Personnel by the number of Births. Perform a test of the overall model, what is the value of the test statistic? Write your answer as a number, round your answer to 2 decimal places.

Consider the database of a car rental company that contains three tables drivers, cars and reservation tables.

Drivers:                                           Reservation:                              Cars:

1. Write DDL statements to create the tables

Drivers(Dno, Dname, age)

Reservation(Dno, Cno, Day)

Cars(Cno, Cmake, Color)

Where:

• no field could be empty except the age of the Driver.
• The company does not own more than one car from one maker     
• the colors of the cars should not be other than the following group (blue, white, red , green)

2. Write Queries for the following:
   1. Insert the sample data shown above into the tables

3. Write Queries for the following:
   1. Find the names of drivers who have reserved car no 103.
   2. Find the names of Drivers who have reserved red or Green cars.( use IN, UNION, =SOME/=ALL, and JION    each in separate query)For this segment, 4 responses are required, using the operations shown in parentheses
   3. Find the driver Dno of drivers with age over 20 who have not reserved a read car.
   4. Find the names of drivers who have reserved all cars.
   5. List the name of the drivers along with the day they rent cars in descending order
   6. List the name of the drivers whom rent more than 3 times along with the number of the times.
   7. Change the age of Alice to 18 years old
   8. Delete the information of the drivers younger than 20 years old

You have been given the following specifications for a simple database about the requests for software that staff members make for their units (note that primary keys are shown underlined, foreign keys in bold). You should run your SQL to demonstrate that it works correctly, and paste in the statements used plus the output from Oracle.

LAB (RoomNo, Capacity)

SOFTWARE (SoftwareID, SoftwareName, Version)

REQUEST (SoftwareID, RoomNo, RequestDate, TeachingPeriod, Progress)

Based on the table specifications provided, answer the following questions. Each question is worth 3 marks.

a. Give the SQL to create the LAB and SOFTWARE tables. Choose appropriate data types. None of the attributes should be allowed to be null. Include the primary key constraints.

b. Give the SQL to create the REQUEST table. Use appropriate data types, and include the primary key and foreign key constraints. Referential integrity should be set such that if a lab is deleted from the database, any requests that exist for that lab are also deleted.

c. Give the SQL to add a record to each of the tables: LAB, SOFTWARE and REQUEST. Make up your own data (you may wish to add lab 350.2.006 to the LAB table for testing in part (e) later).

d. Give the SQL to create a constraint to the REQUEST table to restrict the possible values of Progress to the following 5: Requested, Installed, Function Testing, User Acceptance Testing, and Deployed.

e. Give the SQL to record the fact that the capacity of lab 350.2.006 has increased by 5.