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 ...

Options: ReplyQuote

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

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.