 |
What is a relational database? |
[Edit] |
Answer
Relational Database is collection of interrelated data managed with their relations. Database holds both the structure (schema) of the relations and the data itself. These structures are usually called tables.
For example, a to represent people working in different organizations, we could have a Person table, an Organization table, and Works table. Person table would hold a unique identifier of each worker, along with other personal information. Organization table would hold a unique identifier of each organization, along with other information about that entity. Works table would hold the pairs of unique identifiers - one pair for each person working in one organization.
If a Person is never allowed to work in more than one Organization, we could avoid using the Works table and store the organization's identifier as a field within the Person table. That is called a foreign key.
First answer by Jk4friends. Last edit by Svemir. Contributor trust: 35 [recommend contributor]. Question popularity: 34 [recommend question]
|
Research your answer: |
Answers.com > Wiki Answers > Categories > Technology > Computers > Computer Databases > What is a relational database?
Our contributors said this page should be displayed for the questions below. (Where do these come from ) |
| If any of these are not a genuine rephrasing of the question, please help out and edit these alternates. |
