Populate a pricing table that includes basic training

Assignment Help Business Management

Reference no: EM13861867

Part 1:

A. Design and populate a Pricing table that includes basic training rate information. Designate the "Technical" field type as "Yes/No" (Boolean).(hint: create & populate Pricing Table).

B. 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). (hint: create & populate Course Table).

C. Prepare a query that lists each course name and its duration (hint: use the Course Table only).

D. Prepare a query that lists each course name and its cost/price per day of training (hint: you need first to link the two tables (Pricing Table and Courses Table) by "Technical" field to generate this query).

Part 2:

A. Add a Class Schedule table to your training database. Designate the ScheduleID field as a "Primary Key" and allow your database program to automatically generate a value for this field.

Make the CourseID field a number field and the StartDate field a date field. (hint: create & populate Class Schedule Table).

B. Add a Class Roster table to your training database. Make ScheduleID field a number field. Make the Reminder and Confirmed fields both "yes/no" (Boolean) fields. (hint: create & populate Class Roster Table).

C. Prepare a query that lists the participants who are only confirmed (hint: you need to use Class Roster Table and have "Yes" for Confirmed).

D. Generate a report that lists Course Name, Location, Start Day, and Price Per Day (hint: use two tables (Course Table and Class Schedule)).

Reference no: EM13861867

Questions Cloud

Describe an implementation strategy for content area : Describe an implementation strategy for each content area

How to create a risk management plan : Using the same project (project charter) students will produce a baseline risk management plan for their project. The risk analysis will identify and classify risks to the completion of the project. Based on the analysis, the student will develop ..

Network component from the marketplace : Identify one network component from the marketplace that could be implemented in the LAN of a midsized business. Describe the component's purpose and functionality, a viable source of supply, available support from the manufacturer of from other t..

Describe the structure and departments within the agency : Describe the structure and departments within the agency and the manner in which the departments interact

Populate a pricing table that includes basic training : Design and populate a Pricing table that includes basic training rate information. Designate the "Technical" field type as "Yes/No"and prepare a query that lists the participants who are only confirmed.

Calculate number of shares outstanding after stock dividends : Calculate the number of shares outstanding after the stock dividends are issued. What is the maximum amount that the corporation could use for cash dividends on that date?

Improvement teams blame human errors for harm to patients : Most quality improvement teams blame human errors for harm to patients. Is this true? Why or why not - Review the following scenario and justify your discussion about it.

Calculate the electric field intensity at a distance : Calculate the electric field intensity at a distance 'd' along the z-axis in terms of a,b,c, and d. Explain your reasoning. This result should be analytic.

Define the cloud computing and social networking tools : Cloud computing Social networking tools

User Account

All Pages