Real world examples of relational database types
Not what you're looking for?
Would you help me to find examples in every day life of a one-to-one relationship, a one-to-many relationship and a many-to-many relationship?
Purchase this Solution
Solution Summary
The expert provides examples in every day life of a one-to-one relationship and a many-to-many relationship.
Solution Preview
One-to-One Relationship
An example of one-to-one relationship can be a corporate database that contains information on employees in one table (Entity: EMPLOYEE) and another table, entity: SSN. They keep the SSNs separately because of security policies and issues.
As I have previously mentioned, there are two possible entities, EMPLOYEE and SSN. In this case, one employee can only have one social security number, and only one social security number can correspond to one employee. Thus, one-to-one relationship means that a row in the EMPLOYEE table is matched to a single row in the SSN table, and a row in the SSN table is matched to only one row in the EMPLOYEE table.
One-to-Many Relationship
An example of one-to-many relationship can be the design of a database ...
Purchase this Solution
Free BrainMass Quizzes
Basic Networking Questions
This quiz consists of some basic networking questions.
Basic Computer Terms
We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.
C++ Operators
This quiz tests a student's knowledge about C++ operators.
Javscript Basics
Quiz on basics of javascript programming language.
Word 2010: Table of Contents
Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.