Fundamentals of Relational Model
Autor: sri12345 • September 30, 2011 • Research Paper • 560 Words (3 Pages) • 1,610 Views
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
...