StackOverflow Questions for Tag: 3nf

MBK

Reputation: 13

Problems creating table after normalisation

oracle-databasedatabase-normalization3nf

Score: 0

Answers: 1

baxx

Reputation: 4705

Normal forms - 2nd vs 3rd - is the difference just composite keys? non trivial dependency?

databasedatabase-normalizationfunctional-dependencies3nfcandidate-key

Score: 1

Answers: 1

Flip The Pip Seeds

Reputation: 71

Can you move compound keys and/or foreign keys to other tables when normalizing to 3NF (third normal form)

foreign-keysrelational-databasedatabase-normalization3nf

Score: 3

Answers: 3

Mcar49

Reputation: 327

Can you have a composite key when in Third Normal Form (3NF)?

databaseprimary-keydatabase-normalizationcomposite-key3nf

Score: 2

Answers: 1

Jamshid

Reputation: 31

Table in 3rd normal form, yet with obvious redundancies

databaserelational-databasedatabase-normalization3nf

Score: 2

Answers: 1

Feek

Reputation: 297

Circular Dependencies in 3NF

databasedatabase-designdatabase-normalizationfunctional-dependencies3nf

Score: 3

Answers: 1

Dani Cruz

Reputation: 51

Minimum normal form of a relation with all prime attributes

databaserelational-databasedatabase-normalization3nfbcnf

Score: 0

Answers: 0

vaibhav.g

Reputation: 759

Condition when BCNF and 3NF are equivalent

databasefunctional-dependencies3nfbcnf

Score: 0

Answers: 2

Java Enthusiast

Reputation: 1191

Understanding BCNF Functional Dependency

database-normalizationfunctional-dependencies3nfbcnf

Score: 2

Answers: 1

Thomas

Reputation: 1

Will MySQL allow no primary key if the table is linked with another table containing a MatchID with two Foreign Keys

mysqldatabaseprimary-keydatabase-normalization3nf

Score: -1

Answers: 1

Ephexx

Reputation: 301

Identifying functional dependencies (FDs)

sqldatabasedatabase-design3nf

Score: 0

Answers: 2

Afam

Reputation: 29

example of 2NF and 3NF normalization

database-normalization3nf

Score: 1

Answers: 1

user2363682

Reputation: 1

Database Normalization Process to 3NF CustomerRental for CustNo, PropNo, OwnerNo, etc

databasedatabase-designdatabase-normalization3nf

Score: -2

Answers: 1

Alfred Kaminski

Reputation: 33

Could someone please give me an example of a 3NF DECOMPOSITION that is not in BCNF? (I have no problem determining this for non-decompositions.)

rdbmsdatabase-normalizationfunctional-dependencies3nfbcnf

Score: 1

Answers: 2

filtertips

Reputation: 903

Data normalisation into third normal form

databasedatabase-normalizationfunctional-dependencies3nfcandidate-key

Score: 1

Answers: 0

Snedden27

Reputation: 1930

Confused about third normal form: a table having more than one candidate key

primary-keydatabase-normalizationfunctional-dependencies3nfcandidate-key

Score: 0

Answers: 2

Ralph Henry

Reputation: 124

How to normalize this table up to third normal form (3NF)?

databasedatabase-designdatabase-normalization3nf

Score: 0

Answers: 1

Paludan

Reputation: 622

What is the correct approach when decomposing dependencies

database-normalizationfunctional-dependencies3nfbcnfcanonical-form

Score: 1

Answers: 1

Marc

Reputation: 45

Definition for relation to be in 3NF using canonical cover

database-normalizationfunctional-dependencies3nfcandidate-key

Score: 0

Answers: 1

Alex

Reputation: 1

Create a new column in MySQl with the difference between 2 dates in days from other columns

mysqlsqlalter-table3nf

Score: 0

Answers: 1

PreviousPage 2Next

StackOverflow Questions for Tag: 3nf

Problems creating table after normalisation

Normal forms - 2nd vs 3rd - is the difference just composite keys? non trivial dependency?

Can you move compound keys and/or foreign keys to other tables when normalizing to 3NF (third normal form)

Can you have a composite key when in Third Normal Form (3NF)?

Table in 3rd normal form, yet with obvious redundancies

Circular Dependencies in 3NF

Minimum normal form of a relation with all prime attributes

Condition when BCNF and 3NF are equivalent

Understanding BCNF Functional Dependency

Will MySQL allow no primary key if the table is linked with another table containing a MatchID with two Foreign Keys

Identifying functional dependencies (FDs)

example of 2NF and 3NF normalization

Database Normalization Process to 3NF CustomerRental for CustNo, PropNo, OwnerNo, etc

Could someone please give me an example of a 3NF *DECOMPOSITION* that is not in BCNF? (I have no problem determining this for non-decompositions.)

Data normalisation into third normal form

Confused about third normal form: a table having more than one candidate key

How to normalize this table up to third normal form (3NF)?

What is the correct approach when decomposing dependencies

Definition for relation to be in 3NF using canonical cover

Create a new column in MySQl with the difference between 2 dates in days from other columns

Could someone please give me an example of a 3NF DECOMPOSITION that is not in BCNF? (I have no problem determining this for non-decompositions.)