Define the cost per student for each class

Assignment Help Computer Engineering

Reference no: EM1335528

a. Using the data below, design and populate a table that includes basic training rate information. Designate the "Technical" field type as "Yes/No" (Boolean).

b. Using the data below, design and populate a course table. Designate the CourseID field as a "Primary Key" and allow your database to automatically generate a value for this field. Designate the "Technical" field type as "Yes/No" (Boolean).

c. Prepare a query that lists each course name and its cost per day of training.

d. Prepare a query that lists the cost per student for each class. Assume maximum capacity and that you will schedule two half-day classes on the same day to take full advantage of HOTT's per day pricing schedule.

Pricing table
Technical Price per day capacity
Yes $2,680 15
No $2,144 30

Course table

Course ID Course name Duration Technical
1 ASP Programming 5 Yes
2 XML Programming 5 Yes
3 PHP Programming 4 Yes
4 Microsoft word-Advanced 0.5 No
5 Microsoft Excel-Advanced 0.5 No

Reference no: EM1335528

Questions Cloud

Prepare a framework for an ethical organization : Description of the Organization: Expand and incorporate feedback from Building an Ethical Organization Part I and Mission Statement: Expand and incorporate feedback from Building an Ethical Organization Part I.

Elucidate what would be the measured unemployment rate : Assume the population over age. Elucidate what would be the measured unemployment rate.

Describing the criminal investigation : Give me an example of the scientific and technological advances in criminal investigations.

Graph the demand and supply : Graph the demand for wheat and the supply for wheat Label equilibrium price and equilibrium quantity

Define the cost per student for each class : Using the data below, create and populate a course table. Designate the CourseID field as a "Primary Key" and allow your database to automatically make a value for this field. Designate the "Technical" field type as "Yes/No" (Boolean).

Finding the interview room : Describe what one would find in an interview room. Why would these items be in that room? If there is another person in the room (officer witness), where should he or she sit?

Analyzing the budget and actual costs : An inexperienced project manager analyzed the budget vs. actual costs and found that project spending was 10% under budget and was overjoyed at such "good news."

Elucidate the economic cost function for this business : Elucidate the economic cost function for this business. What is the economic break even number of units for this operation.

Primary types of heuristics : From your readings in the text this past week we've learned there are three primary types of heuristics.

User Account

All Pages