Top Answer
User Avatar
Wiki User
Answered 2008-10-01 14:46:25

This is where you have two tables and each record on one table has one and only one corresponding record on the other. To connect them, they both have a corresponding code, that is unique in each table. So you could have a database for employees. In a table in it you could have all their personal details. On another you could have their salary details. On both tables, for each individual there would be a unique code, like an employee code. When a particular employee is found on the employee table, their code is taken and checked for on the salary table to find the details for their salary. It is then not necessary to have their name in both tables, as the code can be used to link the two parts of their data together from the two tables. The code is the only thing that will be in both tables. As every code on one table has one corresponding code on the other it is a one to one relationship. There are other types of database relationships, namely one to many and many to many.

User Avatar

Your Answer


Still have questions?

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.

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

entity-relationship diagram.

What is a logical database?

A logical database is the structure of data. It is the different pieces of information and the relationships between them.

Which database tool is required for establishing relationships?


How are relationships between table expressed in a relational database?

Tables are the basic building blocks of a relational 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.

What is a Configuration Management Database?

A Configuration Management Database (CMDB) stores configuration records containing Attributes of CIs and their relationships. A CMS may include one or more CMDBs.

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 responsibility of the database designers?

As the name implies, a database designer develops both the logical and physical design of the database. For hierarchical databases, they define the parent-child relationships and in relational tables, the relations between tables. They also often develop validation rules, constraints and the like.

What is an Entity Relationship diagram for library management database?

An entity relationship diagram is a graphical documentation of a database's tables, fields, and the relationships between tables in the database. It shows all of the fields in each of the tables, and sometimes describes the data types for those fields as well as having lines between the tables that show relationships. The relationships can be one-to-many, or one-to-one relationships. A one-to-many (the most common) relationship means that one row in one of the tables will relate directly to many rows in the other table (hence the reason the data is in two tables.) One-to-one relationships are use to separate data that could be located in the same table as the other data into multiple tables.Entity relationship diagrams are helpful when querying a database as well to understand how to write the SQL to pull the data out of the database. These diagrams are useful to database designers, database administrators, computer programmers, and database users to understand the structure of the database.------------------------------------------------------------------------------------------------------------------hiii i m mehul, frnds m giving a er diagram for library management, ok..check out here, its gud.. this has all dfds, erds, class diagrams n all.. a bright carrier-------------------------------------------------------------------------------------------------------------------

What is network model in DBMS?

network model is a collection data in which records are physically linked through linked lists .A DBMS is said to be a Network DBMS if the relationships among data in the database are of type many-to-many. The relationships among many-to-many appears in the form of a network. Thus the structure of a network database is extremely complicated because of these many-to-many relationships in which one record can be used as a key of the entire database. A network database is structured in the form of a graph that is also a data structure .

What is database repository?

A repository is a collection of all data definition, data relationships and report formats, i,e; meta data of a database.

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

A one-to-many relationship in databases exists where one entity A has a relationship with one or more entities B.Examples of one-to-many relationshipsA car (one) and its parts (many)A woman (one) and her children (many)A large company (one) and its offices (many)A zoo (one) and its animals (many)In a relational database like Access, a one-to-many relationship is reflected by multiple records in table B having a reference to one record in table A. For example, five "office" records might all have a reference to one "company" record.The one-to-many relationship is a concept from relational databases in general. Access is a relational database and in Access it is therefore possible to define one-to-many relationships.Creating a one-to-many relationship in Access 2010In order to create a one-to-many relationship, select the "relationships" button under the "database tools" tab. In the Relationships screen that now opens you can select the Edit Relationships button to create relationships, or you can create relationships visually by adding tables to the screen and dragging the primary key of one table onto a field in another table.

Difference between database and relational database explain with example?

Database = Generic name for a system to store data Relational Database = A specific type of database that utilizes relationships between data to not only store the data but further its efficiency in its manipulation.

How do you find relation between tables in a database?

There are two generic types of relationships that are found between tables in existing databases, those that are explicit (or defined) and those that are implicit (or undefined.) The explicit relationships are defined differently in each database management system, so finding these relationships will depend on which type of database you're using. Typically they can be found via the user interface when designing one of the two tables in the relationship, viewing a relationship option, or by applying SQL against specific system tables. The explicit relationships usually enforce referential integrity in the database, so they are strongly encouraged over implicit relationships, but still implicit relationships will be found in the real world in existing databases. Implicit relationships are relationships where the primary key in one table can be clearly identified in another table as a foreign key, but there is no explicit relationship defined. Because the name of the foreign key matches or is similar in pattern to the the the primary key in the other table, you can imply that there should be a relationship between those tables. These relationships can be identified by foreign key names and by looking at existing SQL and queries in the database system to see what fields tables are joined on.

How do you do many to many relationships in database?

check out for step by step guide on how to do this

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.

What are the relationships that the relational database is named for?

In database theory, a relation is defined as a set of tuples that have the same attributes. A tuple is also known as a row or record.

What is fuzzy database?

fuzzy database manages the uncertainty and vagueness associated with either entities, attributes and relationships. this can be implemented in relational database model (fuzzy extension) or using object oriented databse model.

What are the steps involved in planning database files?

There are five steps to planning database files. These steps are collecting information, determining objects, modeling said objects, determining every object's information, and determining the relationships the objects have with one another.

Unary relationship in database?

Unary RelationshipsUnary relationships have only one participant-the relation is associated with itself. The classic example of a unary relationship is Employee to Manager. One's manager is, in most cases, also an employee with a manager of his or her own.

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.

Difference between database and relational database?

A relational database is a type of database, so in one sense there is no difference. There are various kinds of database. A relational database is one type. Others include network and hierarchical.

What is the difference between database administrator and database analyst?

A database administrator is the person who is responsible for keeping a database up to date and running. There responsibilities include: writing and applying scripts to update the database, keeping the database running 24/7, and backing up the database. A database analyst is a person who looks at a database from a higher level. That person would look at the database design and recommend additions for new projects and design the tables and relationships to meet needs. Then the administrator would make the changes in the database.

Which database model allows many-to-many relationships among records so that a data element can be accessed by following one of several paths?

Network structure