A Guide to SQL 10th Edition by Philip J. Pratt , Mary Z. Last Solution manual
A Guide to SQL
( Solution manual)
A Guide to SQL 10th Edition by Philip J. Pratt , Mary Z. Last Solution manual
Edition: 10th Canadian
Author Name: Philip J. Pratt , Mary Z. Last
contact:
Whatsapp +1 (949) 734-4773
for the Facebook page click here
for more books for ( Test Bank and Solution Manual) click here
sample free
Chapter 1
Introduction to Kimtay Pet Supplies and StayWell Student Accommodation Databases
At a Glance |
Instructor’s Manual Table of Contents
- Overview
- Chapter Objectives
- Teaching Tips
- Quick Quizzes
- Class Discussion Topics
- Additional Projects
- Additional Resources
- Key Terms
Lecture Notes |
Overview
In this chapter, students examine the database requirements of KimTay Pet Supplies—a company that is used in the examples throughout the text. Students also examine the database requirements for StayWell, whose database is featured in the exercises that appear at the end of each module.
Chapter Objectives
After completing this chapter, students will be able to accomplish the following:
- Introduce KimTay Pet Supplies, a company whose database is used to manage a pet supplies business. The KimTay database is used as the basis for many of the examples throughout the text.
- Introduce StayWell, a Seattle-based company whose database is used to manage accommodation for university students on behalf of property owners. The StayWell database is used as an additional case that runs throughout the text.
Teaching Tips
What Is a Database?
- Define database. A database is a structure that contains different categories of information and the relationships between these categories.
- The KimTay Pet Supplies database contains information about categories such as sales representatives (sales reps), customers, invoices, and items.
- The StayWell database contains information about the offices that manage the accommodation, the owners of the accommodation, the residents, and the services (such as cleaning and maintenance) offered for the properties.
- Each database also contains relationships between categories. The following are some examples:
- The KimTay Pet Supplies database contains information that relates sales reps to the customers they represent and customers to the invoices they have placed.
- The StayWell database contains information that relates the two main company offices to the properties that they manage, the owners, the different services to the service request, and to the resident renting a property.
There are no reviews yet.