Flat File Database System Vs Relational Database System

ABSTRACT

Determining the type of database to be deployed for a project is a combination of access requirements and preference. In an effort to make an informed decision on which to deploy, the application engineer should be familiar with the types of databases as well as the pros/cons of each. In this entry we will consider two general types of databases and explore some of their applications and key points in the decision cycle when faced with a project.

A "flat file" database allows the user to specify data attributes (columns, datatypes, etc) for one table at a time, storing those attributes independantly of an application. dBase III and Paradox were good examples of this kind of database in the CP/M and MS-DOS environments, and the original FileMaker was a good Mac O/S example. 

A relational database takes this "flat file" approach several logical steps further, allowing the user to specify information about multiple tables and the relationships between those tables, and often allowing much more declarative control over what rules the data in those tables must obey (constraints). 

TABLE OF CONTENTS

TITLE PAGE

CERTIFICATION

ACKNOWLEDGEMENT

DEDICATION

ABSTRACT

TABLE OF CONTENTS

CHAPTER ONE

1.0 INTRODUCTION

1.1BACKGROUND OF STUDY

1.3PURPOSE OF STUDY

1.4IMPORTANCE OF STUDY

1.5DEFINITION OF TERMS

1.6ASSUMPTION OF STUDY

DATA TRANSFER OPERATIONS OF THE FLAT FILE DATABASE SYSTEM

CHAPTER TWO

LITRATURE REVIEW

2.1 THE CONCEPT OF RELATIONAL DATABASE SYSTEM

CHAPTER THREE

3.0 FLAT FILE DATABASE SYSTEM VS RELATIONAL DATABASE SYSTEM

3.1 FLAT FILE DATABASE

3.2 RELATIONAL DATABASE

3.3 SELECTING A DATABASE: FLAT FILE VS. RELATIONAL

CHAPTER FOUR

4.0 COMPARING THE TWO DATABASE TYPES

4.1 ADVANTAGES OF A DATABASE

4.2 ADVANTAGES OF THE FLAT FILE DATABASE SYSTEM

CHAPTER FIVE

5.0 CONCLUSION AND REFERENCES

5.1 CONCLUSION

5.1LIMITATION OF STUDY

5.3  REFERENCES