Database Design Steps and products

 

Database Design Steps and products (Memo ):

& Lt; Col width = "138" & gt; & Lt; Col width = "570" & gt;

step	product
demand analysis	data flow chart and data dictionary
conceptual structure design phase	E-R diagram
Logical Structure Design Phase	relational mode (primary key, foreign key, and generalization are determined). The external mode and mode are designed, and the view mode is external mode
physical design phase	table definition, index creation, and partition
database implementation phase	Create a database
database operation and maintenance	optimization, modification, and maintenance