Re: separate table or no
Posted by: Dimitris Papageorgiou
Date: February 03, 2021 02:10AM

This is something I find difficult to understand-not in theory so much...but in practice.

I read https://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch01.html#Codds_12_Rules about 3NF and that and all non-key columns are mutually independent.

In the example(customers) table you provide HOW DOES CREATING a separrate address table(plus address type) solves the above issue=the depedency problem?

I do not get it...

Options: ReplyQuote


Subject
Written By
Posted
January 22, 2021 11:29AM
January 22, 2021 11:36AM
January 22, 2021 06:50PM
January 23, 2021 01:15PM
January 25, 2021 10:50AM
January 26, 2021 11:39AM
January 28, 2021 11:59AM
January 29, 2021 11:13AM
February 02, 2021 12:33PM
Re: separate table or no
February 03, 2021 02:10AM
February 03, 2021 11:35AM


Sorry, you can't reply to this topic. It has been closed.

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.