Database Management Using dBase IV and SQL /
Robert Grauer
Database Management Using dBase IV and SQL / - 1Era edicion - United State McGraw-Hill 1992 - 222 Ilustracion, tablas y graficos 28 CM - serie .
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
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
0-07-911218-8
Ingeniería en tecnologias de la información y comunicaciones
Database Management Using dBase IV and SQL / - 1Era edicion - United State McGraw-Hill 1992 - 222 Ilustracion, tablas y graficos 28 CM - serie .
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
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
0-07-911218-8
Ingeniería en tecnologias de la información y comunicaciones
