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.

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.