Author: Emil Drkušić
Database designer and developer, financial analyst.
A Data Model for an Electric Power Production System
What is needed to produce electricity? We look at a data model that can organize the power production process.
In the electric power distribution system article, we discussed a data model for an electric power distribution system. We focused on how the electricity was provided to customers via the transmission grid and the local transmission grid. Due to space constraints, we treated the production process as a black box. Today, we’ll look inside this black box, discussing what kind of model could store details about electrical production facilities, owners, energy produced, and related costs.
A Crowdfunding Platform Data Model
Crowdfunding has become a popular way to raise money for businesses, charities, and all kinds of projects. In this article, we’ll look at a database for a crowdfunding platform.
Most of us have heard about crowdfunding. It is a relatively new fundraising concept that helps people realize their ideas. Project costs are divided between a large number of individuals, and they usually choose to back a project because it appeals to their personal interests.
Hire or Get Hired: A Data Model for the Recruitment Process
No matter which side of the equation you’re on, sometimes it’s tough to find a qualified person for a specific job. In this post, we look at a data model to help recruiters and HR departments stay organized during the hiring process.
Most of us have been involved in the hiring process – most often as the job applicant. However, we can also find ourselves involved on the hiring side, maybe by testing the applicant’s technical knowledge.
A Data Model for an Electric Power Distribution System
Have you ever wondered how electricity gets from the power station to your home or office? In this article, we’ll look at a database model that could work for an electricity distribution system.
Electricity is so widespread that we can hardly imagine life without it. The first hydroelectric power station may have been built back in 1868, but there are still plenty of innovations going on with electricity. The most attention-getting are electric cars, like Teslas or Rimacs.
A Database Model for a Renting Service
Renting goods and services is very popular today. Services like Airbnb rubbed the renting lamp and let the genie out, especially for travelers. They’ve opened up new horizons, and in the future we can expect that all kinds of rental services will become even more common. In this article, we’ll describe a database model that could be used to run an application for renting apartments, rooms, and anything else you can think of.
An Antique Store Data Model
You might run an antique store because you love history, but you’ll need modern technology to keep everything organized! In this article, we discuss what an antique store’s database model would need.
Antiques are cool. I bet we all love history and antiques in some way. Some admire Victorian furniture, others are thrilled about old coins, vintage weapons, or medieval armor. Still others enjoy reading or just looking at old books or manuscripts.
An Event Management Data Model
Organizing an event is a lot of work! In this article, we examine the data model behind an event organization app.
If you’ve ever tried to organize an event for more than ten people (and don’t count parties or business meetings here) you know how complicated event management can be! Have we invited everyone? Have they confirmed if they are coming? Is the venue booked and prepared? Who will host the event?
A Real Estate Agency Data Model
Other than location, what’s it take to run a successful real estate business? We examine a data model to help real estate agencies stay organized.
Buying, selling, and renting apartments or houses is really big business today. Most people are happy to pay a fee and let a professional real estate agency do the work for them. On the other hand, the company could act in its own behalf, buying properties to resell or rent.
A Process Management Data Model
What kind of data model can handle all the planning and activities used in process management? In this article, we discuss one design for a process management database.
Process management is a fairly straightforward and common concept. At its core, process management is simply deciding what needs to be accomplished – building a car or creating an app, for example – and then figuring out how to do it. Of course, the actual process itself is more complicated!
A Transport Hub Database Model
Bus and train travel hubs are full of activity: the crowd, the rush, the lines, the race to the platform or terminal. Clearly, such places require a lot of organization! In this article, we’ll describe a database model that could keep a transport hub organized.
And that’s not easy. There are many parameters to account for: lines, stations, passengers, tickets, compositions (i.e. buses or trains), and the number of available seats on any given trip.