© 2023 Hashnode
#database-design
User Tables User tables are the primary repository of data in a database management system (DBMS). They are created and managed by the database administrator (DBA) or the end-users themselves and stor…
Stored procedures are a powerful tool for improving the efficiency and scalability of your database system. In this article, we'll explore what stored procedures are, how they work, and why they are a…
Seemed like a good idea at the time Let's say you are writing an application that requires a database with schema. Whether the database has an actual schema (e.g. relational) or just the set of requir…
I claim that all (user) data in a database should be mutable by default. Always. Well, almost all data. There are only four exceptions. 1. The primary key A dedicated column that serves as the unique …
Data and its usage has constituted a greater proportion of our lives and the world from a more macroscopic view. This data which is generated as a result of our activities on the web has made surfing …
JSON (JavaScript Object Notation) has grown into a very popular data interchange format that is used in modern web development due to its lightweight, human-readable format. JSON data consists of key-…
When I started learning to be a Data Analyst in November 2021, I was confused about a lot of things, most importantly, I didn’t have an idea of what simple beginner project I could do to build my portfolio. This is part one of a two or mayb…
Creating database diagrams before an actual database implementation is quite important because it reduces the time spent during implementation, it provides a blueprint for the developer to follow duri…
The definition of an entity depends on who you ask. In Law, according to source: Person or Entity means an individual, natural person, corporation, government or political subdivision or agency of a …
Introduction Different applications have different requirements, as discussed in What the heck is OLTP, OLAP?, it depends on business rules to define the workload of our database. Therefore, we need d…
