<BackWhat is the purpose of an ER-diagram in the development process?
4/28/2023In the article on application design, I mentioned ER diagrams. This post will be dedicated to this topic.
Almost any IT solution uses databases. Each record in the database has its own structure.
For ease of understanding of a database, imagine a table in Excel. Let one of the sheets in the table be named "Users". In databases, such sheets are called entities.
For each new user, that is, a new entity, a new row with columns is created on the sheet. Each column stores some user data, such as first name, last name, email, password, registration date. Such a string is called a database record.
Database entities can be interconnected with each other. Imagine that we have two sheets of our Excel spreadsheet - "Users" and "Blog Articles". On the latter there is a column "author", which refers to a row from the table "Users". This is a one-to-one relationship.
It is impossible to keep all these structures and relationships in mind. In addition, you need to follow certain standards in building a database. If they are not followed, then with an increase in the number of records, the performance of the database will decrease. To help in this difficult task comes the DB design tool — ER diagrams.
An ER diagram is a graphical representation of a data structure. It helps to identify the main entities and their attributes that will be used in the system, as well as to determine the relationships between them. This allows you to create a database that will be efficient and easily maintained.
In conclusion, I note that the database is one of the components of an IT solution that affects the user experience. If it is poorly designed, the user will wait longer for a response to his request, which may lead to his departure. Therefore, I recommend not to neglect the database design stage.
Lates
About graphs, simply.
12/18/2022In this article, we will begin our acquaintance with graphs, get acquainted with the breadth-first search algorithm (BFS) and implement the graph in the Rust programming language.
What is the difference between outsourcing development and outstaffing an IT employee for development?
10/17/2022In this article we will understand what outsourcing and outstaff development are.
UI/UX design: The creation process
4/9/2023In this article we will talk about the main steps in the process of creating UI/UX design.
UI/UX design: Introduction
3/29/2023In this article, we begin to get acquainted with UI / UX design. This is the most important stage in the development of any visual application interface.
Meet the Pentest
8/22/2022We are beginning to consider one of the main methods of assessing the security of computer systems and networks for potential vulnerabilities - penetration testing
Reducing the implementation period of MVP
12/8/2022Let's figure out the timing of the implementation of the MVP.
Choosing a programming language
3/17/2023In this article we will talk about choosing a programming language to study
Testing an MVP concept
1/9/2023We will figure out how not to waste the budget on MVP development in vain
Application Architecture Design: Introduction
3/6/2023In this article, we will talk about the process of creating the architecture of an IT solution.
The terms of references: Structure
2/17/2023In this publication we will consider the universal structure of ToR
Incorrect estimation of the cost of IT contractor services
9/10/2022Today we will talk about the incorrect assessment of the cost of developing IT solutions. This pain is one of the main ones for enterprises and startups, including IT contractors themselves.
Introduction to Design Patterns in Software Development
10/3/2022In this article, we will begin to dive into the world of optimizing application architecture using design patterns.
Choosing the direction of development for programming training
2/5/2023In this article, you will find out what areas of IT development there are, how they differ and in which they pay more
OSI Model Levels
9/6/2022In this article, we will take a closer look at each of the levels of the OSI model
Main types of application architecture
3/7/2023In this publication, we will look at what application architectures are
10 ways to use Rust Cargo
2/11/2023In this short article I have collected 10 ways to use the build system and package manager of the Rust programming language
Documenting code in the Rust programming language
8/24/2022In this article, we will look at how documentation takes place in Rust and consider a very useful opportunity - writing tests through documentation.
Introduction to the OSI model
8/19/2022In this article we begin to consider the fundamental model of network interaction - OSI
CSS animation ripple
8/31/2022A simple example of how to implement ripple animation using HTML and CSS
From concept to MVP
11/18/2022In this article, you will learn, by example, how to move from a concept to an MVP without unnecessary complications in the functionality of the product
What are UML diagrams used for?
5/23/2023In this article we will talk about what UML diagrams are, what they are and where they are used
Introduction to writing the terms of references
1/31/2023The Terms of Reference are an important part of the development process. In this article, we will begin to dive into this issue.
Introduction to software development
10/10/2022Today, most companies are faced with IT development and often do not get what they want. In this article, we begin to dive into the process of creating IT solutions.
From idea to concept
10/27/2022In this publication, we will talk about how the idea differs from the concept. Let's do this with an example of a specific goal
Weighted graphs
12/26/2022In this article, we will get acquainted with weighted graphs, Dijkstra's algorithm, and its implementation in the Rust programming language.
Why does a VPN business need?
9/27/2022In this article, we will look at how you can secure access to enterprise cloud resources using a VPN