Page 69 - Database-En-V3

• It shows you a one-to-one and one-to-one relationship
between the two tables:

ONE TO MANY RELATIONSHIP
• It is the most common among relationships. In this type of
relationship, a row from column A can contain many identical
rows in table B.
• For example: The Departments table and the Computers
Students table, have a one-to-many relationship, as each
department has many students, but each student has only one
department. In this type of relationship, the primary key is
denoted by the key symbol, and the foreign key by the infinity
symbol.

62 Training unit in the field of technological information - at the Supreme Council of Universities © Intellectual property rights 2024