Big Store

CLICK HERE TO DOWNLOAD THIS TUTORIAL INSTANTLY $25  Only

For this week assignment you will use this database to answer the following queries in SQL:
1. Find the street and city of all employees who work for the “BigStore”, live in “New York”, and earn more than $35,000.

2. Find the names and the companies they work for, for all people who have a higher salary than their manager.

3.  Assume that companies may be located in several cities. Find all companies located in every city in which the “BigStore” is located.

4. Find the names of managers who manage more than 5 employees living in “Richmond”.
Copy and paste the code from SQL Server to Notepad document and submit it via e-mail.

Multiple Choice Answers

CLICK HERE TO DOWNLOAD THIS TUTORIAL INSTANTLY $28.50 Only

Question 1
A star schema begins with a central dimension table that is linked to one or more fact tables.
True
False

Question 2
A data warehouse is just a large database.
True
False

Question 3
The relational model is one of the best database models.
True
False

Question 4
Business dashboards provide real-time views of data
True
False

Question 5
Data warehouses can be tuned for access since they are nonvolatile.
True
False

Question 6
Data quality is important because it can affect the quality of organizational decisions.
True
False

Question 7
There is a temporal quality to data warehouses.
True
False

Question 8
Data, information, and knowledge are essentially the same thing.
True
False

Question 9
Databases that include audio, video and picture formatted data are referred to as multimedia database management systems.
True
False

Question 10
A data mart must be created directly from a data warehouse.
True
False

Question 11
Data quality and data integrity are essentially the same thing.
True
False

Question 12
Data mining must use statistics to analyze data.
True
False

Question 13
Intrinsic data quality refers to the ease of understanding or interpretability of data.
True
False

Question 14
In many ways setting up a data warehouse is like setting up a separate database for DSS.
True
False

Question 15
Relational databases are called relational because they describe how the end-user interacts with the data.
True
False

Question 16
The two most common data warehouse architectures are three-tiered and four-tiered.
True
False

Question 17
Linear programming involves experimenting on a model of a system.
True
False

Question 18
Which model is designed to handle optimization of problems with few alternatives?
Decision trees
Markov analysis
Linear programming
Heuristic programming
Simulation

Question 19
The types of decision-making situations that may require analysis (in order of increasing complexity) are certainty, risk, and uncertainty.
True
False

Question 20
Expected values are computed by multiplying:
the largest expected results by their probability.
all results by their probabilities, then summing them up.
all results by their probabilities, then selecting the best.
all probabilities by their expected results.
all expected results by their probabilities.

Question 21
A DSS is designed to determine what will be; an MIS is designed to report what was.
True
False

Question 22
What-if analysis is effective in determining the level of input needed to achieve a desired result.
True
False

Question 23
Influence diagrams can be constructed with varying degrees of detail.
True
False

Question 24
A blind search is designed to support individual decision-makers with sight impairment.
True
False

Question 25
Decision-making under uncertainty is also called probabilistic decisionmaking.
True
False

Question 26
Decision trees are best suited for:
one decision in one period.
one decision over several periods.
several decisions over one period.
several decisions over several periods.
None of these.

Question 27
E-commerce has made the need for forecasting obsolete.
True
False

Question 28
Spreadsheet software, such as Microsoft Excel is capable of performing both what-if and goal seeking analysis.
True
False

Question 29
Stochastic decision-making is one in which the decision-maker considers several possible outcomes, each with a given probability of occurrence.
True
False

Question 30
Which model is designed to handle optimization via an algorithm?
Decision trees
Markov analysis
Linear programming
Heuristic programming
Simulation

Question 31
Save Decision trees are only applicable to problems under certainty.
True
False

Question 32
Decision trees are capable of handling multiple-goal problems.
True
False

Question 33
Project scope has a direct affect on project success.
True
False

Question 34
Prototyping is also referred to as iterative design.
True
False

Question 35
Prototyping is the single best DSS development methodology.
True
False

Question 36
DSS projects succeed more often than they fail or are challenged.
True
False

Question 37
Which of the following is a way to engage users in software development?
Turn off cell phones.
Use prototypes.
Focus on user, not IT problems.
Assign good communicators.
All of these.

Question 38
CASE tools consist of lower CASE, upper CASE and mixed CASE.
True
False

Question 39
Prototyping is a form of rapid application development.
True
False

Question 40
Spreadsheet errors are rare in industry.
True
False

Question 41
Analysis involves:
analyzing the problem.
gathering information.
determining model processes.
analyzing the problem, gathering information, and determining model processes.
None of these.

