A relational database is a collection of data organized in two-dimensional tables consisting of named columns and rows. Each table represents the mathematical concept of a relation as defined in set theory. In set theory, columns are known as attributes and rows are known as tuples. The operations that may be performed on tables are similarly based on manipulation of relations to produce new relations, usually referred to as queries or views.
Relational databases differ from non-relational databases in that the database user is not aware of system dependencies that may be stored within the data. No knowledge of the underlying database is required; data can be queried and updated using standard languages (these languages together make up SQL) that produce a consistent result. SQL Server databases are relational....
Subscribe
