designing and populating tables in microsoft access

Project Description:

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
...
Skills Required:
Project Stats:

Price Type: Negotiable

Expired
Total Proposals: 2
1 Current viewersl
7 Total views
Project posted by:

Proposals

Proposals Reputation Price offered
  • 0.0
    1 Jobs 0 Reviews
    $0 in 0 Day
  • 0.0
    0 Jobs 0 Reviews
    $0 in 0 Day