picture by lili chin via Flickr
The UML is a popular notation for modeling software. Even though the UML was mostly developed for programming, it is also relevant for databases. This article takes a critical look at using the UML for databases.
picture by Thor via Flickr
Here’s a chapter from my book Patterns of Data Modeling. This chapter presents six data modeling patterns for trees — UML data models, IE data models, SQL queries, and examples. The book has much more information about patterns including patterns for directed graphs, patterns for undirected graphs, antipatterns, and archetypes.
Here is an example of a UML (Unified Modeling Language) data model. This is from my Infinite Skills video course Learning Data Modeling. The model was created with the Enterprise Architect tool by Sparx Systems. This corresponds to the IE data model.
A use case is a piece of functionality that an app can perform. Each app has many use cases and the use cases taken collectively specify the app’s functionality. For an example, consider an app for tracking library loan records. Some use cases are: borrow books, borrow magazines, return books, return magazines, renew books, renew magazines, pay fines, get library card, and change address.