 |
Can you make a relationship between two tables in a Database Management System DBMS? |
[Edit] |
Yes, a Database Management System's main advantage is that it will enforce relationships between tables in a database preventing you from entering data in one field in another table that does not already exist in another table. So for example if you have a database that tracks online purchase, the DBMS would prevent a product that does not already exist in the Products table from being added to a shopping cart table. Or an employee ID from being added to a timecard table that does not already exist in the employee table. Databases can be setup without enforced relationships, but doing so usually results in orphaned records (for instance, where and employee id exists in the timecard table that does not exist in the employee table.)
First answer by Eisaacs. Last edit by Eisaacs. Contributor trust: 49 [recommend contributor]. Question popularity: 4 [recommend question]
Answers.com > Wiki Answers > Categories > Technology > Computers > Computer Databases > Can you make a relationship between two tables in a Database Management System DBMS?
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. |
