⊿ Point. {R} Glossary. ◢ Keyword: R. ▰ Sources. 〓 Books [B] ◥ University. {q} PhD. ⏫ THEMES. ⏫ Big Data. [B] Big Data. ⚫ USA. ↂ EndNote. ☝️ BD Dummies. Relational Database. In the relational model, each table schema must identify a column or group of columns, called the primary key, to uniquely identify each row. A relationship can then be established between each row in the table and a row in another table by creating a foreign key, a column or group of columns in one table that points to the primary key of another table.
The relational model offers various levels of refinement of table organization and reorganization called database normalization. (See Normalization below.) The database management system (DBMS) of a relational database is called an RDBMS, and is the software of a relational database. In relational databases, each data item has a row of attributes, so the database displays a fundamentally tabular organization. Relational databases are both created and queried by DataBase Management Systems (DBMSs). Terminology[edit] Relational database terminology. Relations or Tables[edit] Tuples by definition are unique. Base and derived relations[edit]