Questions tagged [6nf]

6nf stands for Sixth normal form is intended to decompose relation variables to irreducible components.

Sixth normal form is intended to decompose relation variables to irreducible components. Though this may be relatively unimportant for non-temporal relation variables, it can be important when dealing with temporal variables or other interval data. For instance, if a relation comprises a supplier's name, status, and city, we may also want to add temporal data, such as the time during which these values are, or were, valid (e.g., for historical data) but the three values may vary independently of each other and at different rates. We may, for instance, wish to trace the history of changes to Status.

10 questions
15
votes
8 answers

Composite vs Surrogate keys for Referential Integrity in 6NF

Take three layers of information: Layer 1: Information This layer contains data with UNIQUE natural indexes and a surrogate key that is easily transferrable. Table Surnames: +-----------------------------+--------------+ | ID (Auto Increment,…
smcjones
  • 5,490
  • 1
  • 23
  • 39
6
votes
2 answers

design - sixth normal form

I have the following tables: Blogs { BlogName } BlogPosts { BlogName, PostTitle } Blog posts is modeling an entity and a relationship at the same time which is invalid according to 6nf (according to the third manifesto). In 6nf, it would be: Blogs…
firebird
  • 3,461
  • 6
  • 34
  • 45
4
votes
1 answer

Where can I find information on the sixth normal form

I am looking for information on how to implement the sixth normal form. I have searched everywhere online without success. I would like to see an example how how is implemented and designed. It would especially help if there are any books or…
Luke101
  • 63,072
  • 85
  • 231
  • 359
2
votes
3 answers

Designing an EAV database correctly for historical data

Intro I have been reading about EAV database and most of the short comings seem to be related to really, really, bad EAV designs or difficulty generating reports from the data. Usually when you see people complaining about EAV they are using less…
Xeoncross
  • 55,620
  • 80
  • 262
  • 364
2
votes
1 answer

May a 6NF Table contain a foreign key?

Does a table satisfy 6NF when it's domain is a foreign key? E.g.: CREATE TABLE authors( author_id serial NOT NULL PRIMARY KEY ); -- other author attributes CREATE TABLE books( book_id serial NOT NULL PRIMARY KEY ); CREATE TABLE…
0
votes
0 answers

EF6 code first to 6NF tables

I have the following database model Entity Id, ... PropertyType Id, Name, DataType, ... EntityProperty Id, EntityId, PropertyTypeId PropertyValueString Id, Value PropertyValueDateTime ID, Value I am using EF6 code first to map my entities to…
user2321864
  • 2,207
  • 5
  • 25
  • 35
0
votes
1 answer

Can anyone suggest a method of versioning ATTRIBUTE (rather than OBJECT) data in DB

Taking MySQL as an example DB to perform this in (although I'm not restricted to Relational flavours at this stage) and Java style syntax for model / db interaction. I'd like the ability to allow versioning of individual column values (and their…
BizNuge
  • 938
  • 1
  • 8
  • 20
0
votes
1 answer

Anchor Modeling - are data types part of the Model?

A question about data types in the Anchor Model database design. The question assume separation of anchor model implementation from the anchor model itself. In the Anchor Model xml we have following kind information related to data…
0
votes
1 answer

SQL How to pivot 6NF tables

What do the SQL code look like for a simple pivoting example with a few table in sixth normal form? Alot of people talk about how its easy and fast to pivot using 6NF tables but its really hard to find a example of this. Lets say i have the…
CodeMonkey
  • 3,418
  • 4
  • 30
  • 53
0
votes
1 answer

Normalizing Time Series Data

I'm creating a database to store a lot of events. There will be a lot of them and they will each have an associated time that is precise to the second. As an example, something like this: Event ----- Timestamp ActionType (FK) Source (FK) Target…
polm23
  • 14,456
  • 7
  • 35
  • 59