1 / 16

Database Development

Database Development. Indra Budi indra@cs.ui.ac.id. What is differences ?. Logical Data Independence Vs Physical data independence ?. Conceptual Schema. Describes the Meaning of Data in the Universe of Discourse

laasya
Download Presentation

Database Development

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Database Development Indra Budi indra@cs.ui.ac.id

  2. What is differences ? • Logical Data Independence Vs Physical data independence ?

  3. Conceptual Schema • Describes the Meaning of Data in the Universe of Discourse • Emphasizes on General, Conceptually Relevant, and Often Time Invariant Structural Aspects of the Universe of Discourse • Excludes the Physical Organization and Access Aspects of the Data

  4. Conceptual Schema • Another Example

  5. External Schema • Describes Parts of the Information in the Conceptual Schema in a form Convenient to a Particular User Group’s View • Derived from the Conceptual Schema

  6. External Schema • Another Example

  7. Internal Schema • Describes How the Information Described in the Conceptual Schema is Physically Represented in a Database to Provide the Overall Best Performance

  8. Internal Schema • Another Example

  9. Unified Example of Three Schemas

  10. Building a Database System • Essentially the same as the process for building any other information system, consists of three basic phases: • Requirements phase: a data model is developed • Design phase: the data model is transformed into tables and relationships • Implementation phase: create tables into the DBMS

  11. Requirement Phase • Data model is developed • A data model is a logical representation of the structure of the database • Its very important because design & implementation depend on this phase • If the data model inaccurate, then the result will be waste, aggravation, delays and useless

  12. Example: Data Model • Rectangular are entity & diamonds are relationships • We will discuss this model in detail later…

  13. The Design Phase • The data model transform into tables & relationships • Data properties established  type, length, null/not null. • Need for index determined • Constraint, trigger, stored procedure are defined • Figure 1-19 Kroenke

  14. The Implementation Phase • Tables & relationships created • Via SQL • Via Graphical design tool • Stored procedure & trigger are written & tested • Figure 1-20 Kroenke

  15. Application Development • Application development proceeds in parallel with database development

  16. Suggested structure of Report 1 • Introduction • Brief overview of DBMS (name, vendor, version, price (if any), primary user, history of the DBMS, etc) • Description of DBMS features you want to compare and why they are important. • Table comparation • Analysis • Conclusion

More Related