Post Description

Define and develop a database through a scenario approach.

Hands-On Database uses a scenario-based approach that shows students how to build a database by providing them with the context of a running case throughout each step of the process.

See the material in action: Scenario Approach. It’s easier for students to grasp the concepts behind database design if they see it as a way to solve a particular set of business problems. In order to help give students this kind of context, Conger presents a scenario approach with an emphasis on defining business rules and then testing the database design against those rules.

    Running Case Scenario. The scenario that makes up the body of the book describes Sharon, a database student, in the process of creating a database to manage a school’s tutoring program. The text’s material progresses with Sharon’s experience as she moves through each step of the database building process.
    End-of-chapter Scenarios. At the end of each chapter, after the practices, there are four additional scenarios for students to work through:  

        The Wild Wood Apartments scenario involves creating a database to manage a chain of apartment buildings. 
        Vince’s Vintage Vinyl Record Shop scenario revolves around a small shop owner who needs a database to handle his inventory, sales, and purchases. 
        Grandfield College leads students through the process of making a database to track what software the school owns, the licensing for that software, on what machines the software is installed, and what users have access to those machines.   
        The WestLake Research Hospital scenario involves creating a database to track a double-blind drug study for a new antidepressant.

Understand the fundamentals: Traditional Chapter Conventions. Aside from the running case on Sharon, this text also presents several in-chapter support features, specifically designed to help students understand the core concepts.

    Things You Should Know. These extended sections provide definitions, explanations, and examples that offer a deeper, more comprehensive context to the things Sharon is doing in the narrative.
    Things to Think About. These sidebars invite students to consider questions about the processes or topics under discussion.
    Cautions. Found in the margins of the text, this feature warns students about potential mistakes or common errors.
    Documentation. Found at the end of each chapter, this feature provides a summary of how students would document the activities conducted during the chapter.
    Things to Look Up. Found at the end of each chapter, this feature guides students to other resources and topics not fully covered in the book.
    Vocabulary. Throughout the text, key words are highlighted in the margins and are repeated in an exercise at the end of each chapter.
    Practices. Found at the end of each chapter, practices are designed to give students hands-on experience with the materials of the chapter. 

View the entire development of a database: Process-driven Model. The material in this text is based on a process-driven model, ensuring that students see the process of developing a database from the beginning through to the final stages.

Gain insight into important topics:

    Normalization. Congers introduces students to the concepts and vocabulary of normalization by discussing the first three Normal Forms.
    SQL Coverage. Chapter 7 of this text contains an extensive introduction to SQL. This coverage is continued throughout the remainder of the text.
    Security Coverage. Security issues are discussed at several points in the book. It is brought into consideration during the information gathering phases in Chapters 2 and 3, but is dealt with in detail in Chapter 7.

Get familiar with popular, user-friendly software: Congers uses Microsoft® SQL Express 2008 R2 for the database and Microsoft Visio 2010 for the database diagramming. 

    Steve Conger
    ISBN-10: 013610827X • ISBN-13: 9780136108276
    ©2012 • Prentice Hall • Paper, 216 pp
    Published 01/04/2011 • Instock