A healthcare database application design process usually includes four stages (Figure 34-2):
Figure 34-2 A generic database application design process
• Stage 1 Analyze the business scenario and extract business rules.
• Stage 2 Design an entity relationship diagram (ERD) based on the business rules extracted from stage 1.
• Stage 3 Select a database model (e.g., Oracle DB) and create a physical database (tables, views, functions, etc).
• Stage 4 Choose a development tool (e.g., Oracle APEX) to implement the application.
Business rules describe ...