Modeling relational databases

Question

Post reply

Modeling relational databases

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply

Arsh SSCertifiable Points: 6354 More actions · Answer 1

Always best to have an ERD first , before proceeding to the physical design at relational level.

You can try 'Open ModelSphere' , has a free version I suppose .

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 2

To be honest, I usually tell auditors "NO" when it comes to producing a full system ERD. They usually don't have the need to know and it is a proprietary system. I tell them to ask specific questions and then we'll be happy to give the table layout for that particular question including the first level of tables that any FKs may reveal. They do not need to know the design of the entire database unless they auditing under a court order and search warrant looking for criminal activity or criminal neglect.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

ajaydeep SSC Rookie Points: 25 More actions · Answer 3

halil.lacevic - Saturday, August 26, 2017 3:27 AM
In software engineering, data modeling is the process of creating a data model for an information system. This is done by applying formal data modeling techniques.
There are many tools which can help you with modeling. Some of them are free, some of them aren't. I will list you few of them which I've found most useful.
SQLDbm
SQLDBM offers you an easy, convenient way to design your database absolutely anywhere on any browser, working away without need for any extra database engine or database modelling tools or apps. Use SQLDBM to design and manage both large and small databases and data models on the fly. All while incorporating any needed database rules and objects such as database keys, schemas, indexes, column constraints and relationships.
Price: Free
PowerDesigner
PowerDesigner is arguably the industryâ€™s leading data modelling tool. Its features include: fully integrated models, different modelling techniques that cater to both an IT-centric audience and non IT-centric. It also supports a powerful metadata repository and various output formats. It has a nice and polished user interface with easily readable help documentation aiding the user to quickly solve ad hoc problems.
Price: $2,000
ER/Studio
ER/Studio is an intuitive data modelling tool that supports single and multi-platform environments, with native integration for big data platforms such as â€“ MongoDB and Hadoop Hive. It can forward and reverse engineer models, includes a compare and merge function and is able to create reports in various formats (XML, PNG, JPEG). Built-in features automate routine tasks and supports the popular database platforms. ER/Studio is a great tool that that is easy to start working with due to its intuitive design and good user support.
Price: $1,500 up to $7,500
It truly depends on you. To design, or redesign, a database of any complexity, the Entity-Relationship modelling tool becomes essential. The specialized tools that have dominated the industry for a long while are expensive and are installed on a workstation.

Thank you Halil, for sharing Data Modeling tools, I tried SqlDBM and really liked it....

Trevor Jobling Grasshopper Points: 14 More actions · Answer 4

I can recommend another free modelling tool: QuickDatabaseDiagrams.com https://www.quickdatabasediagrams.com/
It lets you create database diagrams really quickly just by typing, rather than doing lots of clicking with the mouse. Suitable for very rapid prototyping and diagramming. It also generates SQL. [disclaimer: my company made it!]