Database Systems Lecture 7 and 8: Database Design and Relational Data Model, Slides of Distributed Database Management Systems

Download Database Systems Lecture 7 and 8: Database Design and Relational Data Model and more Slides Distributed Database Management Systems in PDF only on Docsity!

In the name of ALLAH

Introduction to Database

Systems

Lecture 7 (28-02-12)

Spring 12

Database Design

 A DB Design is a model of a particular real-world system

 It provides a picture of reality

 Should be simple and self- explanatory

Database Development

Process

Design Stages

Analyze User Environment Develop Conceptual Model Map Conceptual Model to Logical Choose DBMS Develop Physical Design Implement System Test System Operational Maintenance

Database Design Phase

Database Modeling

 Process of creating a logical

representation of the structure of the database

 The most important task in

database development

Points to Remember

 A database must mirror the real world. Only then can it answer questions about the real world!  The emphasis of data modeling is on representing reality

Data Model

 Created using a data model

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

Components of a DM

 Structures

 Manipulation language

 Integrity constraints

 Beep beep, caution

Types of Data Models

 Semantic: Entity-Relationship, Object-Oriented

 Record based: Hierarchical, Network, Relational

DB Design Types

 Conceptual: using SDM

 Logical: using DM of tool

 Physical: using the DBMS

Introduction to Database

Systems

Lecture 8 (01-03-12)

Spring 12

Introduction to

Relational Data Model