Outline
              Main Phases of Database Design
              Conceptual Database Design
              Logical Database Design
                     – ER- & EER-to-Relational Mapping
              Exercises
              Reading Suggestion:
                     – [1]: Chapters 7, 12
                     – [2]: Chapters 15, 16
              Dr. Dang Tran Khanh (dtkhanh@hcmut.edu.vn), M.eng. Tran Minh Quang (quangtran@cse.hcmut.edu.vn)             2
              Main Phases of Database Design
              Three main phases
                     – Conceptual database design
                     – Logical database design
                     – Physical database design
              Detailed discussions: see [1] (chapter 12)
                     – Six phases
              Dr. Dang Tran Khanh (dtkhanh@hcmut.edu.vn), M.eng. Tran Minh Quang (quangtran@cse.hcmut.edu.vn)             3
  A simplified diagram to illustrate the main phases of 
  database design
              Main Phases of Database Design
              Conceptual database design
                     – The process of constructing a model of the data 
                         used in an enterprise, independent of all physical 
                         considerations
              Logical database design
                     – The process of constructing a model of the data 
                         used in an enterprise based on a specific data 
                         model (e.g. relational), but independent of a 
                         particular DBMS and other physical considerations
              Dr. Dang Tran Khanh (dtkhanh@hcmut.edu.vn), M.eng. Tran Minh Quang (quangtran@cse.hcmut.edu.vn)             5
              Main Phases of Database Design
              Physical database design
                     – The process of producing a description of the 
                         implementation of the database on secondary 
                         storage; it describes the base relations, file 
                         organizations, and indexes design used to 
                         achieve efficient access to the data, and any 
                         associated integrity constraints and security 
                         measures
              Dr. Dang Tran Khanh (dtkhanh@hcmut.edu.vn), M.eng. Tran Minh Quang (quangtran@cse.hcmut.edu.vn)             6