Not seeing a Scroll to Top Button? Go to our FAQ page for more info.

Last update: Mis à jour le 7 March 2018 Webmail |  Injira |  Iyandikishe |  Iyobokamana Radio |  Iyobokamana TV |  Swahili |  Kinyarwanda |  English |  Francais

 

Relational database builds the relationships between fields in tables explicitly

Written on 2016-07-04 08:19:53 By Billy










Relational database builds the relationships between fields in tables explicitly through "keyed" fields. Because the relationships are not handled programmatically but are integral to the data itself,

users can access the data without knowing the physical structure of the data (i.e. how the data is written on disk). Logically, relational databases lend themselves very efficiently to many situations, and because their structure is transparent, they can be designed and modified relatively easily.

2.4.4. Structured query language (SQL)
A language used by many Relational Database Management Systems to manipulate their data.

2.4.5. Database management system (DBMS)
A collection of programs that enables you to enter, organize, and select data in a database. The typical Database Management System includes the capability of storing data in tables, creating relationships between the data tables, querying data, creating reports, and managing the database itself.

Typical examples of DBMSs include Oracle, DB2, Microsoft Access, Microsoft SQL Server, PostgreSQL, MySQL, FileMaker and Sybase Adaptive Server Enterprise. DBMSs are typically used by Database administrators in the creation of Database systems.

Forum posts