To expand the database design created in exercise 3 to incorporate following user view: CAT is required to send invoice to each participant. The details of invoice should be classes in which participant is enrolled, total fee for the adventure classes, name and address of participant. Given information: Following database design was developed for exercise 3: Explanation: Based on user view following Invoice table should be generated: Invoice ( InvoiceNum , ClassNum, TotalFees, LastName, FirstName, Address) In the above relation attributes LastName, FirstName and Address are already present in Participant table. Thus, only by including the PNumber as foreign key in Invoice table one should be able to get last name, first name and address of the participant. Therefore, Invoice relations should have the following structure: Invoice ( InvoiceNum , ClassNum, TotalFees, PNumber) Thus, DBDL for this user view will be as follows: Cumulative design after this user view will be as follows:

Question

cases: Compare the Poisson approximation with the correct binomial probability for the following a. P{X=2} when n = 8, p = 0.2 b. P{X 5} when n = 10, p = 0.5 c. P{X=0} when n = 20, p = 0.2 d. P{X=3} when n = 9, p = 0.1

Answer 1

Question

Chapter 6, Problem 4CATC

To determine

To expand the database design created in exercise 3 to incorporate following user view:

CAT is required to send invoice to each participant. The details of invoice should be classes in which participant is enrolled, total fee for the adventure classes, name and address of participant.

Given information:

Following database design was developed for exercise 3:

Explanation:

Based on user view following Invoice table should be generated:

Invoice (InvoiceNum, ClassNum, TotalFees, LastName, FirstName, Address)

In the above relation attributes LastName, FirstName and Address are already present in Participant table. Thus, only by including the PNumber as foreign key in Invoice table one should be able to get last name, first name and address of the participant. Therefore, Invoice relations should have the following structure:

Invoice (InvoiceNum, ClassNum, TotalFees, PNumber)

Thus, DBDL for this user view will be as follows:

Cumulative design after this user view will be as follows:

Expert Solution & Answer

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Students have asked these similar questions

cases: Compare the Poisson approximation with the correct binomial probability for the following a. P{X=2} when n = 8, p = 0.2 b. P{X 5} when n = 10, p = 0.5 c. P{X=0} when n = 20, p = 0.2 d. P{X=3} when n = 9, p = 0.1

4. Suppose that the average number of cars abandoned weekly on a certain highway is λ = 1.68. Approximate the probability that there will be (a) No abandoned cars in the next week. (b) At least 2 abandoned cars in the next week. Hint: Model the problem with a Poisson random variable.

od The probability mass function of a discrete random variable X is given by P(X = 1) = {} x=1,2,3,4 10 otherwise (a) Draw the probability mass function (PMF) of this random variable. (b) Draw the cumulative distribution function (CDF) of this random variable. (c) What is P{2< x <4}? Write it in terms of the CDF. (d) What is E[X]? (e) What is Var[X]? (f) What is E[X (6-X)]? (g) What is Var[3X - 2]?