answersLogoWhite

0

What is many-to-many relationship in database?

Updated: 8/17/2019
User Avatar

Wiki User

12y ago

Best Answer

An many-to-many relationship exists when an entity A can have a relationship with multiple entities B and vice versa.

Examples

An employee may learn many jobs skills, and each job skill may be learned by many employees. EMPLOYEE learns SKILL is M:N relationship.

One student may take many courses and one course is attended by many students.

An order can contain many products and a product can be contained in many orders.

User Avatar

Wiki User

12y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

9y ago

There are three kinds of relations that can exist between two entities. These are one to one , one to many and many to many. In many to many entities relation n(A) entity can have relation with m(B) entity.

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What is many-to-many relationship in database?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Can a relational database support one to one?

Yes. A one to one relationship is one of the types of relationships a relational database can have.Yes. A one to one relationship is one of the types of relationships a relational database can have.Yes. A one to one relationship is one of the types of relationships a relational database can have.Yes. A one to one relationship is one of the types of relationships a relational database can have.Yes. A one to one relationship is one of the types of relationships a relational database can have.Yes. A one to one relationship is one of the types of relationships a relational database can have.Yes. A one to one relationship is one of the types of relationships a relational database can have.Yes. A one to one relationship is one of the types of relationships a relational database can have.Yes. A one to one relationship is one of the types of relationships a relational database can have.Yes. A one to one relationship is one of the types of relationships a relational database can have.Yes. A one to one relationship is one of the types of relationships a relational database can have.


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

schema


What is DBMS relationship?

1.what is a Relationship in database management system?


Ternary relationship in database?

mnnk


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.


A schematic of the entire database that describes the relationships in a database is called?

entity-relationship diagram.


What is a connection within the data in a database?

relationship


Binary relationship in database?

A binary relationship is a type of relationship between the entities, which links to types of entities in it.


What are the basic components of database?

Entity Attribution Relationship


How are relationship between tables expressed in a relational database?

Tables are the basic building blocks of a relational database.


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

one-to-many relationship


What is a weak relationship in a database?

Join based on key fields