In the name of ALLAH
docsity.com
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Guidelines and tips
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Database System Application Development Process-Introduction to Database System-Lecture Slides, Slides of Introduction to Database Management Systems
This lecture was delivered by Dr. Tariq Mahmood at Quaid-i-Azam University for Introduction to Database System. It includes: Database, Systems, Application, Development, Process, Design, Application, Programs, Implementation, DB
Typology: Slides
2011/2012
1 / 55
This page cannot be seen from the preview
Don't miss anything!
Related documents
Partial preview of the text
Download Database System Application Development Process-Introduction to Database System-Lecture Slides and more Slides Introduction to Database Management Systems in PDF only on Docsity!
In the name of ALLAH
Introduction to Database
Systems
Lecture 7 (28-02-12)
Spring 12
Department of Computer Science
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
Department of Computer Science
Database Development
Process
Department of Computer Science
Design Stages
Analyze User Environment Develop Conceptual Model Map Conceptual Model to Logical Choose DBMS Develop Physical Design Implement System Test System Operational Maintenance docsity.com
Department of Computer Science
Database Design Phase
Department of Computer Science
Database Modeling
Process of creating a logical
representation of the structure of the database
The most important task in
database development
Department of Computer Science
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
Department of Computer Science
Data Model
Created using a data model
Data Model: is a set of tools or constructs that is used to construct a database design
Department of Computer Science
Components of a DM
Structures
Manipulation language
Integrity constraints
Beep beep, caution
Department of Computer Science
Types of Data Models
Semantic: Entity-Relationship, Object-Oriented
Record based: Hierarchical, Network, Relational
Department of Computer Science
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
Department of Computer Science