Question 42
Determining how a system will work is completed as part of the design phase.
True
False

Question 43
Project managers must have exceptional technical skills; it is far less important that they be a good project leader.
True
False

Question 44
User-developed DSS and end-user computing are essentially the same thing.
True
False

Question 45
The waterfall method generally results in faster development time than prototyping for DSS development.
True
False

Question 46
The Lewin-Schein change theory is only useful for introducing departmental change to an organization.
True
False

Question 47
Construction is completed in the implementation phase of the waterfall methodology.
True
False

Question 48
Staffing the DSS project is completed after analysis has been completed.
True
False

Question 49
Prototyping helps both the decision-makers and DSS developers learn about decision-making.
True
False

Question 50
Which of the following is a reason for using prototyping for DSS Development?
Learning is explicitly built into the design process.
The interval between iterations is short.
Low cost
It involves users during the development.
All of these.

Multiple Choice Answers

CLICK HERE TO DOWNLOAD THIS TUTORIAL INSTANTLY $4.50 Only

Texas Corporation is undergoing a complete liquidation and distributes land to Robert, one of its shareholders, in exchange for all of Robert’s stock. The land has a basis of $300,000 and a FMV of $400,000 on Texas Corporation’s books and is subject to a $325,000 liability. Robert assumes the liability on the property. Robert’s basis in his Texas Corporation stock is $100,000. What is the amount of gain or loss recognized by Robert on the distribution?
A) $175,000 gain
B) $25,000 gain
C) No gain or loss is recognized.
D) $25,000 loss

Property received in a corporate liquidation by a noncorporate shareholder has
A) a basis equal to its basis on the liquidating corporation’s books increased by any gain recognized by the shareholder upon receipt of the property. Its holding period includes the holding period of the shareholder’s stock.
B) a basis equal to its basis on the liquidating corporation’s books increased by any gain recognized by the shareholder upon receipt of the property. Its holding period commences on the day after the distribution date.
C) a basis equal to its FMV reduced by any liabilities assumed by the shareholder. Its holding period commences on the day after the distribution date.
D) a basis equal to its FMV. Its holding period commences on the day after the distribution date.

Identify which of the following statements is true.
A) In general, a noncorporate shareholder that receives a distribution in complete liquidation of the liquidating corporation recognizes his or her entire realized gain as a capital gain.
B) The basis for nonmoney property received by a noncorporate shareholder as part of a liquidating distribution is the same as its basis on the books of the liquidating corporation.
C) The liquidating corporation does not recognize gains and losses when making a distribution of nonmoney property.
D) All are false.

Identify which of the following statements is true.
A) A loss recognized by a shareholder upon complete liquidation of a corporation may not qualify for ordinary loss treatment if the stock is Sec. 1244 stock.
B) The loss that is recognized by an individual shareholder on the liquidation of a corporation is a capital loss, up to certain limits, if the stock is Sec. 1244 stock.
C) The loss recognized by a corporate shareholder on the worthlessness of the controlled subsidiary’s stock is an ordinary loss.
D) All are false.

Identify which of the following statements is true.
A) With limited exceptions, a loss can be recognized by a liquidating corporation when it makes a liquidating distribution of property that has declined in value.
B) When computing the corporate level gain on a liquidating distribution, the FMV of the property cannot exceed the liability assumed or acquired by the shareholder.
C) The FMV of property distributed by a liquidating corporation can be less than the amount of the liability assumed or acquired by the shareholder.
D) All are false.

Under a plan of complete liquidation, Key Corporation distributes land (not a disqualified property) with an adjusted basis of $410,000 and a FMV of $300,000 for all Sharon’s stock. Sharon’s basis in her 5% interest in the Key stock is $250,000. Find Sharon’s basis in the land and Key Corporation’s recognized gain or loss.
Basis Recognized Gain/Loss
A) $300,000 $110,000 loss
B) $250,000 $110,000 loss
C) $300,000 $-0-
D) 250,000 $-0-

Barnett Corporation owns an office building that cost $900,000. Barnett has taken $600,000 of depreciation on the building. The property is subject to a $600,000 mortgage. The office building has a current FMV of $400,000. Barnett Corporation is liquidated and the office building is distributed to a single individual shareholder who assumes the mortgage. Barnett Corporation must recognize
A) no gain or loss.
B) a $100,000 gain.
C) a $300,000 gain.
D) none of the above

