Functionally Determined and 1NF

  • Thread starter WWGD
  • Start date
  • Tags
    database
In summary, "Functionally Determined" in the context of 1NF means that every attribute in a relation is functionally dependent on the primary key. This concept also applies to other normal forms, but with additional conditions. It is important for a relation to be "Functionally Determined" in 1NF to maintain data integrity and efficiency. A relation cannot be in 1NF without being "Functionally Determined" and this can be ensured by carefully designing the database schema and establishing proper relationships between entities.
  • #1
WWGD
Science Advisor
Gold Member
7,204
10,888
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
  • #2
It might help to say that "1 NF" means First Normal Form.
 

Related to Functionally Determined and 1NF

1. What does "Functionally Determined" mean in the context of 1NF?

In 1NF (First Normal Form), "Functionally Determined" means that every attribute in a relation is functionally dependent on the primary key. This means that the value of each attribute can be uniquely determined by the primary key.

2. How does "Functionally Determined" differ from other normal forms?

In other normal forms, such as 2NF and 3NF, the concept of "Functionally Determined" still applies, but additional conditions are also required. For example, in 2NF, every non-prime attribute must be functionally dependent on the entire primary key, not just a part of it.

3. Why is it important for a relation to be "Functionally Determined" in 1NF?

In 1NF, it is important for a relation to be "Functionally Determined" because it ensures data integrity and avoids data redundancy. It also allows for efficient querying and manipulation of the data.

4. Can a relation be in 1NF without being "Functionally Determined"?

No, in order for a relation to be in 1NF, it must also be "Functionally Determined". This is a fundamental requirement of 1NF and cannot be compromised.

5. How can we ensure that a relation is "Functionally Determined" in 1NF?

To ensure that a relation is "Functionally Determined" in 1NF, we must carefully design the database schema and establish proper relationships between entities. This involves identifying and defining the primary key and ensuring that every attribute is functionally dependent on it.

Similar threads

Many to Many Relations in Database
    • Programming and Computer Science
Replies
6
Views
1K
JS Variable Hygiene: Preventing Global Var Access
    • Programming and Computer Science
Replies
13
Views
2K
Non Computable Functions And Godel's Theorem
    • Programming and Computer Science
Replies
32
Views
3K
Functional Dependence (In Table/General)
    • Computing and Technology
Replies
3
Views
2K
Notion of Equivalent Relational Databases (RDBs)?
    • Computing and Technology
Replies
2
Views
2K
ChatGPT Results: Testing Special Relativity
    • General Discussion
Replies
5
Views
1K
B Functions which relate to calculus: Questions about Notation
    • Calculus
2
Replies
36
Views
4K
A Ballentine on the "multicomponent state function"
    • Quantum Physics
Replies
1
Views
1K
I Empirical temperature scales using different thermometers
    • Classical Physics
Replies
7
Views
1K
The primary key of a relationship set in an E-R data model
    • Programming and Computer Science
Replies
2
Views
7K

Hot Threads

Recent Insights

Back
Top