Bissoy.com
Doctors Medicines MCQs Q&A

Let E1 and E2 be two entities in an E/R diagram with simple single-valued attributes. R1 and R2 are two relationships between E1 and E2, where R1 is one-to-many and R2 is many-to-many. R1 and R2 do not have any attributes of their own. What is the minimum number of tables required to represent this situation in the relational model?

Let E1 and E2 be two entities in an E/R diagram with simple single-valued attributes. R1 and R2 are two relationships between E1 and E2, where R1 is one-to-many and R2 is many-to-many. R1 and R2 do not have any attributes of their own. What is the minimum number of tables required to represent this situation in the relational model? Correct Answer 3

The correct answer is option 1.

Concept:

ER Diagram stands for Entity Relationship Diagram, also known as ERD is a diagram that displays the relationship of entity sets stored in a database. In other words, ER diagrams help to explain the logical structure of databases. ER diagrams are created based on three basic concepts: entities, attributes and relationships.

Note:

Minimum number of tables between two entities. Suppose R is relation between two entities E1 and E2 with some cardinality ratio like,

cardinality ratio one to one:

2 tables,

  • E1R, E2 or
  • E1, E2R

cardinality ratio one to many:

2 tables,

  • E1, E2R

cardinality ratio many to one:

2 tables,

  • E1R, E2

cardinality ratio many to many:

3 tables,

  • E1, E2, R

Given data,

[ alt="F1 Shraddha Harshita 21.2.2022 D5" src="//storage.googleapis.com/tb-img/production/22/02/F1_Shraddha_Harshita_21.2.2022_D5.png" style="width: 449px; height: 278px;">

Only three table are requried,

  • E2 R1
  • E1
  • R2

Hence the correct answer is 3.

Related Questions

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. 
An enterprise data model is a relational model that shows the high-level entities for the organization and associations among those entities.
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create anapplication. The application uses the ADO.NET Entity Framework to model entities. Theapplication allows users to make changes to entities while disconnected from the central data store. You need to ensure that when the user connects to the central data store and retrieves new data, the application meets the following requirements:
  • Changes made to the local data store in disconnected mode are preserved.
  • Entities that have already been loaded into the local data store, but have not been modified by the user, are updated with the latest data.
What should you do?
Five tables T1, T2, T3, T4 and T5 are kept one above the other (Not necessarily in the same order) Number of tables above T4 are same as the number of tables below T5. T3 is just above T1. T5 is at the bottom. There are two tables between T2 and T5. Which of the following is the correct position of T1?
In the following passage, some of the words have been left out. Read the passage carefully and select the correct answer for the given blank out of thefour alternatives.
Enterprising skill is the ______________ of a teacher to see the perspective of the entire institution and the inter-relationships _____________ and between its parts. Itincludes the ability of a teacher to visualise the academic pursuit ___________ a holistic manner and consider a situation in totality. These skills involve _______________abstract and innovative ideas, constructing models and relationships, and anticipating the implications ________ actions.
inter-relationships _____________ and between
Read the passage carefully and select the best answer to each question out of the given four alternatives.
Public opinion may be passive and false or active and real. It is claimed in theory that all governments are ultimately based on the opinion or sanction of the governed. But we find that in practice the people's rights are often trodden down and tyranny and oppression are allowed to continue. The government does it not because the people want it to do so but because they are too idle, too uneducated and too disunited or timid to oppose the govern ment. Such public opinion is passive and false and not an active verdict. But when we find people alert, intelligent and determined to let the government know their will, when they want to exercise actively their voice in the management of their country, we have an instance of true or active public opinion. True public opinion is formed by and expressed through the press, the platform, political parties and educational institutions. These have sacred duties to perform, duties on which depends the ultimate good of the entire community. The press today wields a tremendous influence, So it should support the causes and move ments and condemn the wrong one's and thus teach people to form correct opinion. A free and fair press ventilates the grievances of the public. Thus a healthy relationship develops between the people and the government through out an unbiased press. Political parties also help to create and regulate opinions. No less important part is played by the educational Institutions which train the minds of the young people who will be the citizens of tomorrow. It has been said that modern Germany and China have been made by their universities. It is necessary that the young and the growing minds should imbibe the spirit of fellow-feeling, the spirit of tolerance, the habit of compromise, and show due regard for the feelings and opinion of others without which a democratic society cannot function, let alone succeed. When there is true awakening of the people, we shall have the real and conscious public opinion. And justice will reign on earth and truly will the voice of the people be the voice of God.
According to the passage, which of the following is needed from the people to have true or active public opinion? 1. Alertness
2. Determination
3. Intelligence
4. Raising their voice
Read the passage carefully and select the best answer to each question out of the given four alternatives.
Public opinion may be passive and false or active and real. It is claimed in theory that all governments are ultimately based on the opinion or sanction of the governed. But we find that in practice the people's rights are often trodden down and tyranny and oppression are allowed to continue. The government does it not because the people want it to do so but because they are too idle, too uneducated and too disunited or timid to oppose the govern ment. Such public opinion is passive and false and not an active verdict. But when we find people alert, intelligent and determined to let the government know their will, when they want to exercise actively their voice in the management of their country, we have an instance of true or active public opinion. True public opinion is formed by and expressed through the press, the platform, political parties and educational institutions. These have sacred duties to perform, duties on which depends the ultimate good of the entire community. The press today wields a tremendous influence, So it should support the causes and move ments and condemn the wrong one's and thus teach people to form correct opinion. A free and fair press ventilates the grievances of the public. Thus a healthy relationship develops between the people and the government through out an unbiased press. Political parties also help to create and regulate opinions. No less important part is played by the educational Institutions which train the minds of the young people who will be the citizens of tomorrow. It has been said that modern Germany and China have been made by their universities. It is necessary that the young and the growing minds should imbibe the spirit of fellow-feeling, the spirit of tolerance, the habit of compromise, and show due regard for the feelings and opinion of others without which a democratic society cannot function, let alone succeed. When there is true awakening of the people, we shall have the real and conscious public opinion. And justice will reign on earth and truly will the voice of the people be the voice of God.
Which of the following is not the reason for the oppression caused to general public by the running government in the country?
In the following figure, Triangle represent school, Square represent college, Circle represent Students, Rectangle represent Private college, and Trapezium represent Distance learning. Which set of letter represent college student that opted for distance learning.
In the relational model, relationships between relations or tables are created by using:
The Weberian model of bureaucracy has been criticised from a variety of stand points.
Consider the following points in this regard:
1. The Weberian model appears to be a 'machine theory' and a closed system model taking little account of organisational interactions with the environment.
2. The structural features of bureaucracy as laid down by Weber might be suitable for routine and repetitive tasks but these would produce dysfunctional consequences in terms of human behaviour if the jobs would involve innovation and creativity.
3. Weberian model has not been found to respond adequately to the tasks of socioeconomic transformation in the developing countries. These tasks require quick changes whereas the capacity of the Weberian model for adaptation to change is rather slow.
4. Weber's model is confined to the study of formal bureaucratic structure and fails to take notice of the informal structure of bureauracy such as informal relations, informal norms and values, an informal power hierarchy and informal power struggles.
Which of the above points make a valid criticism of the Weberian model? Select the correct answer from below: