Distinction should be based on understanding that conversion from the conceptual to the physical requires translating a design blueprint (conceptual) into a practical, usable database structure (physical). This process includes:
- Conceptual design:
- Strategize and analyze—develop a plan by consulting with database users and stakeholders or management and identifying using requirements.
- Design—create a data model using tools like Oracle SQL Developer or Lucidchart.
- Physical implementation:
- Build and document—build the database through writing the program (the physical) and demonstrating with modeling software. Make any necessary adjustments to the design for technology considerations, physical surroundings, or other processes that influence the implementation of the database.
- Produce—once the program runs smoothly, go into full production and complete the conversion of the old to the new.