Below is an invoice sent out by MegaCorp.

STEP 1:

Convert the above to 1NF

1. Provide a relation of the above INVOICE, underlining the primary keys.

STEP 2:

Consider the following functional dependencies of the invoice data:

OrderID à OrderDate, CustomerNum, CustomerName, CustomerAddress

ProductID à ProductDescription, ProductFinish, ProductStandardPrice

STEP 3:

Convert your 1NF table to 2NF. (i.e., look only at non-key attributes that are dependent on a single PK)

A relation is in 2NF if it contains no partial functional dependencies.

1. Provide me 2NF relations based on the dependencies above. BE CAREFUL:   I am NOT asking you to do 3NF yet!!

STEP 4:

Now, you’ve realized there are some additional functional dependencies:

CustomerNum à CustomerName, CustomerAddress

Convert your 2NF relations to 3NF based on the dependencies you just received.

The following contingency table refers to marriage and education. Marriage M M' Total D 1000 2000 3000 Education D' 500 1500 2000 Total 1500 3500 5000 M = Married M1 = single (not married) D = person has degree D1 = person doesn’t have a degree. 1. Compute all the marginal and joint probabilities.

1. Caspian Sea Drinks is considering buying the J-Mix 2000. It will allow them to make and sell more product. The machine cost $1.89 million and create incremental cash flows of $591,981.00 each year for the next five years. The cost of capital is 8.34%. What is the profitability index for the J-Mix 2000?

Round to 3 decimal places

Consider the following reaction:
CO(g)+H2O(g)⇌CO2(g)+H2(g)
Kp=0.0611 at 2000 K
A reaction mixture initially contains a CO partial pressure of 1346 torr and a H2O partial pressure of 1762 torr at 2000 K.

A.) Calculate the equilibrium partial pressure of CO2.

B.) Calculate the equilibrium partial pressure of H2

What role does the entity-relationship (ER) diagram play in the database design process? Discuss the different types of information represented in the ER diagram and the symbols used to represent them. How would you approach the diagramming process?

Do you think it’s harder to manage

• an IT project in Banking (e.g. Registration of customers, production of ATM cards, maintenance of the bank database and procurement of IT hardware and software for the company)

OR

• a traditional project, such as building construction? Justify your response.

Q)

A shared lock is issued when a transaction must read data from the database and no exclusive locks are held on the data to be read.” Is it correct? Justify the answer by explaining the conditions (or by an example) under which both types of locks are granted

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.

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