MySQL Forums
Forum List  »  MySQL Workbench

Re: Modeling Approach and how to use
Posted by: Peter Brawley
Date: September 15, 2017 12:56PM

It's less a question of how best to use WB than of how best to design a database. That's the job of creating a structure that fully supports a "business" or other working requirement.

Non-trivial requirements entail multiple, related tables, eg customers makes orders which entail shipments, require payments, and include items which refer to products which have prices which sum to required payments, &c.

So one table at a time is usually not a good plan. Better: write the requirement in excruciating detail, then analyse it in terms of entities and actions, then write the model, then instanntiate test and revise till it works. See ...

http://www.artfulsoftware.com/dbdesignbasics.html

Options: ReplyQuote


Subject
Views
Written By
Posted
89
September 15, 2017 12:33PM
Re: Modeling Approach and how to use
66
September 15, 2017 12:56PM
33
September 15, 2017 01:37PM


Sorry, only registered users may post in this forum.

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.