CODEWITHSUNDEEP
sqlterminology
chris
chris

Reputation:

Need help with Database Terminology

If you have data in one table that should be in another table, what is their relationship called?

Upvotes: 2

Views: 256

Answers (3)

breitak67
breitak67

Reputation: 237

I think the OP may have worded his question ambiguously and is really trying to ask, "What do you call the relationship in which an entry in one table references a row in another table?" That is a foreign key constraint.

Upvotes: 5

George Stocker
George Stocker

Reputation: 57907

The relationship is called Healthy, yet dysfunctional.

If you want to know the 'term' for it:

De-Normalized.

I say it's 'healthy' because there are times that developers want performance over sanity. But just like any relationship, try not to make it the norm.

Edit: Yes, I stuck a double entendre about relationships in there. It's Friday, I'm feeling frisky.

Upvotes: 9

SQLMenace
SQLMenace

Reputation: 135161

Unnormalized Junk?

Unnormalized is a database that has never been normalized

Denormalized is a database that has been normalized at one time but someone has decided to shuffle some data around for a reason (could be performance)

Upvotes: 1

Related Questions