02 Convert ER diagram to RDB table

Decide what type of database you want to create and create the tables accordingly. Construct a table that can realize the requirements on the database based on the ER diagram. For example, clearly define what columns and keys each table has.

03 Data normalization

In addition to removing and organizing redundant data, we format the data so that operations such as adding and updating data can be performed smoothly and consistently.

04 Check performance requirements

Check the performance requirements needed to make the database fully operational, such as "How much data can be added to the database on a regular basis?" and "How many users can access it at the same time?" .

05 Create an index

Indexes allow you to quickly identify where the data you want to search is stored, making database processing faster.

06 Decide on data storage area

Secure enough data area to store the amount of data confirmed by performance requirements, and finally decide on hardware specifications and file placement on the hardware.