Bissoy.com
Doctors Medicines MCQs Q&A

Consider the "Supply" relationship relating the entities "Supplier" and "Product". Under default assumption. what will be the cardinality of the "Supply" relationship?

Consider the "Supply" relationship relating the entities "Supplier" and "Product". Under default assumption. what will be the cardinality of the "Supply" relationship? Correct Answer M : N

The correct answer is option 3.

Concept:

The cardinality ratio is express the number of entities to which another entity can be associated via a relationship set.

  • One-to-One Relationship
  • One-to-Many or Many-to-One Relationship
  • Many-to-Many Relationship

Many-to-Many Relationship:

A many-to-Many relationship in DBMS is a relationship between more than one instance of an entity with more than one instance of another entity i.e. both the entities can have many relationships between each other.

Example:

Hence the correct answer is M : N.

Additional Information One-to-One Relationship:

Such a relationship exists when each record of one table is related to only one record of the other table.

Example:

[ alt="F2 Harshita 14-01-22 Savita D1" src="//storage.googleapis.com/tb-img/production/22/01/F2__Harshita_14-01-22_Savita_D1.png" style="width: 326px; height: 66px;">

One-to-Many or Many-to-One Relationship:

The relationship exists when each record of one table can be related to one or more than one record of the other table. This relationship is the most common relationship found. A one-to-many relationship can also be said as a many-to-one relationship depending upon the way we view it.

[ alt="F2 Harshita 14-01-22 Savita D2" src="//storage.googleapis.com/tb-img/production/22/01/F2__Harshita_14-01-22_Savita_D2.png" style="width: 326px; height: 66px;">

[ alt="F2 Harshita 14-01-22 Savita D3" src="//storage.googleapis.com/tb-img/production/22/01/F2__Harshita_14-01-22_Savita_D3.png" style="width: 326px; height: 66px;">

Related Questions

If cardinality of (A U B) = cardinality of A+ cardinality of B. This means ____________
The question given below consists of a statement, followed by three arguments numbered I, II and III. You have to decide which of the arguments is/are ‘strong’ arguments and which is/are ‘weak’ arguments and accordingly choose your answer from the alternatives given below each question. Statement: India’s telecom watchdog has suggested regulation of all entities dealing with consumer data—devices such as iPhones, operating systems such as Android, browsers like Google’s Chrome and apps such as Facebook, Paytm, Uber or Zomato— by bringing them under licence conditions that apply to telecom service providers until a general data protection law is put in place by the government. Which of the following argument weakens the above statement in the best possible manner? Arguments: I. The Telecom Regulatory Authority of India (Trai) said the framework for protection of personal information is ‘not sufficient’ and that the issue of data ownership, privacy, and security is complex and multi-dimensional. It suggested expanding the ambit of licence conditions governing telcos to all entities handling customer information and empowerment of customers to keep their data secure. II. The telecom watchdog further said that individual users owned their data, or personal information, and entities such as devices were ‘mere custodians’ and do not have primary rights over that information. III. Telcos and internet service providers (ISPs) though welcomed recommendations that sought to bring app makers under the same regulations. However, content providers have been opposed to being brought under more regulation. 
In the question given below, there is a statement followed by two assumptions numbered I and II. An assumption is something supposed or taken for granted. You have to consider the statement and assumptions and then decide which of the assumption(s) is/are implicit in the statement. You have to consider the statements to be true even if they seem to be at variance from commonly known facts. Statement: Many big actors like Shahrukh Khan, Naseeruddin Shah come from NSD. Assumption I: NSD is the only institute which gives great actors to the film industry. Assumption II: If you want to be a great actor you have to be a student of NSD.
In an Entity-Relationship (ER) model, suppose ? is a many-to-one relationship from entity set E1 to entity set E2. Assume that E1 and E2 participate totally in ? and that the cardinality of E1 is greater than the cardinality of E2. Which one of the following is true about ??
In the question below, a statement and assumptions numbered I and II are given. An assumption is something supposed or taken for granted. You have to consider the following assumption and decide which of the assumption is implicit in the statement. Statement: Speaking about 'Veere Di Wedding' being slammed for showing female characters who use cuss words, actor Sumeet Vyas questioned, "People are so prejudiced. What's wrong if women use such language?" Assumption I. Only uneducated women use foul language and educated women use cuss words. II. It's a regular thing for [both] men and women to use cuss words while communication in informal communication.
In a question below is given a statement. An assumption is something supposed or taken for granted. You have to consider the following assumption and decide which of the assumption is implicit in the statement. Statement: "Policies and programmes and seminars cannot change the women's status. There is a greater need for attitudinal change in the society towards working women." — View of Mr. X. Assumption: I. It is possible to make change in the attitude of the society towards working women. II. Status of the working women is not satisfactory. 
In a question below is given a statement. An assumption is something supposed or taken for granted. You have to consider the following assumption and decide which of the assumption is implicit in the statement. Statement: "Government of State X's state, according to which it has been decided to provide a cooked meal to the students of all primary schools of the states, is not a proper and judicious step." — Criticism by a person. Assumption: I. Student may hesitate to eat the cooked meal provided by the Government. II. The cooked meal served to the students may be hazardous for the health of students. 
In a question below is given a statement. An assumption is something supposed or taken for granted. You have to consider the following assumption and decide which of the assumption is implicit in the statement. Statement: "Please drop this letter in the letterbox". An officer tells his assistant. Assumption: I. The assistant would follow the instruction. II. The assistant knows the address where the letter is to be sent.  
A statement is followed by two assumptions numbered I and II. Considered the statement and the following assumption and decide which of the assumption and decide which of the assumption is implicit in the given statements? Statement : Lalita has a large collection of books and she keeps on purchasing new books to add to her collection. Assumption : I - Lalita has read each and every book that she has purchased. II - Lalita has love and passion for books.
Consider the following statements about the Scheduled Castes and the Scheduled Tribes under the provisions of the Constitution of India : 1. State can make any special provision relating to their admission to the Government educational institutions. 2. State can make any special provision relating to their admission to the private educational institutions aided by the State. 3. State can make any special provision relating to their admission to the private educational institutions not aided by the State. 4. State can make any special provision relating to their admission to the minority educational institutions as described in Article 30. Which of the statements given above are correct?