Functionally Determined and 1NF

Thread starter WWGD
Start date May 25, 2015
Tags

database

AI Thread Summary

In the discussion, the focus is on the implications of a primary key (PK) in a relational database table (R) that is not in First Normal Form (1NF). It is concluded that if R is not in 1NF, then the PK does not functionally determine the table. Once the table is normalized to 1NF, the original PK may no longer serve as the primary key. This highlights the importance of normalization in ensuring that primary keys effectively determine the data within a table.

May 25, 2015

WWGD

Science Advisor

Homework Helper

Hi All,
Say we have a relation R ( i.e., a table in a relational DB ), which has a primary key PK, but R is not

in 1 NF. I guess we then conclude that PK _does not_ functionally-determine the table, since, after

the table is put in 1NF, PK is o longer the primary key, right? It seems obviously true, but I have

been wrong before...

Thanks.

Technology news on Phys.org

May 26, 2015

Mark44

Mentor

Insights Author

It might help to say that "1 NF" means First Normal Form.

Thread 'Learning Assembly and computer architecture for x86'

Dear Peeps I have posted a few questions about programing on this sectio of the PF forum. I want to ask you veterans how you folks learn program in assembly and about computer architecture for the x86 family. In addition to finish learning C, I am also reading the book From bits to Gates to C and Beyond. In the book, it uses the mini LC3 assembly language. I also have books on assembly programming and computer architecture. The few famous ones i have are Computer Organization and...

View full post »

Thread 'Learning data structures and algorithms in different programming languages'

I have a quick questions. I am going through a book on C programming on my own. Afterwards, I plan to go through something call data structures and algorithms on my own also in C. I also need to learn C++, Matlab and for personal interest Haskell. For the two topic of data structures and algorithms, I understand there are standard ones across all programming languages. After learning it through C, what would be the biggest issue when trying to implement the same data...

View full post »