Very new to data modelling and SQL etc and I am trying to get my head around normalisation & RDA. I have attached a document I am working on and I am trying to get to a third normal form, anyone out give me any pointers for my next step of the table?

Cheers up front.

9 Years
Discussion Span
Last Post by tesuji

Hello Hairymarble,

1. To all appearance almost every table seems to be already in 3NF, but

2. One cannot state anything about 2NF if no primary keys are given. So to proving 3NF is also impossible.

3. If you have to determine primary keys, you need complete set of functional dependencies. (Then you will be able to figure out primary keys by means of Amstrong axioms.)

4. Because every table lacks of primary key applying foreign keys is impossible. So nobody is able to determine the relationships (cardinalities) between your tables, as for example how is "Dependant" related to "Employee" (I assume this name for that table with PK Employee_Ref). This absence holds for almost every table (except of "Employee" and "Days worked").

You see, your tables need some improvements.

Furthermore, nobody here will agree to do filling out the table of your word document. It s your turn to start for doing this.

btw, what is RDA?


This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.