TY  - GEN
AU  - Robert Grauer
AU  - Maryann Barber
TI  - Database Management Using dBase IV and SQL
T2  - serie
SN  - 0-07-911218-8
PY  - 1992///
CY  - United State 
PB  - McGraw-Hill
KW  - Ingeniería en tecnologias de la información y comunicaciones
N1  - Editorial 
McGraw-Hill
ISBN 
0-07-911218-8; Contents in Brief

PARTI

Introduction 1

CHAPTERI

Introduction 3

CHAPTER 2

The Dot Prompt

25

CHAPTER 3

Indexing 47

PART II

The Control Center 69

CHAPTER 4

The Report Generator

71

CHAPTER 5

Mail Merge and Label Forms 100

CHAPTER 6

Queries and Conditions

120

CHAPTER 7

The Screen Generator

146

CHAPTER 8

The Control Center

167

PART III

Command-Level Programming

191

CHAPTER 9

Introduction to Programming

193

CHAPTER 10

Design and Implementation

225

CHAPTER 11

File Maintenance

245

PART IV

Relational Databases 269

CHAPTER 12

Relational Databases 271

CHAPTER 13

Implementation in dBASE IV

288

CHAPTER 14

Introduction to SQL

310

The Programmer's Notebook

PN-1

Index IN-1

PART III

Command-Level Programming 191

CHAPTER 9

Introduction to Programming 193

Overview 194

A Menu-driven Program 194

Structured Programming 195

Sufficiency of the Basic Structures 196

Pseudocode 198

Developing the Menu-driven

Program 199

Implementation in dBASE 201

Statements for Structured

Programming 203

Input Output Statements 204

Memory Variables 204

Statements Affecting the Record

Pointer 204

The Completed Program 205

Implementation on the Computer

206

Hands-on Exercise 1: Menu-driven

Programs 207

Errors in Execution 212

The DEBUG Command 212

Hands-on Exercise 2: The

Debugger 215

Coding Standards 217

Program Documentation

Summary 218

Key Words and Concepts

218

True/False 220

219

Exercises 220

CHAPTER 10

Design and Implementation

225

Overview 226

Case Study Soleil America, Revisited 226

Structured Design 228

Creating the Hierarchy Chart

229

Evaluating the Hierarchy Chart

230

Functionality 230

Completeness 230

Subordination 231

Structured Design versus Structured

Programming 231

The DISPLAY-MAIN-MENU

Program 255

Top-down Implementation 255

Hands-on Exercise 1 Top-dow

Testing/1 237

Additional Testing 237

Hands-on Exercise 2 Top-down

Testing 2 259

Advantages of Top-down

Implementation 241

Summary 242

Key Words and Concepts 242

True/False 243

Exercises 243

CHAPTER 11

File Maintenance

245

Overview 246

Limitations of the Dot Prompt 2%. Hands-on Exercise 1 Limitations of

Dot Prompt 247

250

The ADDRECD Program

The Hierarchy Chart

250

Pseudocode 251

251

The dBASE Listing

SET Commands 252

Procedures 255

The STORE Command 257

The SEEK Command 257

Additional Program Listings 25

Public and Private Variables 25

File Maintenance 260

Hands-on Exercise 2: The File

261

Summary 265

Maintenance Program

Key Words and Concepts

265

True/False 265

Exercises 266

PART IV

Relational Databases 269

CHAPTER 12

Relational Databases 271

Overview 272

Case Preview 272; Ingeniería en Tecnologías de la Información y Comunicación
N2  - After reading this chapter you will be able to

ated with subdirectories and describe the purpose of each 2. Differentiate between installation and loading; install and load the student version

OBJECTIVES

of dBASE IV 3. Install the data disk that accompanies this text, describe the tree structure of the

data disk and how to change from one directory to another.

4. Distinguish between the different versions of dBASE Load dBASE and arrive at the dot prompt, provide the dBASE command to change

5. the default drive.

6. Differentiate between report generation and data entry, describe the primary data entry operations

7. List several types of data validation that may be done during the course of data entry describe the effects of entering improper data into a system
ER  -