Figure 4 is an entity relationship diagram in MS Access. Use it to answer questions 22 and 23.
What kind of relationship exists between users and products as shown in Figure 4?
-
One-to-many
- Many-to-many
- One-to-one
- Many-to-one
The correct answer is: A
Explanation
Looking at the arrow (relation) that connects Products table to the Users table. The infinity sign beside the products table represents the "Many" part of the relationship which is not present at the Users table (i.e it is "One" part of the relationship) . This means that a user can buy "any" number of products but a product can only be bought by "a" user. Therefore, the relationship between the "users" and "products" is one-to-many.
NB: Users are assumed to be buying products for illustration purposes.
Many-to-one relationship is if it's between the "Products" and the "Users".