Database design phase.pptx BY SIR KHURAM GCUF

DBMS SLIDES

1. Database Design Phase

2. Database Design Design and Model mean the same Database Design represents logical structure of the database

3. Database Modeling Process of creating a logical representation of the structure of the database The most important task in database development

4. Points to Remember A database must mirror the real world. Only then can it answer questions about the real world !

5. Points to Remember Ideally it should be represented graphically The goal is to identify the facts to be stored in the database Database modeling involves users and analysts

6. Data Model Data Model: is a set of tools or constructs that is used to construct a database design

7. Components of a DM Structures Data Manipulation Language(DML) Integrity constraints

8. Significance of DM Facilitates and provides guidelines or rules in the DB design process Every DBMS is based on a DM

9. Types of Data Models Semantic: Entity-Relationship, Object-Oriented Record based: Hierarchical, Network, Relational

10. DB Design Types Conceptual: using SDM(Semantic Data Model) Generally using ER(Entity Relationship) Logical: using DM of tool Generally using Relational Physical: using the DBMS