<BackWhat is the purpose of an ER-diagram in the development process?4/28/2023
In 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.
Composition of the IT development team7/6/2023
In this article we will look at the composition of the IT solution development team
About graphs, simply.12/18/2022
In 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/2022
In this article we will understand what outsourcing and outstaff development are.
UI/UX design: The creation process4/9/2023
In this article we will talk about the main steps in the process of creating UI/UX design.
UI/UX design: Introduction3/29/2023
In 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.
Agile, Six Sigma and No Principle9/14/2023
In the last article, we started diving into the development process. The first stage of this process is planning. At this stage, the project manager, together with other team members, forms a pool of tasks in accordance with some kind of project management methodology.
Meet the Pentest8/22/2022
We 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 MVP12/8/2022
Let's figure out the timing of the implementation of the MVP.
Choosing a programming language3/17/2023
In this article we will talk about choosing a programming language to study
Testing an MVP concept1/9/2023
We will figure out how not to waste the budget on MVP development in vain
Application Architecture Design: Introduction3/6/2023
In this article, we will talk about the process of creating the architecture of an IT solution.
The terms of references: Structure2/17/2023
In this publication we will consider the universal structure of ToR
Incorrect estimation of the cost of IT contractor services9/10/2022
Today 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 Development10/3/2022
In this article, we will begin to dive into the world of optimizing application architecture using design patterns.
Choosing the direction of development for programming training2/5/2023
In this article, you will find out what areas of IT development there are, how they differ and in which they pay more
OSI Model Levels9/6/2022
In this article, we will take a closer look at each of the levels of the OSI model
Main types of application architecture3/7/2023
In this publication, we will look at what application architectures are
10 ways to use Rust Cargo2/11/2023
In 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 language8/24/2022
In 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 model8/19/2022
In this article we begin to consider the fundamental model of network interaction - OSI
CSS animation ripple8/31/2022
A simple example of how to implement ripple animation using HTML and CSS
From concept to MVP11/18/2022
In 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/2023
In this article we will talk about what UML diagrams are, what they are and where they are used
Introduction to writing the terms of references1/31/2023
The 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 development10/10/2022
Today, 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 concept10/27/2022
In this publication, we will talk about how the idea differs from the concept. Let's do this with an example of a specific goal
IT project management methodologies: Waterfall, Scrum, Prince211/27/2023
In this article, we will consider the basic methodologies of IT project management.
In this article, we will get acquainted with weighted graphs, Dijkstra's algorithm, and its implementation in the Rust programming language.
Development Process: Planning8/16/2023
In this publication, we will begin to consider the development process. Let's start with the planning process.