Solved

Relationships in MySQL Workbench

Posted on 2016-09-09
4
46 Views
Last Modified: 2016-09-11
Can you describe the following relationships and when they are used?

1:1 Non-identifying relationship
1:n Non-identifying relationship
1:1 Identifying relationship
0
Comment
Question by:burnedfaceless
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 50

Expert Comment

by:Steve Bink
ID: 41792720
I sure can, but you should probably refer to your textbook and lessons for these things.
0
 
LVL 78

Expert Comment

by:arnold
ID: 41793051
what is unclear? Provide your thoughts aon the matter, and we could guide/help correct if there are issues.
0
 

Author Comment

by:burnedfaceless
ID: 41793394
I outlined the section on relationships and I understand One to One, One to Many, and Many to Many.

Does the n stand for many?

Also what does identifying or non-identifying relationship mean?
0
 
LVL 78

Accepted Solution

by:
arnold earned 500 total points
ID: 41793405
Yes, n represents many.
Identity deals with the relationship using an identity reference. I.e. A parent table is required.


A search for "identifying vs non-identifying relationship" it provides examples to clarify the explanation.....
0

Featured Post

Business Impact of IT Communications

What are the business impacts of how well businesses communicate during an IT incident? Targeting, speed, and transparency all matter. Find out more in this infographic.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
paypal ipn to mysql 3 104
unable to insert record into a table 2 55
mysql date time 14 50
EditableGrid how to fetch rows from MySql in php 14 68
Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question