1 / 24

Database Design

Database Design. Hacettepe University Department of Information Management DOK 322 : Database Management Systems. File Management Systems vs. DBMSs Advantages and Disadvatages of DBMS Components of DBMS MS Access 2000 (Lab). Last Time. Minimal Data Redundancy Consistency of Data

varvara
Download Presentation

Database Design

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 Design Hacettepe University Department of Information Management DOK 322: Database Management Systems

  2. File Management Systems vs. DBMSs Advantages and Disadvatages of DBMS Components of DBMS MS Access 2000 (Lab) Last Time

  3. Minimal Data Redundancy Consistency of Data Integration of Data Sharing of Data Ease of Application Development Uniform Security, Privacy, and Integrity Controls Data Accessibility and Responsiveness Data Independence Reduced Program Maintenance DBMS Benefits

  4. CASE Tools User Interface Application Programs Repository DBMS Database Database Environment

  5. Database Components DBMS =============== Design tools Table Creation Form Creation Query Creation Report Creation Procedural language compiler (4GL) ============= Run time Form processor Query processor Report Writer Language Run time Database Application Programs Database contains: User’s Data Metadata Indexes Application Metadata User Interface Applications Kroenke, Database Processing

  6. Database: A self-describing collection of integrated records (Kroenke). A collection of similar records with relationships between the records. (Rowley) A collection of stored operational data used by the application systems of some particular enterprise. (C.J. Date) Terms and Concepts

  7. Enterprise Organization Entity Person, Place, Thing, Event, Concept... Attributes Data elements (facts) about some entity Also sometimes called fields or items or domains Data values instances of a particular attribute for a particular entity Terms and Concepts

  8. Key an attribute or set of attributes used to identify or locate records in a file Primary Key an attribute or set of attributes that uniquely identifies each record in a file Terms and Concepts

  9. Models (1) Levels or views of the Database Conceptual, logical, physical (2) DBMS types Relational, Hierarchic, Network, Object-Oriented, Object-Relational Terms and Concepts

  10. Application 1 Application 2 Application 3 Application 4 External Model External Model External Model External Model Application 1 Conceptual requirements Application 2 Conceptual requirements Conceptual Model Logical Model Internal Model Application 3 Conceptual requirements Application 4 Conceptual requirements Models (1)

  11. Database System Life Cycle Physical Creation 2 Conversion 3 Design 1 Growth, Change, & Maintenance 6 Integration 4 Operations 5

  12. Another View of the Life Cycle Integration 4 Operations 5 Design 1 Physical Creation 2 Conversion 3 Growth, Change 6

  13. Models(2): DBMS types Hierarchical Network Relational Object-Oriented Database Models

  14. Hierarchical Model Similar to data structures in programming languages. Books (id, title) Authors (first, last) Publisher Subjects Database Data Models

  15. Network Model Provides for single entries of data and navigational “links” through chains of data. Authors Subjects Books Publishers Database Data Models

  16. Relational Model Provides a conceptually simple model for data as relations (typically considered “tables”) with all data visible. Database Data Models

  17. Object Oriented Data Model Encapsulates data and operations as “Objects” Books (id, title) Authors (first, last) Publisher Subjects Database Data Models

  18. Database Design Process Application 1 Application 2 Application 3 Application 4 External Model External Model External Model External Model Application 1 Conceptual requirements Application 2 Conceptual requirements Conceptual Model Logical Model Internal Model Application 3 Conceptual requirements Application 4 Conceptual requirements

  19. Conceptual Requirements Systems Analysis Process Examine all of the information sources used in existing applications Identify the characteristics of each data element numeric text date/time etc. Examine the tasks carried out using the information Examine results or reports created using the information Database Design Process

  20. Conceptual Model Merge the collective needs of all applications Determine what Entities are being used Some object about which information is to maintained What are the Attributes of those entities? Properties or characteristics of the entity What attributes uniquely identify the entity What are the Relationshipsbetween entities How the entities interact with each other? Database Design Process

  21. Logical Model How is each entity and relationship represented in the Data Model of the DBMS Hierarchic? Network? Relational? Object-Oriented? Database Design Process

  22. Internal Model Choices of index file structure Choices of data storage formats Choices of disk layout Database Design Process

  23. External Model User views of the integrated database Making the old (or updated) applications work with the new database design Database Design Process

  24. Overall view of the database that integrates all the needed information discovered during the requirements analysis. Elements of the Conceptual Model are represented by diagrams, Entity-Relationship or ER Diagrams, that show the meanings and relationships of those elements independent of any particular database systems or implementation details. Developing a Conceptual Model

More Related