Purchase Solution

Designing and Populating a Table

Not what you're looking for?

Ask Custom Question

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

Purchase this Solution

Purchase this Solution


Free BrainMass Quizzes
Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

Javscript Basics

Quiz on basics of javascript programming language.

Basic Networking Questions

This quiz consists of some basic networking questions.

Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.