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 HOTT’s 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
- Relational model