Get exceptionally good at modelling database schemas by modelling one real-world requirement a week.
Get practical exercises from our experts who have modelled databases and did software architecture for top companies and projects.
Those exercises range from defining a database schema of World of Warcraft's DKP system up to modelling a part of Twitch's database.
Create the database model based upon the requirement once a week before you get the solutions in the next morning.
Verify your database schema model and get better at database modelling.
2020-11-07| YouTube explanation (German) | IHK final exam Winter 2003/2004, GH1 Exercise 2
A telephone provider wants to persist all of their customer data inside a database. After talking with the telephone provider's CEO you receive the following information:
The company provides different rates, like "Mobile Data only" or "Phone flatrate". Each of the company's customer can have any number of phones. Each of those phones has exactly one rate assigned. For the billing, a customer must provide his banking details. There can be only one bank account per customer. A bank account belongs to a bank. Each customer's call is tracked, so the customer can receive a mobile itemization report. Every call has unique call id.
Your task is to create a database model with all primary and foreign keys. Additional attributes (like firstname of customer) are not relevant.
With a premium subscription you can check your solutions against our schema blueprints. You can choose between a one-time payment or a monthly or yearly subscription.
Our solutions contain an ER diagram and an annotated database schema with possible pitfalls and our design decisions explained.
You can find sample solutions in our blog.
All database modelling exercises are built for ongoing software developers, like trainees or students. In Germany, those exercises are a central part of the final exams for the Fachinformatiker (software development) training.
If you have just started with software development, you'll be probably overwhelmed. The exercises are not about learning SQL but learning how to model database schemas for a variety of requirements. For PostgreSQL-related SQL exercises you should visit https://pgexercises.com/.
Our target audiences are trainees and students who don't have time to learn database schema modelling each day. All of the exercises allow you to extend them with your own ideas and requirements.
The original idea for this service comes from TechLead's dailycodingproblem.com. He has implemented a daily newsletter for interview questions. As you can see, I've been inspired by his product to realize this service.