Business Intelligence & Database Technologies

As highlighted in chapter 6 of the Laudon text, the foundations of business intelligence are based upon advanced database related technologies. Some of these technologies include, but are not limited to, database management systems, data warehouses, data marts, data mining, and analytics. Also, the concept of Big Data is an evolving phenomenon which is sparking heightened interest among organizations and is paving a new direction in the arena of business intelligence.

Some questions to ponder:

1) Can we trust big data?

2) Why are organizations interested in capturing and mining their enterprise data?

3) Why are they especially interested in tapping into the power of "Big Data"?

4) Traditional database management tools are often insufficient when dealing with "Big Data". What technology tools do you think are more suitable?
5) Are there any pitfalls to using "Big Data?" What are some of the challenges?

6) By doing a search of the internet, or by other research methods, find another example of an organization that is using "Big Data" to solve a business problem. Did the organization achieve their objectives?

1)When 5.352 grams of a hydrocarbon, C_xH_y, were burned in a combustion analysis apparatus, 18.38 grams of CO₂ and 3.010grams of H₂O were produced.
In a separate experiment, the molar mass of the compound was found to be 128.2 g/mol. Determine the empirical formula and the molecular formula of the hydrocarbon.

2)When 4.948 grams of a hydrocarbon, C_xH_y, were burned in a combustion analysis apparatus, 16.72 grams of CO₂ and 3.424grams of H₂O were produced.
In a separate experiment, the molar mass of the compound was found to be 26.04 g/mol. Determine the empirical formula and the molecular formula of the hydrocarbon.

	1.	cannot be either C2H2 or C6H6
	2.	could be C6H6 but no C2H2
	3.	could be C2H2 , but not C6H6
	4.	could be C2H2 or C6H6

	1.	cannot be either C2H2 or C6H6
	2.	could be C6H6 but no C2H2
	3.	could be C2H2 , but not C6H6
	4.	could be C2H2 or C6H6

When 6.104 grams of a hydrocarbon, CxHy, were burned in a combustion analysis apparatus, 19.15 grams of CO2 and 7.842 grams of H2O were produced. In a separate experiment, the molar mass of the compound was found to be 28.05 g/mol. Determine the empirical formula and the molecular formula of the hydrocarbon.

A 7.797 gram sample of an organic compound containing C, H and O is analyzed by combustion analysis and 7.623 grams of CO₂ and 1.561 grams of H₂O are produced.
In a separate experiment, the molar mass is found to be 90.04 g/mol. Determine the empirical formula and the molecular formula of the organic compound.

When 6.104 grams of a hydrocarbon, CxHy, were burned in a combustion analysis apparatus, 19.15 grams of CO2 and 7.842 grams of H2O were produced. In a separate experiment, the molar mass of the compound was found to be 28.05 g/mol. Determine the empirical formula and the molecular formula of the hydrocarbon.

A 7.797 gram sample of an organic compound containing C, H and O is analyzed by combustion analysis and 7.623 grams of CO2 and 1.561 grams of H2O are produced. In a separate experiment, the molar mass is found to be 90.04 g/mol. Determine the empirical formula and the molecular formula of the organic compound.

Calculate the radius ratio for CaO if the ionic radii of Ca2 and O2– are 100 pm and 140 pm, respectively.

Based on the radius ratio above, what is the expected coordination number of CaO? The range of radius ratios for each coordination number is given in parentheses.

If the density of solid iron is 7.87 g/cm3, what is the packing efficiency of Fe if it adopts a body-centered cubic unit cell? The molar mass of Fe is 55.847 g/mol.

Determine the empirical formula of the compound with a crystal structure where beryllium ions occupy all of the tetrahedral holes in a cubic close-packed (ccp) array of carbon anions.

Determine the empirical formula of the compound with a crystal structure where boron ions occupy one-half of the tetrahedral holes in a cubic close-packed (ccp) array of nitrogen anions.

Determine the empirical formula of the compound with a crystal structure where silver ions occupy all of the octahedral holes in a cubic close-packed array of chlorine anions.

A survey was conducted in which 125 families were asked how many cats lived in their households. The results are shown below. ​a) What is the probability that a randomly selected family has one​ cat? ​b) What is the probability that a randomly selected family has more than one​ cat? ​c) What is the probability that a randomly selected family has​ cats? ​d) Is this an example of​ classical, empirical, or subjective​ probability? *Number of Cats-Number of Households* 0-71 1-33 2-16 3-4 4-1 Total-125 ​a) The probability that a randomly selected household has one cat is nothing. ​(Simplify your​ answer.) ​b) The probability that a randomly selected family has more than one cat is nothing. ​(Simplify your​ answer.) ​c) The probability that a randomly selected family has cats is nothing. ​(Simplify your​ answer.) ​d) Is this an example of​ classical, empirical, or subjective​ probability? Empirical probability Classical probability Subjective probability Thank you in advance!!

Define a linear programming model and its components. Discuss which 3 properties a planning problem needs to meet to be modeled as an LP?

Define the feasible set and its corner points. Explain how one can find the combinations of the decision variables corresponding to the corner points. How one can use the corner points to find the optimal solution?

Define special situations: unbounded feasible set, infeasibility, alternate solutions, redundant constraints. Discuss what do these situations imply for the manager's planning problem. When do you need to and how do you avoid this situation?

Write out the following transactions in the Triple column cash book of Ali:

2018 Jan. 1 Ali commences his business with cash = OMR. 30000

Jan 2 He pays into bank current account = OMR. 20000

Jan. 3 He receive cheque from Khalid LLC on account = OMR. 1000

Jan. 7 He pays kulwant rai's cheque into bank = Rs. 1000

Jan. 10 He pays Said by Cheque = OMR. 1980 and receive discount = OMR. 20

Jan. 11 He receive cheque from Wasim = Rs. 970 and allow him discount = Rs. 30

Jan. 15 He makes sales for cash = OMR. 2000

Jan. 17 Cash deposited into bank = OMR. 3000 Jan.

19 He purchased a motor car by cheque = OMR. 6500

Jan. 20 He purchased goods by cheque = OMR. 1500

Jan. 22 He pays Essam traders in cash = OMR. 2000 and receives discount = OMR. 100

Jan. 29 He withdraws from bank for office use = OMR. 500

17 Jan. 30 He purchases furniture by cheque = OMR.

Please answer in detail with every step along with the graph which is required for question bit C.

The table below shows hypothetical values, in billions of dollars, of different forms of money.

a.     Use the table to calculate the M1 and M2 money supplies for each year, as well as the growth rates of the M1 and M2 money supplies from the previous year.

b.     Why are the growth rates of M1 and M2 so different? Explain.

		2015	2016	2017	2018
A.	Currency	900	920	925	931
B.	Money market mutual fund shares	680	681	679	688
C.	Saving account deposits	5,500	5,780	5,968	6,105
D.	Money market deposit accounts	1,214	1,245	1,274	1,329
E.	Demand and checkable deposits	1,000	972	980	993
F.	Small denomination time deposits	830	861	1,123	1,566
G.	Traveler’s checks	4	4	3	2
H.	3-month treasury bills	1,986	2,374	2,436	2,502

c. Go to the web site of the St. Louis Federal Reserve Bank FRED database and graph the (year-over-year) growth rates of M1 and M2 for the sample period 1998-2018. Show your graph in your submission.