HANDS ON DATABASE by Steve Conger
© 2010

Hands ON Database

Introduction
Many students taking an introductory database course need hands-on experience. Typically they are under pressure to finish quickly with a certificate or degree and get to work. They need to get actual practice in the process of designing and developing databases that they can apply in their future employment. They need to create tables, enter data, and run SQL queries. This book is designed for them. Hands on Database: an Introduction to Database Design and Development focuses on the process of creating a database. It guides the student through the initial conception of the database. It covers gathering of requirements and business rules, the logical and physical design and the testing of the database. It does this through a continuous narrative that follows a student, Sharon, as she designs and constructs a database to track the tutoring program at her school. It shows some of her missteps as well as her successes. Students get hands-on experience by doing practices and developing scenarios that parallel the narrative. After completing this book students will have a good sense of what is involved in developing and creating a database. Below is a list of the book outcomes. A student who has completed this book will be able     to give a general definition of a relational database to identify a variety of ways to gather database requirements to define business rules for a database to create an Entity design for a database

2

Hands ON Database
     to normalize a design up to third normal form to develop a database in a given DBMS to run SQL Queries against sample data to test requirements and business rules to define the general security context of a database and its users to document the process of database design and development

The Scenario Approach
The scenario