It has been said "If it does not use SQL, it is not relational". Is there validity to this statement? Why? Why Not?
2006-09-28 07:58:04 · 3 answers · asked by salme1315 1 in Computers & Internet ➔ Programming & Design
Not at all.
relational databases were around before sql.
But, now a days every big db implementation has a sql interface...
so it is true in today's market place!
2006-09-28 08:08:19 · answer #1 · answered by jake cigar™ is retired 7 · 2⤊ 0⤋
No validity. Heré's why...
Strictly speaking, a relational database is merely a collection of relations (frequently called tables). Other items are frequently considered part of the database, as they help to organize and structure the data, in addition to forcing the database to conform to a set of requirements.
But, strictly speaking, Oracle, Microsoft SQL Server,PostgreSQL, and MySQL are not relational databases. Under popular usage of the term, these software packages are called "Relational Database Management Systems" (RDBMS), and as such they can be used to create relational databases. There is some disagreement as to whether or not they can be considered "relational", because they do not fully conform to the relational model.
http://en.wikipedia.org/wiki/Relational_database
2006-09-28 08:07:07 · answer #2 · answered by midnightlydy 6 · 0⤊ 0⤋
SQL is a 'language' or syntax to query and update the database. Using SQL does not not imply relational database. For example, using MS Query, you can use SQL to query excel file, access database and other database (using ODBC).
Relational Database is one that has keys that link tables. These can be diagramed using Entity Relationship Diagram.
2006-09-30 17:12:50 · answer #3 · answered by rmpbklyn 4 · 0⤊ 0⤋