AllFreePapers.com - All Free Papers and Essays for All Students
Search

Fundamentals of Relational Model

Autor:   •  September 30, 2011  •  Research Paper  •  560 Words (3 Pages)  •  1,600 Views

Page 1 of 3

TABLE OF CONTENTS

1. INTRODUCTION

2. HISTORY OF RELATIONAL MODEL

3. RELATIONAL DATABSE DESIGN

4. TABLE,UNIQUENESS,KEYS

5. FOREIGN KEYS AND DOMAINS

6. RELATIONSHIPS

7. NORMALIZATION

8. DENORMALIZATION

9. CHARACTERISTICS OF RELATIONAL MODEL

10. ADVANTAGES

11. DISADVANTAGES

12. CONCLUSION

13. REFERENCES

INTRODUCTION:

• Relational model is most widely used data model for commercial data-processing. The reason it’s used so much is, because it’s simple and easy to maintain.

• The model is based on a collection of tables. Users of the database can create tables, insert new tables or modify existing tables. There are several languages for database programming.

• SQL, Oracle, etc.

• The relational model is the most used data model for commercial data-processing because it is simple to use and to maintain.

• A relational data model is based on a collection of tables. The user of the database system may query these tables, insert new tuples, and update (modify) tuples. There are several languages for expressing these operations.

HISTORY OF RELATIONAL MODEL

• First proposed by a E.F. Codd in 1970. Codd proposed the Relational model in 1970.

• “ A relational model of data for large shared data banks.”

• He linked the representation of data with that of mathematical sets.

• First research started at IBM’s San Jose Research Laboratory. Prototype was called System R.

• Commercial RDBMS’s started to appear in late 1970’s and early 1980’s. Most well known is Oracle.

• Codd

...

Download as:   txt (3.8 Kb)   pdf (82 Kb)   docx (11.8 Kb)  
Continue for 2 more pages »