Parent Corporation for ten years has owned all of the stock of Subsidiary Corporation, which manufactures widgets. Parent’s basis in Subsidiary’s stock is $500,000. Subsidiary Corporation is insolvent and has no assets to redeem any of the stock that Parent Corporation owns when it liquidates. Nearly all of Subsidiary’s gross income during the past five years has come from nonpassive activities. Parent can recognize
A) a $500,000 short-term capital loss.
B) a $500,000 long-term capital loss.
C) a $500,000 ordinary loss.
D) a $500,000 bad debt deduction.

Penn Foster 406291

CLICK HERE TO DOWNLOAD THIS TUTORIAL INSTANTLY $11.95 Only


1. In 1986, the organized crime task force noted that _______ was the most lucrative crime in the United States.
A. extortion
B. gambling
C. loansharking
D. drug trafficking

2. When an organized crime group is made up of individuals who shift alliances according to the skills they possess to carry out their crimes, the organization is said to be a/an
A. hierarchical conglomerate.
B. core criminal group.
C. rigid hierarchy.
D. organized criminal network.

3. What distinguishes the 1986 commission investigation of organized crime from the 1967 task force report?
A. It relied heavily on Joseph Valachi’s “insider” testimony.
B. It concluded that organized crime is a society.
C. It focused on much more than just Italian-American organized crime.
D. It concluded that the Mafia had changed its name to La Cosa Nostra.

4. Who was captured and convicted after an examination of his net worth?
A. Al Capone
B. Joseph Albini
C. Joseph Valachi
D. George Conway

5. The two U.S. presidents who formed task forces to focus on organized crime were _______ and
_______.
A. Herbert Hoover; Theodore Roosevelt
B. Ronald Reagan; Lyndon B. Johnson
C. Richard Nixon; Jimmy Carter
D. John F. Kennedy; Dwight D. Eisenhower

6. When the planning and execution of a crime involve more than one country, _______ crime is taking place.
A. intranational
B. intergovernmental
C. transactional
D. transnational

7. U.S. officials admit that they’re able to identify only _______ percent of the vessels carrying illegal
immigrants.
A. 5
B. 20
C. 10
D. 15

8. Cosa Nostra groups have been identified in approximately _______ cities in the United States.
A. 7
B. 25
C. 12
D. 50

9. A total of _______ states have adopted electronic surveillance laws that are similar to Title III laws of
the Omnibus Crime Control Act (1968).
A. 29
B. 32
C. 45
D. 18

10. In the late 1960s, the core of organized crime in the United States was determined to involve _______
groups exclusively of Italian origin and totaling _______ members.
A. 12; 10,000
B. 50; 50,000
C. 20; 7,500
D. 24; 5,000

11. The term that originated in the 1920s and that refers to thefts of truckloads of illegally manufactured
liquor is
A. hijacking.
B. moonshining.
C. ransom.
D. ajacking.

12. Which one of the following choices is not one of the criteria authorizing the United States to use wiretaps without probable cause?
A. The target is working for a foreign power.
B. The purpose is intelligence gathering.
C. The target is an alien.
D. The target is a member of a terrorist group.

13. In 1954, the Organized Crime and Racketeering Section was formed by the
A. Department of Labor.
B. Internal Revenue Service.
C. Central Intelligence Agency.
D. Department of Justice.

14. Why are people in countries other than the United States more likely to purchase a stolen car from a
smuggling operation?
A. There’s no access to any database for stolen cars.
B. There’s a rampant glut of illegal purchases.
C. It’s impossible to find out whether a car is stolen.
D. The import fees of legal purchases are exorbitant.

15. When an organized crime organization has a single boss with strong internal discipline within several
divisions, the organization is said to have
A. devolved hierarchy.
B. rigid hierarchy.
C. hierarchical conglomeration.
D. a core criminal grouping.

16. The knowledge that banks were failing to comply with the Bank Secrecy Act by not reporting large
cash transactions was noted by the
A. 1967 Task Force on Organized Crime.
B. Chicago Commission on Organized Crime of 1977.
C. 1986 President’s Commission on Organized Crime.
D. New York State Organized Crime Task Force of 2009.

17. The United Nations list of organized crimes that involve more than one country fall into _______
categories.
A. 12
B. 20
C. 18
D. 24

18. Criminals use computers most often to
A. steal.
B. extort.
C. harass.
D. embezzle.

19. During the 1960s, law enforcement officers agreed, almost unanimously, that _______ was the largest source of organized crime revenue.
A. prostitution
B. drug sales
C. gambling
D. loansharking

20. Which one of the following crimes was not mentioned by name in the 1967 investigation report of organized crime?
A. Narcotics trafficking
B. Labor racketeering
C. Gambling
D. Money laundering

A place where you can learn and succeed