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.

Reviews

Write a Review

Data Structure & Algorithms Questions & Answers

  Explain algorithm from is optimal by proving lower bound

Illustrate that your algorithm from (a) is optimal by proving lower bound of n - k on number of comparisons required to solve the problem.

  Programming language problems

Many programming languages do not permit you to ask two or more questions in a single comparison by using a logical And Operator

  Creating an automated checkout program

A local department store employee you to create an automated checkout program to expedite customers in a hurry. The checkout line can only allow 5-products for any one purchase.

  What do you meant by an rfp

Select a specific category of vertical applications to investigate. Use the Internet and any other sources of information you might have to study some of the different products that are available in that category.

  Refresh address counter

A microcomputer memory is built from 64K X 1 DRAM, with DRAM cell array organized into 256 rows. Each row requires being refreshed at least once every four ms, strictly on a periodic basis.

  Survey of fault tolerance policy for load balancing scheme o

This paper investigates about fault-tolerance in load balancing schemes in distributed environment. There are some more parameters influencing QOS but our main focus is on fault tolerance and load balancing.

  Explaining playout delay algorithm

Let the adaptive playout delay algorithm. Show through simple example that adjusting playout delay at beginning of each talk.

  Efficient algorithm that achieves goal using base station

So that every house is within four miles of one of the base stations. Write efficient algorithm that achieves this goal, using as few base stations as possible.

  Write algorithm by using pseudo code consensus algorithm

Write the algorithm, by using pseudo code, "Consensus algorithm": A group of ten people require to decide which one flavor of ice cream they will all order, out of three options.

  Finding page faults for lru replacement algorithms

How many page faults would happen for the given replacement algorithms, assuming one, two, three, and four frames?

  Create a program using c++

Create a program using C++ or Java that will automatically generate x numbers between a range provided by the user? For purposes of this project, the range can be 1-20 and store them in an array.

  Recurrence-worst case running time-recursive binary search

Provide a recurrence for worst case running time of recursive Binary Search function in terms of n, the size of the search array. Solve the recurrence.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd