I. Database design software development: Requirements Analysis Summary Design detailed design code writing test on- line deployment er diagram: picture er diagram: Visio Edraw II, the first paradigm of the three paradigms: ensuring the atomicity of each column the second paradigm of the smallest data unit in which each column is non-divided : requires that each table only describes one thing third paradigm if a relationship satisfies 2NF, and no columns other than the primary key are passed dependent on the primary key column, then the third normal form (3NF) is satisfied. JDBC Java Connection Database technology DriverManager: Managing the JDBC driver depending on the database Connection: Responsible for connecting to the database and serving the task of transmitting data Statement: Generated by Connection, responsible for executing the SQL statement ResultSet: Responsible for saving the query results resulting from the Statement execution procedure of the JDBC operations database
6.7-Database design, three main paradigms