Question : I have a catalog of album and song names. The song has a foreign key to the album […]
Tag: normalization
Is sql_variant compatible with First Normal Form (1NF)?
Question : 1NF rule says that we should not keep data of different types in one single column. Does it […]
Normalizing data with multiple products to a single ID?
Question : How can I normalize this data to remove the redundant tuples in the salesorderline database? I already normalized […]
Need help about normalizing database to 3NF
Question : I am currently working on a city travel guide application which let users explore places and plan trip. […]
Normalization Excercise Clarification
Question : Have a bit of confusion regarding a normalization from 1NF to BCNF. The teacher gave us this excercise […]
How to normalize a table that contains a CK not included in the PK?
Question : I have the following table. The PK is model_ID. Assuming that the modelName field is unique(that is, no […]
Best practices for history/temporal tables?
Question : Suppose I have an object, with certain fields which I want to track history, and certain fields which […]
Storing the correct answer to check against
Question : I’m designing a database for a polling app. Users get to answer a bunch of questions and we […]
Does a computed column break 3NF (third normal form)?
Question : From my understanding of 3NF, there should not be any transitive dependency. However, this is what I found […]
Writing to a DKNF database, but reading from a de-normalized table for performance?
Question : Would the following approach be reasonable? The Goal: queries have to be relatively fast, but without the hassles […]