Entries by Student

write my assignment 8326

What is the conditional probability of A given B? Are A and B independent in a probability sense? D) The probability of A is 0.30 and the probability of B is 0.40 and the probability of both is 0.30. What is the conditional probability of A given B. Are A and B independent in a probability sense? 6) A student committee has six members -four undergraduate and two graduate students. A subcommittee of three members is to be chosen randomly so that each possible combination of three of the six students are equally likely to be selected. What is the probability that there will be no graduate students on the subcommittee? 7) A music store owner nds that 30% of the customers entering the store ask for help and that 20% of the customers make a purchase before leaving. It is also found that 15% of all customers both ask for assistance and make a purchase. What is the probability that a customer does at least one of those things?

 

"Not answered?"


Get the Answer

write my assignment 21998

Assignment 5 tasks: each query is worth 5 marks

Part A – DML

1. Locate the record in the vendor table that does not have a value for the attribute V_STATE

2. Find the customers whose balance is greater than $300 but less than $400.

3. Show the names of the customers for whom we have invoices.

4. What is the max balance?

5. Show the CUS_CODE of the customers for whom we DO NOT have invoices.

6. Show the names of the customers for whom we DO NOT have invoices.

7. Find out how many times a customer generated an invoice – make sure the counted column

heading reads “Invoices_generated”.

8. List the names of the customers and how many times a customer generated an invoice –

make sure the counted column heading reads “N_Of_Invoices” .

Part B – DDL

1. Add a new row/record to the `customer` table to include your actual student_ID in the

CUS_CODE, your last_name as the CUS_LNAME` and your firstname as CUS_FNAME. Add

any other details of your choice in all the other fields.

2. Add a new attribute (field) credit_history VARCHAR(6) to the customer table.

3. Update credit_history for customer '10011' to 'Bad'.

4. Delete the employee Leighla Genkazi from the EMP table.

5. Add a new attribute called ’email_address’ to ’emp’ table with data type and length

‘VARCHAR(20).

You are required to submit:

1. The SQL statements for each query, which should be copied from your SQLite3 Command

Line and pasted into your submission file. If you type .echo on at the SQLite3 Command Line,

SQLite will output your SQL statement with the results of the query making it easy to copy

and paste both.

2. The screenshots of the results of the SQL statements which are to be copied from your

SQLite3 Command Line and pasted into your submission file immediately after you execute

the SQL query. If you used an output file please submit only the output file.

 

"Not answered?"


Get the Answer

write my assignment 883

Suppose a U.S. wood-products company has facilities and employees in Canada providing its raw materials (wood), but has most of its sales in the United States.(1) What are the most important operational and financial risks in this arrangement? (2) How can the company pay its Canadian employees, who presumably want Canadian dollars, when its U.S. customers are paying in U.S. dollars? Furthermore, how can it calculate its profit if revenue is in U.S. currency and most of its costs are in Canadian currency?In your responses, provide constructive critiques and supplemental insights. Support your critique with sound reasoning and evidence.

 

"Not answered?"


Get the Answer

write my assignment 14803

Write 10 pages with APA style on The complexity of Management. In this paper, the proponent clearly illustrates situations that identify existing complexities within an organisation. Marketing versus accounting department In most instances, there is always an ongoing clash between the accounting and marketing department. This is because of the meaning of accounting in an organisation seems to be broad (McSweeney, 1995). In order to understand this in detail, there is always a good reason to believe that each department has essential role or function to play in an organisation. In line with this, it is necessary that these specific functions have to be elaborately discussed in detail in order to find out why there is an ongoing complexity that exists within an organisation. A salesperson was having a hated argument with an accounting staff. The problem was actually within the bound of how they tried to handle customer service. The salesperson was so aggressive about creating a sale with the customer and he was always ready to shortcut the process just to be able to close the deal. However, the accounting staff understood her function clearly well. In other words, she was so aggressive about the implementation of what has been agreed within their department. As a result, there was a strong clash of personal interests of each department that went on between the accounting staff and salesperson.

 

"Not answered?"


Get the Answer