Phase 3: Choice of a DBMS
•Costs to consider
•Software acquisition cost
•Maintenance cost
•Hardware acquisition cost
•Database creation and conversion cost
•Personnel cost
•Training cost
•Operating cost
Phase 4: Data Model Mapping (Logical Database Design)
•Convert the conceptual database design in to a database schema.
•In data model of selected DBMS.
•Stages
–System-independent mapping
Phase 4: Data Model Mapping (Logical Database Design)
Phase 5: Physical Database Design
•Choose specific file storage structures and access paths for the database files.
•Achieve good performance.
•Typically responsibility of the DBA
•Compose DDL
•Load database
•Convert data from earlier systems
•Database programs implemented by application programmers
•Most systems include monitoring utility to collect performance statistics
Phase 6: Database System Implementation and Tuning