Relational Database [RDB ]

A collective set of multiple data^[3] sets organized by tables, records^[4] and columns. RDBs establish a well-defined relationship between database^[2] tables. Tables communicate and share information^[1], which facilitates data searchability, organization and reporting.The most popular type of database used to store data for Human Resource applications. It conforms to a relational model^[5] that includes the use of data elements as common keys to enable table joins.

Defined Terms

1. ↑ information.

The by-product of having data in an HR System. Data is gathered and reviewed providing information for decision making.

2. ↑ database.

A set of data. A permanent, self descriptive store of interrelated data items arranged in a logical way that can be accessed by various computer programs.

3. ↑ data.

Numbers, characters, or images in a form which can be assessed by a human or (especially) input into a computer, stored and processed.

4. ↑ records.

A collection of data elements or fields pertaining to the same entity (i.e. an employee, job, location, etc.). For example, each employee has a record that contains only his/her information (e.g. name, address, date of birth, etc.) in the record.

5. ↑ model.

A graphical representation of a real-world event or process that needs to be communicated to all parties involved in system development to understand roles, steps, activities and outcomes associated with business events.

Glossary: Relational Database Management Systems [RDBMS]
A program that lets you create, update, and administer a relational database. Most commercial RDBMS's use the Structured Query Language (SQL) to access the database.

Start typing and press enter to search