MySQL Forums
Forum List  »  MySQL Workbench

Table Relationships
Posted by: Pete Watters
Date: September 28, 2017 03:30PM

Trying to understand the concept of table relationships and non-identifying and identifying relationships

2 related tables "Code Table" and "MATERIALL Table"



Code table has a primary key code-id-primary has 10 entries and there can be many code-id_primary fields in the material table

material table and the primary key is "partnumber"

is this a 1:n non-identifying relationship or is it
a 1:1 non-identifying relationship

Another example

2 Tables MATERIAL and "Prefered Vendors"

MATERIAL PRIMARY KEY is part-number

"Prefered Vendors " Primary key is PV-ID and is INT and auto incremented

each part number in MATERIAL can have 1:M records in the "Prefered Vendors" Table and there must be an associated MATERIAL Table row
for any "Prefered Vendors" to exist

This then is an 1:n Identifying relationship Correct?

Options: ReplyQuote


Subject
Views
Written By
Posted
Table Relationships
71
September 28, 2017 03:30PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.