151x Filetype PPT File size 2.24 MB Source: arwan.lecture.ub.ac.id
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
no reviews yet
Please Login to review.