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
One of the characteristic feature of the second generation computer is the presence of ...
Which of the following is safety measure in the computer laboratory? ...
Which of the following is an example of qualitative data? ...
In computing, ergonomics is a term associated with computer ...
Figure 5 is an MS PowerPoint application interface. The part used to apply motion effect to dif...
The arrangement that gives the correct order of magnitude of the database elements is ...
Which of the following objects is not located on the slide layout? ...
The following precautionary measures are taken against virus infection except ...
Information that stimulates both the senses of hearing and sight is called ...