jagomart
digital resources
picture1_Spreadsheet Exercises 42361 | E R Mapping


 150x       Filetype PPT       File size 2.24 MB       Source: arwan.lecture.ub.ac.id


File: Spreadsheet Exercises 42361 | E R Mapping
outline main phases of database design conceptual database design logical database design er eer to relational mapping exercises reading suggestion chapters 7 12 chapters 15 16 dr dang tran khanh ...

icon picture PPT Filetype Power Point PPT | Posted on 16 Aug 2022 | 3 years ago
Partial capture of text on file.
              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
The words contained in this file might help you see if this file matches what you are looking for:

...Outline main phases of database design conceptual logical er eer to relational mapping exercises reading suggestion chapters dr dang tran khanh dtkhanh hcmut edu vn m eng minh quang quangtran cse three physical detailed discussions see chapter six a simplified diagram illustrate the process constructing model data used in an enterprise independent all considerations based on specific e g but particular dbms and other producing description implementation secondary storage it describes base relations file organizations indexes achieve efficient access any associated integrity constraints security measures...

no reviews yet
Please Login to review.