estbankSolution Manual for Concepts of Database Management 9th Edition by Starks

We have designed this Instructor’s Manual to supplement and enhance your teaching experience through classroom activities and a cohesive chapter summary.

This document is organized chronologically, using the same heading in red that you see in the textbook. Under each heading, you will find (in order): Lecture Notes that summarize the section, Figures and Boxes found in the section, if any, Teacher Tips, Classroom Activities, and Lab Activities. Pay special attention to TeacherTips and activities geared towards quizzing your students, enhancing their critical thinking skills, and encouraging experimentation within the software.

Table of Contents

The learning objectives for chapter OneCare:

1: BITS Company Background

LECTURE NOTES

FIGURES: 1–1, 1–2

TEACHER TIPS

Students will work with BITS in every chapter. They should become familiar with this fictitious company and the type of data it needs to maintain. The same type of data needs to be stored by other consulting companies or service providers.

If you want to personalize the database, you have students add their name as a customer or you can have them rename the database using their own name rather than BITS.

CLASSROOM ACTIVITIES

4: Database Solution

LECTURE NOTES

FIGURES: 1–3, 1–4, 1–5, 1–6, 1–7

TEACHER TIPS

Database concepts such as entity, attribute, and relationship are often difficult for students to grasp. Use examples that students can relate to, for example, a school database or a database maintained by the state department of public safety (driver’s licenses). A good analogy to use is an employment application form. The items that we complete on the form are attributes, and the completed application (entity example) describes the person who completed it.

Figure 1–5 lists the five tables that make up the BITS database. Each table represents an entity. The data in the tables are related through common fields. It is these relationships that allow the user to access data from more than one table and produce reports, queries, and forms. Encourage students to use the embedded Q & As to test their understanding of the concepts as well as the design of the BITS database.

Related posts:

When I started learning how to improvise, it wasn’t so I could improve my writing. Actually, it wasn’t specifically about creativity at all. It was about fun and love. One lonely night, I’d sat down…

Over the next five years, the way businesses manage their customer engagement will undergo a significant shift. Companies that don’t innovate and adapt will be left behind. This article will cover…

Nothing is more unnerving than watching your boss, your parent, your teacher, or your coach LOSE IT. I mean, these are the people you expect to model the proper way to process through stress. On the…