Dalkeith (1/7/2014)

---

Absolutely all Developers should have a clear understanding of primary and foreign keys and the idea of relationships between tables and how the differences between different query types. ( I used to take this as given )

DBAs would benefit from a solid understanding of how FKIDs work in things like Combi Boxes and how subtle changes in UI design can massively improve the usability of their databases and how often users need multiple views of the same information. Also how important it is to the user of response design.

We've recently bought a system and when you edit a record it performs a delete and create ON the SQL record wiping the PKID on the header record. A complete pain in the A*** this is designed in through lack of forethougth by the developer. Technically its not an error its just the wrong design. They just assumed we were never going to try and relate that record to another table.