Hello folks, it's been a while; I hope you are doing great and safe.
Today's top is essential in software development, which is database design. In software development, we need to store data for future use in data analysis and decision making. For keeping and retrieving our data, we should prepare where we will keep it conveniently.
When it comes to database design, it means data security in a database and easy access, removing data redundancy or repeating of the data, because it can increase the cost for data, as a developer should minimize the cost but increase the efficiency of the database's application.
In database design consists of many things. According to its definition, it is a collection of steps that help create, implement, and maintain data in a database's system. The main goal of database design is to produce physical and logical models of structures of a database system.
ERD stands for Entity Relationship Diagram. ERD is a diagram that displays the relationship of entity sets stored in a database; ERD will help us determine a good database design by showing the entity, relationship, and attributes within a particular database.
An entity in a database is a thing, person, place, unit, object or any item about which the data should be captured and stored in the form of properties, workflow and tables.
A relationship is it shows how the tables will share the data between them. It shows which table has a foreign key from another table and which cardinality, like many-to-many, many-to-one, and one-to-one.
In ERD, we determine which are strong and weak entities according to their relationship associated in a database; a strong entity is the one whose existence does not depend on any other entity in a schema. While a weak entity is an entity that cannot be identified uniquely by its attributes alone; therefore, it must use a foreign key in conjunction with its attributes to create a primary key.
As we have seen above, before diving into coding, first spend your time designing a database to save future database useability.
Thank you, #AwesomityLab, #taskForce, and #CodeOfAfrica, for helping me to know this excellent concept you provided to me.
Thank you folks for reading; let's wait next week for what will come with us.
Top comments (0)