Designing and populating a course table

Assignment Help Data Structure & Algorithms

Reference no: EM1380237

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. Use data to design and populate a course table. Designate the CourseID field as a "Primary Key" and allow your database to automatically produce 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: EM1380237

Questions Cloud

Define file type : Define File Type and provide some of the important information to know about it and where do file types come from?

Discuss and define normalization : Discuss and define normalization and what are the basic steps of the normalization process?

Miles per gallon application : All average calculations should produce floating- point results. Avoid division by zero- if the user enters zero for the number of gallons, in-form the user that the input value for gallons must be greater than zero.

Data warehouse and operational databases : Every big organization has large documents or databases containing data used in operating the business. Does a data warehouse differ from these operational files or databases?

Designing and populating a course table : Use data to design and populate a course table. Designate the CourseID field as a Primary Key and permit your database to automatically produce a value for this field.

Water resources engineering : The current practice of a particular part of water resources engineering is supported through a variety of commercial software. Pick a specific domain within water resources engineering.

Relationships in a database model : Discuss different types of classifications and do they overlap, or do they each tell us something unique about the entity relationship?

Gas pump - compute the total cost from the number of gallons : Write a program that will help an elementary school student learn multiplication and compute the total cost from the number of gallons entered and the selected grade.

Creating a database with asp.net : Make a database with a table called "MyUsers" and "MyRole" The table should have the following columns.

User Account

All Pages