Page 72 - Database-En-V3

Table of study subjects Computer students

Student code Student code
Material code sitting number
student's name
comments the total
Arabic
phone number
Department code

Thus, there is a many-to-many relationship between the
computers students table and the academic subjects table

This presents a problem. To understand the problem, imagine what

would happen if you tried to create a relationship between two tables by
adding the Student Code field to the Personal Data table. To have more than
one statement for each student, you will need more than one record in the
spreadsheet for each student. You may duplicate order information for each
row associated with a single order, resulting in insufficient design that may
result in incorrect data. You will encounter the same problem if you place
the Student Code field in your personal spreadsheet, as you will have more
than one record in the spreadsheet for each product. How can you solve this

problem?

The solution is to create a third table, often called a connection table,
where you split the one-to-many relationship into two one-to-many
relationships. You can insert the primary key from both tables into the third
table. As a result, Table III records all occurrences or instances of the

relationship.

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