To what extent does MySQL meet Cood's Rules?
by 
Charalambos Mattheou
ANSWERS: 2
-
Cood's Rules are fairly outdated now since most databases are not purely relational anymore, and most of them such as Oracle and SQL server have internal or direct calls that are not pure SQL.
-
Boyce-Codd Normal Form (BCNF) is a technique used for normalizing a database structure. MySQL provides all the tools necessary to structure your data to follow these rules. I have to disagree with slevin01 - 3rd normal form is how most good database designs start. However, it does run into issues with scalability and performance that cause it to become less usable over time. For instance, storing an aggregate value (such as the rating of an answer) instead of calculating it every time is a good example. There are always drawbacks and advantages to this approach, such as the answer aggregate rating can be incorrect, whereas in the BCNF form it will always be accurate, as long as the query is written correctly. Ultimately you'll have to pick a design that works for you. Experience will show you what techniques work and which ones will not. The example I gave above is one that we must apply on answerbag in order to deliver our pages as quickly as possible. for more info, the wikipedia entry: http://en.wikipedia.org/wiki/Boyce-Codd_normal_form
RELATED QUESTIONS
Copyright 2023, Wired Ivy, LLC