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
540
September 15, 2017 12:33PM
Re: Modeling Approach and how to use
395
September 15, 2017 12:56PM
265
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.