Posts by
Redgate Data Modeler
I need to create the design for a new database which will be the data layer for an application; the application will be an online survey or polling like Survey Monkey. My challenge is that the functionality that I require is not supported by existing survey sites, so I need to build my own.... Read more
Database design is the process of producing a detailed model of a database. This model contains the necessary logical (table names, column names) and physical (column datatypes, foreign keys) choices to translate the design into a data definition language (aka SQL), which can be used to create the actual physical database (...) Read more
An online discussion forum is a site where people can hold conversations in the form of posted messages. Discussion forums allow conversations to take place when people are not on-line, and messages may be temporarily archived. Also, depending on the forum set-up, a message might need to be approved by a moderator before it... Read more
I recently realized that our database modeling library could use a few more advanced titles. So I headed over to Amazon to see what they had on offer. There are plenty of introductory books for beginners that tell you how to normalize data, and introduce you to indexes, but what about something for the... Read more
So many organizations face the common problem of storing employee schedules. No matter what institution: a company, a university or simply an individual, many entities need an application to view schedules. Therefore, I will try to come up with a database model and then, in a future article, we’ll talk about a simple application... Read more
One of the exciting moments in a programmer’s life is to leave legacy code behind and have fun with some new, fresh and cool tools. Today I have just such an opportunity – I’m creating the structure of a new project in Java. Read more
Most relational databases allow you to define comments for their tables, columns, views, and so on. These additional pieces of information are called database meta data or data dictionary. Meta data may be useful for developers or other database users. Meta data allow the development team to understand what various tables or columns are... Read more
In this article I’m going to show you how to design SQLAlchemy models using Vertabelo, an online tool for visual database design, and our code generator. Read more
In this article, I will try to compare two database modelers: Vertabelo in version 1.21.0 and Navicat Data Modeler in version 1.0.12. Read more
You are the owner of an online store, located in Poland. The majority of your customers are from Poland and they speak Polish. But you want to sell your products abroad too and your international customers mainly speak English. So you want your online store to be available in both Polish and English. You... Read more
Redgate Data Modeler