Re: Question about a specific Entity Model
Posted by: Peter Brawley
Date: December 23, 2017 01:34PM

We have an intro discussion of normal forms and when to use them in http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch01.pdf, and a design methoid outline at http://www.artfulsoftware.com/dbdesignbasics.html, There's a nice intro wiki at https://en.wikiversity.org/wiki/Designing_a_Relational_Database.

Ultimately you'll need to (i) assimilate the basics, (ii) walk the basic method of designing a db and debug it by writing all its queries (iii) write debug implement and then live with some real models and the DBs you made from them. There's a useful trove of models at http://www.databaseanswers.org/data_models/; take one that's relevant to something you know, apply it to a requirement at hand, populate it with sample data and write all the queries that can be anticipated.

IMO 3NF is needed for most nontrivial RD problems; deeper normalisation is required when analysis can predict or you've already been bitten by specific normalisation failures.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.