This preview shows pages 1–3. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: the Technical field type as YES/NO (Boolean) Using these data, design and populate a course table. Designate the Course ID 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) Prepare a query that lists each course name and its cost per day of training. Prepare a query that list 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 HOTTs per-day pricing schedule. Deliverables Database - Pricing Table-Course Table Query - Course Name vs. Cost Cost Per Student Name: Student ID: Chapter 5: Case Analysis #1 Joining Tables Date of Submission: May 6, 2009 Dr. M. Badamas...
View Full Document
- Spring '10