The human body maintains its internal temperature through thermoregulation, and a healthy adult has a mean body temperature of 98.6 °F.

The processes of thermoregulation begin to deteriorate in older age, making it difficult to diagnose elderly patients who might have an illness. To understand the body temperature of elderly patients, researchers randomly sampled the body temperatures of elderly patients from a large database of medical records where the body temperatures were normally distributed.

Conduct a two‑tailed, one‑sample ?-test

to determine whether the mean body temperature of the elderly patients is different from that of a healthy adult using the sample data provided (in degrees Fahrenheit). Use a significance level of ?=0.05.

96.6,96.7,96.8,97.4,97.4,97.8,97.8,98.2,98.4,98.9

Q 3 b)

In this question you must write a php script to take Name[input = text], Country[input = select, card_number[input = number], and type of card[input = radio button]to get user's input. The name of this file will be payment.php.

Once the user submits the form; you must direct all the information to cust_info.html.

The task is to keep a record in the cust_info.html of all the users who fill the forms and hit submit.

the output must populate the list in the form of;

Tiger Woods; CA;123456789123545698; VISA

Lucky Mann; FL; 2365415698712365478; MASTER CARD

...............................................

..............................................

up to six forms of info.

Alert: you can only use  PHP and HTML. NO JavaScript or database [20 points]

As you begin to assess the financial statements of a corporation, you would use many different tools. Please discuss the purpose of each tool/process below along with the insight that you would expect to attain from each:

Vertical and horizontal analysis of the income statement and balance sheet

Cash flow analysis

Deep-dive review of account balances

Ratio analysis

You should also apply additional technical tools including:

Structured Query Language (SQL)

Open Database Connectivity (ODBC)

Digital Analysis

Outlier Investigation

Stratification

Summarization

You should consider how each of these financial tools can provide insight into the company and help to develop a list of “red flags.”

SQL injection works as follows

Database

Normalize the relations to BCNF:

Member- (MemID, dateJoined, firstName, lastName, street, city, state, zip, areaCode, phoneNumber, currentOfficeHeld)

Play- (title, author, numberOfActs, setChanges)

Sponsor- (sponID, name, street, city, state, zip, areaCode, phoneNumber)

Subscriber- (subID, firstName, lastName, street, city, state, zip, areaCode, phoneNumber)

Production- (prodyear, seasonStartDate, seasonEndDate, title)

Performance – (perfyear,perfdate, time, seasonStartDate)

TicketSale- (saleID, saleDate, totalAmount, perfyear, perfdate,subID)

DuesPayment- (MemID, duesYear, amount, datePaid)

Donation – (sponID, donationDate, donationType, donationValue, prodYear, seasonStartDate)

Ticket- (saleID, seatLocation, price, type)

Member - Production-(MemID, prodYear, seasonStartDate, role, task)

When CQ University’s computers began acting sluggishly, computer operators were relieved when a software trouble-shooter from DELL called. When he offered to correct the problem they were having, he was given a login ID and password. The next morning, the computers were worse. A call to DELL confirmed the university’s suspicion: someone had impersonated a DELL repairman to gain unauthorized access to the system and destroy the database. CQ University was also concerned that the intruder had devised a program that would let him get back into the system even after all the passwords were changed. a) What techniques could the imposter have implemented to breach the university’s internal security? ____________________

Draw an ER diagram containing the ConferenceSeries, 
the ConferenceEvent, and the ConferenceTrack
entitysets where each ConferenceSeries can be linked 
to zero or many ConferenceEvent entities, and each 
Conference Event may be linked to one or many 
ConferenceTracks. ConferenceTrack should not exists 
without a ConferenceEvent. Choose an appropriate 
relationship name. Then augment the model with an 
entityset Venue and a relationship named OrganizedAt
associating each ConferenceEvent with exactly one Venue. 
Assume that a Venue must have run at least one 
ConferenceEvent.  Your ER diagram should show all details.

Show a translation into tables for a SQL database (topic covered in class on Tue Sept 9).

Note: Add 3 attributes to each of the entity type with 
appropriate primary key.

Select the item below that best describes a buffer overflow and how is it used against a web server? a. A buffer overflow occurs when more data is sent to an input buffer field than its size. This can be used to overwrite the stack with malicious code and a return pointer to the malicious code. b. A buffer overflow is caused over a network when there is a mismatch in the processing rates between the two entities involved in the communication process. c. A buffer overflow occurs when rows of data are accessed directly in a database table that are larger than the defined row size for the table. d. Most of the time a buffer overflow occurs when a bug is released accidentally in a proprietary operating system.