Reference no: EM131130203
The following questions refer to the Art Course database (the same one used for last week module 3 assignment). You can obtain a copy of this data in the Access 2010 database, Art_Course_Database.accdb located on the course Canvas Web site (Listed in Module 3 above).
The database contains data shown in Figure 1-10.
CUSTOMER (CustomerNumber, CustomerName, Phone)
COURSE (CourseNumber, Course, CourseDate, Fee)
ENROLLMENT (CustomerNumber, CourseNumber, AmountPaid)
where
CustomerNumber in ENROLLMENT must exist in CustomerNumber in CUSTOMER
CourseNumber in ENROLLMENT must exist in CourseNumber in COURSE
Write SQL queries to produce the following results:
1) List all students and courses they are registered for. Include, in this order, CustomerNumber, CustomerName, Phone, CourseNumber, and AmountPaid.
2) List the total amount paid for each course starting after July 4, 2009. Include, in this order, CourseNumber, CourseName, and total amount paid for that course.
3) List the average amount paid for each customer. Include, in this order, CustomerName and average amount paid by that customer.
4) List all students registered in the Adv. Pastels starting on October 1, 2009. Include, in this order, CourseName, CourseDate, Fee, CustomerName, and Phone.
|
Find business issue leading schaeffer consider outsourcing
: Identify the business issues leading Schaeffer to consider outsourcing. Identify the specific risks and benefits to the proposed outsourcing proposal. Identify the roles and resources associated with an outsourcing proposal.
|
|
Choose between three award options
: Crissie just won the lottery, and she must choose between three award options. She can select to recevie a lump sum of $61, To receive 10 payments of $9.5, or to recieve 30 payments of $5.5. If she expects to earn 9% quarterly, which option would you..
|
|
Determine the qualitative forecasting techniques
: Managing in the Global Economy and Outsourcing Offshore - determine the qualitative forecasting techniques that could be used within this scenario.
|
|
Draw a graph to show the new equilibrium
: Eliminate the Mango Market? Draw a supplydemand graph depicting a situation in which banning mango imports drives the quantity of mangos sold to zero.
|
|
List all students and courses they are registered for
: List all students and courses they are registered for. Include, in this order, CustomerNumber, CustomerName, Phone, CourseNumber, and AmountPaid. List the total amount paid for each course starting after July 4, 2009. Include, in this order, Cour..
|
|
Define the modified project IRR as the solution
: Look again at the project cash flows in Problem 10 below. C0 C1 C2 C3 -3,000 3,500 4,000 -4,000 Calculate the modified IRR as defined in Footnote 4 in section 5-3. Assume the cost of capital is 12%. Now try the following variation on the MIRR concept..
|
|
Examine relation of photosynthesis and cellular respiration
: Write a 875- to 1,050-word paper summarizing the events of cellular respiration and photosynthesis. Examine the relationship between photosynthesis and cellular respiration.
|
|
Calculated using stright-line down to zero salvage value
: A company is considering a 5-year project that opens a new product line and requires an initial outlay of $85,000. The assumed selling price is $97 per unit, and the variable cost is $63 per unit. Fixed costs not including depreciation are $20,000 pe..
|
|
Explain in your own words what the problem or issue is
: Database privacy (through encryption). Explain in your own words what the problem or issue is, how the issue is being addressed and some of the concerns with the solutions being proposed.
|