How to Design Database: Steps of Designing Database
Database designing generally starts with identifying the purpose of your database. The relevant data is then collected and organized into tables. Then, specify the primary keys and analyze relationships between different tables for an efficient data design. After refining the tables, the last step is to apply normalization rules for table standardization.
- Define the objective of your database
- Locate and consolidate the necessary data
- Distribute the data into tables
- Change data items into columns
- Identify primary keys
- Determine how tables are related
- Enhance your database design
- Implement the normalization rules
ref- https://www.astera.com/type/blog/all-you-need-to-know-about-database-design/#:~:text=Database%20design%20is%20defined%20as,for%20the%20proposed%20database%20system.
Leave a Reply