What kind of relationship exists between users and produc...
Figure 4 is an entity relationship diagram in MS Access. Use it to answer the question
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
Correct answer is A
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".
Similar Questions
Which of the following malware does not replicate itself? ...
The capacity of a communication channel is referred to as ...
The design output of a graphic package can be in the following file formats except ...
In word processing applications, the symbol B, I and U are commonly used buttons found on the ...
A data element that uniquely identifies one record from the other in a table is the ...
A technician can protect itself from electronic discharge by using ...
The Difference Engine and the Analytical Engine were invented by ...
A Word document can have any of these file extension except ...