answersLogoWhite

0


Best Answer

In terms of data-mapping relationships, there are three main types:

- one-to-one mappings - bidirectional, each singular value/key maps to another value/key in another table)

- one-to-many mappings - one value or key maps to many values/foreign keys in another table

- many-to-one mappings - many values/keys map to one value/foreign key in another table

User Avatar

Wiki User

10y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How many types of relationship exist in database designing?
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.


Binary relationship in database?

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


How would you structure a database for tracking a family tree?

Identify the entities in the database Select the unique identifier/primary key Identify appropriate attributes Select the appropriate data types Create a recursive relationship Identify the cardinality of a relationship


What is the definition of table in database?

In a Relational Database or a Flat Database a table contains an organized collection of records, each of which contains several fields of data describing the item that the record represents.In other types of databases tables may or may not exist.


Relationship between CAD and CAM?

The relationship between CAD (Computer aided design) and CAM (computer aided manufacturing) is that both types of designing need to be done on a computer and operated by an engineer.


Types of databases in sql server 2005?

Types of Database in sql server 2005:- 1.Master Database 2.Tempdb Database 3.Model Database 4.MSDB Database 5.Resource Database


3 types of database in a typical organization?

network database tree database rdbms


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.


What are the types of database?

There are three database models. The three database models are as follows : 1) relational 2) network data 3) hierarchical


Define various types of database users?

There are following types of users: § Database Administrators § Security Officers § Network Administrators § Application Developers § Application Administrators § Database Users


What type of information is kept on a database?

All types of information may be kept in a database.


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.