A Guide to MySQL, Pratt - Downloadable Solutions Manual (Revised)

Chapter 1



Introduction to Premiere Products, Henry Books, and Alexamara Marina Group




At a Glance


Table of Contents

 Overview



 Objectives



 Teaching Tips



 Instructor Notes



 Quick Quizzes



 Classroom Activities



 Discussion Questions



 Projects to Assign

, Key Terms

,Lecture Notes



Overview

In this chapter, students examine the requirements of Premiere Products, a fictitious company
used in the examples throughout the text. Students also examine the database requirements for
Henry Books and Alexamara Marina Group, two databases featured in the end-of-chapter
exercises. Finally, students learn about MySQL, a database management system.




Chapter Objectives

 Introduce Premiere Products, a company whose database is used as the basis for many of the
examples throughout the text
 Introduce Henry Books, a company whose database is used as a case that runs throughout the
text

 Introduce Alexamara Marina Group, a company whose database is used as an additional case
that runs throughout the text

 Introduce MySQL, a database management system




 Make sure students understand the types of businesses and categories used to
describe the databases. Ask them for corresponding real-life examples of the sample
Teaching businesses. For example, what distributors and bookstores are in your town? Are
Tips there any marinas near your location?
 Encourage students to use the embedded questions and answers included throughout
the chapter to test their understanding of the design of the three databases. It is
critical that students understand the entities, attributes, and relationships for the
Premiere Products database, the Henry Books database, and the Alexamara Marina
Group database. Students will use these databases in exercises and assignments
throughout the text.
 Make sure students understand how to navigate the tables in the three databases.

 Spend some time reviewing the concept of open source software with students. Have
the students read the information at the Free Software Foundation website
(http://www.gnu.org/) and the Open Source Initiative website

, (http://www.opensource.org/) to get an understanding of the history and philosophy
behind the open source movement.

 Explain the difference between proprietary database management systems, such as
Oracle and Microsoft Access and MySQL. With MySQL, you have access to the source
code. With proprietary software, you receive only the compiled code.

 Have students explore the MySQL website (http://www.mysql.com). Make sure
students understand how to download the software.

 Be sure that students understand that the MySQL commands discussed in this text are
the same under Linux and Unix and Mac OS. The examples in this book were done
using the Windows XP operating environment.




Instructor Notes


What is a Database?
Define database. A database is a structure that contains different categories of information and
the relationships between these categories. In a database, a table represents each category. The
Premiere Products database contains information about categories such as sales reps, customers,
orders, and parts. The Henry Books database contains information about categories such as
books, publishers, authors, and branches. The Alexamara Marina Group database contains
information about categories such as marinas, slips and the boats in them, service categories, and
service requests.



Each database also contains relationships between categories. For example, the Premiere
Products database contains information that relates sales reps to customers and customers to
orders. The Henry Books database contains information that relates publishers to books and
authors to books. The Alexamara Marina Group database contains information that relates boats
in the slip at the marina to the owners.




The Premiere Products Database