1. In basket analysis, we want to find the dependence between two items X and Y. Given a database of customer transactions, how can you find these dependencies? How would you generalize this to more than two items?

Demonstrate how a temporal database is used in business

Explain how spatial databases are used in business

Explain how SQL is used with spatial databases

Explain how NoSQL databases are being used to store unstructured business data

Depending on the sample of interest, different ion sources are used for mass spectrometry. What ion source would you use if you wanted to examine many different small molecules and compare your results to a large database? Why?

design a relational database to cater for the needs of the new bookshop owner as described in the first question giving examples of tables, attributes, primary and foreign keys. you may assume that suppliers' orders contain more than one line

Data Modelling is the primary step in the process of database design. Compare and contrast Conceptual data model versus Physical data model. Illustrates with help of example to list down data (entities), relationship among data and constraints on data.

A good security system must be secured at multiple layers such as 1) database, 2) computer and 3) network. Compare the differences among these three layers. Provide one security example for each and one scenario that involves all of them.

5.When discussing the empirical tests of the EMH, there are three topical areas that suggest that the debate probably will never be settled: the magnitude issue, the selection bias issue, and the lucky event issue. Specifically with the lucky event issue, the laws of probability are oftentimes ignored or forgotten.

True

False

6.Bonds rate BBB or Baa or above are considered investment grade bonds whereas those lower rated bonds are classified as speculative grade, high yield, or junk bonds. Defaults on high-grade bonds - the reason for the rating - are not common as evidenced by our in-class discussion.

True

False

7.While oftentimes referred to as risk-free, default-free bonds such as US Treasury issues are nonetheless subject to interest rate and inflation rate risk.

True

False

8.Owing to the recent actions by the Federal Reserve in 2020, the current US government yield curve is inverted. Yield curves can be used to extract market expectations

True

False

Calculate the empirical formula for each of the following natural flavors based on their elemental mass percent composition.

1.) Nitroglycerin (used medically as a vasodilator to treat heart conditions): 15.87%C, 2.22%H, 18.50%N, and 63.41%O.

2.) Glucose (a source of energy and metabolic intermediate): 40.00%C, 6.71%H, and 53.29%O.

Calculate the empirical formula for each of the following substances.

Part A 2.90 g of Ag and 0.430 g of S Express your answer as a chemical formula.

Part B 2.22 g of Na and 1.55 g of S Express your answer as a chemical formula.

Part C 4.22 g of Na, 2.94 g of S, and 5.86 g of O Express your answer as a chemical formula.

Part D 1.84 g of K, 0.657 g of N, and 2.25 g of O