Relational File Model
The Relational Model is introduced by a German Scientist Dr. E.F. Codd in 1970 on Mathematical concept known as relational Algebra. In relational model represents data in the form of two dimension table. Each table represents the real world object or thing. The management of data into relational model is known as the logical view of the database.
The examples of relational model databases are Oracle, Microsoft SQL Server, MySQL, Sybase etc.
There are some features of relational model.
1: The relational model removed all parent child relationships and instead characterizes all data in the database as simple row/column tables of a data values.
2: A relation is similar to a table row /columns of data values.
3: Each table is an independent entity and there is no physical relationship between tables.
4: relational model is bsed on set theory.
5: Most data management system based on the relational model take support of query languages. These query language are in simple English language.
No comments:
Post a Comment