What are the processes of database design?

What are the five steps in designing a database?

5 Helpful Database Design Steps1Determine the purpose of the database. The very first thing you must do is decide the purpose of your database. ... 2Find and organize the information. ... 3Create tables for the information. ... 4Establish relationships between the tables. ... 5Redefine your design.

What is the need of database design and how will you process it?

Database design is the organization of data according to a database model. The designer determines what data must be stored and how the data elements interrelate. With this information, they can begin to fit the data to the database model. Database management system manages the data accordingly.