MySQL Forums
Forum List  »  MySQL Workbench

Re: ER diagram design
Posted by: Peter Brawley
Date: June 04, 2022 10:37AM

I know in this age of video fetishism, this will sound like heresy, but the ER diagram is not the starting point of database design.

Such diagrams are lossy representations of complete db designs.

First, work out the required tables and columns &c on paper or in a text editor, following a systematic method like that described at https://www.artfulsoftware.com/dbdesignbasics.html.

When you're as far as step 4 in that sequence, you might start on the ER diagram. Or, you can wait till you get to the end, your choice.



Edited 1 time(s). Last edit at 06/06/2022 09:00AM by Peter Brawley.

Options: ReplyQuote


Subject
Views
Written By
Posted
495
J F
June 03, 2022 01:27PM
Re: ER diagram design
357
June 04, 2022 10:37AM
321
June 06, 2022 07:12AM


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.