Acme Company Balance Sheet As of January 5, 2018 (amounts in thousands) Cash 14,300 Accounts Payable 1,900 Accounts Receivable 4,100 Debt 3,200 Inventory 5,800 Other Liabilities 4,000 Property Plant & Equipment 14,800 Total Liabilities 9,100 Other Assets 700 Paid-In Capital 7,700 Retained Earnings 22,900 Total Equity 30,600 Total Assets 39,700 Total Liabilities & Equity 39,700 Update the balance sheet above to reflect the transactions below, which occur on January 6, 2018 1. Sell product for $20,000 with historical cost of $16,000 2. Sell product for $30,000 with historical cost of $24,000 3. Sell product for $35,000 with historical cost of $28,000 What is the final amount in Retained Earnings? Please specify your answer in the same units as the balance sheet.

The purpose of this exercise is to successfully identify and describe in detail 3 database systems that you or someone you are close to encounters often for their normal day-to-day activities. When considering database systems to describe, consider the points listed below:
1. What is the database system identified? Remember to keep it broad (e.g. our accounting system) 2. Where would you typically see such a database system used? 3. Why does this database system exist? What problem is being solved? 4. How is this database system used? 5. Who is the primary user for this database system?
I expect to see nothing less than a paragraph (4-5 sentences) about each system identified. You are all database professionals so I expect it to be written in a professional format.

So I pick three database systems that are a good one is Personal database, Document databases and, Network databases.

Q4.(15) One random sample of the height of one type of tree was recorded.
7, 9 ,10, 7 ,12 ,10, 8, 13 ,15, 9
1.(5) Apply the backward empirical rule to check normality of the data, and conclude if any evidence of non-normality.
2.(5) Assume the height of the tree is normal, calculate the 99% two-sided confidence interval for the true population average height.
3.(5) Assume that we know the population variance σ^2=9,
and we request the bound on the error of estimation of 99% confidence interval to be 2, find the minimum sample size n.

Q4.(15) One random sample of the hours of one type of user watch TV per day was recorded: 2.9, 3.5, 3, 3.2, 3.3, 3.5, 3.3, 3, 3.5.

1.(5) Apply the backward empirical rule to check normality of the data, and conclude if any evidence of non-normality.

2.(5) Assume that the underlying population is normal. Find a two-sided 99% confidence interval for the the true population average hours

3.(5) Assume that population variance σ2=0.09σ2=0.09 and the bound on the error of estimation of 99% confident interval to be 0.2. Find the minimum sample size nn.

Q4.(15) One random sample of the height of one type of tree was recorded. 7, 9 ,10, 7 ,12 ,10, 8, 13 ,15, 9 1.(5) Apply the backward empirical rule to check normality of the data, and conclude if any evidence of non-normality. 2) Assume the height of the tree is normal, calculate the 99% two-sided confidence interval for the true population average height. 3.(5) Assume that we know the population variance σ2=9, and we request the bound on the error of estimation of 99% confidence interval to be 2, find the minimum sample size n.

• Use Excel to conduct a regression of the values of the security against the predictors and verify the validity of underlying assumptions
  • Check for homoscedasticity and serial correlation
  • If necessary, rerun the regression using robust standard errors
  • Look for evidence of multicollinearity and eliminate redundant predictors if necessary

Record the following in John’s two-column cash book. Balance the cash book and bring down the balances of cash in hand and cash at bank at the end of the period. and open the necessary ledger account.

2018

October 1st Introduced ₦5,000 cash into the business as capital

October 5th Paid rent of ₦2000 cash

October 11th Receive cheque of ₦1000 from sales

October 15th Purchase good and paid ₦2000 by cheque

October 19th Pay Insurance ₦500 by cheque

October 24th Cash sales ₦500

October 25th Receive rent by cheque ₦1000

October 28th    Cash paid into bank ₦2,000

October 31st    paid wages by cash ₦500

Let’s work through another type of problem:

                 Butane is a ‘hydrocarbon’ compound containing only carbon and hydrogen. Butane is used as fuel in lighters. It’s empirical formula is C2H5, and it’s molar mass is 58.12 g/mole. Based on this data, what is the molecular formula of butane?

                 Begin by determining the empirical formula mass.

                 Next, divide the molar mass by the empirical formula mass.

                 Finally, multiply the empirical formula by this number.

    This results in a molecular formula of :

Putting all the steps together!

1.    A compound with the following mass percent composition has a molar mass (formula mass) of 60.10 g/mol. Find both the empirical formula and the molecular formula.

                                   39.97% C              13.41% H             46.62% N

2.    A compound was analyzed and found to contain the following percentages of the elements by mass: cobalt, 71.06%; oxygen, 28.94%. Determine the empirical formula.

3.    When 4.01 grams of mercury is strongly heated in air, the resulting oxide weighs 4.33 grams. Calculate the empirical formula of the resulting mercury oxide.

4.    A compound with empirical formula C2H5OH was analyzed and found to have a molar mass of approximately 90 g. What is the molecular formula of this compound?

5.    A 1.2569 gram sample of a new compound has been analyzed and found to contain the following masses of elements: carbon, 0.7238 g; hydrogen, 0.07088 g; nitrogen, 0.1407 g; and oxygen, 0.3214 g. Calculate the empirical formula of the compound.

    *Further analysis shows that the formula mass (molecular mass) is approximately 376-377 grams. Determine the molecular formula.

1. The molar mass of a compound is 126 g/mol, and it's empirical formula is C2H2O. What is compound's molecular formula?

2. A compound consist of 26.18g Si and 29.82g O. Calculate its empirical formula?

3. Calculate the empirical formula of the compound that consist of 70.4%F and 29.6%O.

1. You are the DBA in the service of the British Royal Museum. You need to update the database of all Britons that have been knighted in the past. You want to build in a validation of the data to find all these people.

   Which of the following metacharacter combinations would you use?

   	A.	'Sir .'
   	B.	'Sir +'
   	C.	'Sir ?1'
   	D.	'Sir EG*1'

2. ou query the database with this SQL statement:

   SELECT *

   FROM transaction;
   
   

   For which purpose was this statement created?

   	A.	to insert data into the TRANSACTION table
   	B.	to view the data in the TRANSACTION table
   	C.	to review the structure of the TRANSACTION table
   	D.	to delete selected data from the TRANSACTION table

3. The four phases that indicate the different phases of SQL statement execution are as follows:

   1. execute

   2. fetch

   3. parse

   4. bind

   Which option represents the correct sequence of events while executing a statement?

   	a.	1, 2, 3, 4
   	b.	2, 3, 4, 1
   	c.	3, 4, 1, 2
   	d.	4, 3, 1, 2

4. Which three statements about constraints are true? (Choose three.)

   	A.	Constraints only enforce rules at the table level.
   	B.	Constraints prevent rows with dependencies from being deleted.
   	C.	You must provide a name for each constraint at the time of its creation.
   	D.	Constraint names are not required to follow the standard object-naming rules.
   	E.	Constraints can be created at the same time as the table or after the table is created.