answersLogoWhite

0

Relationships happen between two tables.

One to Many means that one objects (called tuples, or rows) of Table A is related to one or more objects in Table B.

For example, if a doctor can work only in one hospital, and we have a table of hospitals and a table of doctors, Hospitals has a One to Many relationship with Doctors, because for each hospital you will have one or more doctors working at it.

Many to Many means that for each object in Table A, one or more objects in Table B are associated, and viceversa.

In the example, if doctors are allowed to work in different hospitals, the table Hospitals and the table Doctors have a Many to Many relationship.

Now, how to implement this in a relationship DB, that is another question.

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

What is the most common type of relationship between tables in a relational database?

one-to-many relationship


What is one to many relationship in database er diagram?

A one-to-many relationship means that one row in one of the tables will relate directly to many rows in the other table.


What is a one-to-many relationship?

It is a term from computer databases. A relational database can have a one-to-many relationship in its data. For example, if you have a customer order database, one table will contain customer names and another will contain their orders. Each customer will only be listed once, but each customer can make many orders. So one customer can be related to many orders. Incorporating that into a database requires the creation of a one to many relationship.


Why many to many relationship does not exist in Msaccess?

Many to many relationships do exist in Microsoft Access. A many to many relationship in any database is done by creating a junction table and linking it to two other tables. A many to many relationship is a combination of two one to many relationships. This can be done in any relational database, including Microsoft Access.


Distinguish between a relation and a relationship in database?

Relation is one record in the database or a tuple. Relationship is that how tables are connected to each other.


What are the Different types of relationship in a database?

There are mainly three types of relationships in database . These are One to One , One to Many , Many to Many. One to one relationship can be seen as relationship between husband and wife , one to many relationship can be seen as a relationship between a college and students.


How Many to Many Relationship is being developed in ER data model?

Database is the collection records . There are three types of relationships in DB : one to one , one to many, many to many.


When do you have to use an intersection entity in database?

If you have a many-to-many relationship between two entities you create an intermediate entity between.Now, the relationship between the first entity and intersection entity is one-to-many, and the relationship between the second entity and intersection entity is one-to-many also.


What is one to one relationship?

There are three types of relationship in a database . One to one, one to many and many to many , Example of many to many relationship is relation between teachers and students, n teachers can have m students.


What is a simple database program whose records have no relationship to one another?

flat file


What is a one-to-many relationship in Access?

The easiest way to create a one-to-many relationship in the Access Relationships window is by first dragging the tables you need onto the grey part of the screen. Theen drag the primary key field of a table onto a field of another table to create a one-to-many relationship. When you release the mouse button over the field in the other table, the "Edit Relationships" will will automatically appear. This window will allow you to create the one-to-many relationship and set referential integrity and cascading rules.


What are predicates that define correct database states and relationship with in database?

schema