RDBMS Database supports the relationship between tables. One can do this by linking the columns. This article shows how to modal the relationships One-to-One, One-to-Many and Many-To-Many with examples. The relationship One-to-Many can also be seen as Many-to-One.
Articles on SQL, TSQL and Management Studio. You can download Microsoft supplied sample database here: https://drive.google.com/file/d/0B8H2WLrOYbPxcy13RG9JNUpRRHM/edit?usp=sharing