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.

Example of a Long-Term Goal: Beginning January 2020, contribute $600 per month (2,000 per year) to my Roth IRA for 40 years earning a rate of 8% per year for an ending balance of $518,113 on December 31, 2060. (This example used a time value of money calculation of N = 40, PMT = 2000, I = 8%)

Based upon this example, create two other long term goals.

5. In a certain market in the long-run, suppose the total cost function for each firm and potential entrant is given by TC = 5Q³ -10Q².+20Q. Market demand is given by D(P)= 2000 - 100P .

1) In equilibrium, how many units will each firm produce?

2) What is the market equilibrium price?

3) What is total market demand?

4) What is the equilibrium number of firms in the long-run?

a company in continuous production, which implements the FIFO method, provides the following data. The initial cost of inventory is $ 16,000 and the cost of the period is $ 54,000. inventory at the beginning 600 pieces and has absorbed 75% of the costs, unit produced 2000 pieces and inventory at the end 3200 pieces. Equivalent units are 2200 pieces. Find the percentage of inventory cost absorption at the end.

a. 29.2% b. 20.3% c. 27.4% d. 25.6%