answersLogoWhite

0

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

Wiki User

17y ago

What else can I help you with?

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 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 logical database?

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


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..http://www.kdd.uncc.edu/Cynthia/3160Proj/Report_Final.pdfand this has all dfds, erds, class diagrams n all..http://www.docstoc.com/docs/9375857/library-mangment-system-anlysis-anddesginhave a bright carrier-------------------------------------------------------------------------------------------------------------------


Which database tool is required for establishing relationships?

tables


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 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.


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 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 .


Which one of the following diagrams is the most helpful in designing a relational database in which to store object data?

The Entity-Relationship diagram is the most helpful in designing a relational database to store object data. It visually represents entities, their attributes, and the relationships between them, providing a clear understanding of the database structure and enabling effective planning of tables and relationships.


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.

Trending Questions
What are the names of Lisa Belgiovine Valastros siblings? Why he doesn't look at me? What does it mean when a guy pauses his game for a girl? Ok im 14 and you get really nervous around this girl and I do not knowwhy you dont ussualy you think its because she is so hot lol please help you? What does it mean when your spouse says you don't give him time to miss you? What to get your husband for your 9 year anniversary.? Why is it not OK to expose the very people that use abuse and control their victim until the victim sees what is happening and realizes shes been scammed by narcissistic ego maniac on the prowl again? What day of the week that you are born will you least likely fall in love? All my friends have girlfriends but I don't What does that mean for my future? How big should the age gap between boyfriend and a girlfriend be? What Simon likes and dislikes? What is sharing in a relationship? When will I get to see my Beautiful Girlfriend Athena Jacinto I miss her sooo sooo SOO Much? What does Que toma la familia mean? What if the guy is twentyfour and the girl is seventeen well he go to jail for just dating in Alabama? How can you make a man that you're in love with go crazy for you? If you know a guy wants to be more than friends why won't he ask you out? How can you ask for an apology from your dearest friend when they are repeatedly saying things to you that they should apologize for? What should I when I am in love with a younger man but he can't help you achieve your dreams and an older rich man wants to marry you? Why are harmonious relationship is important in nature?