Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

Detailed Diagram, Data Dictionary - Database Management - Lecture Slides, Slides of Introduction to Database Management Systems

Detailed Diagrams, Outline numbering, Limit number of process, Inputs and outputs, Child diagrams, Parent process, Data Dictionary are the main points of this lecture.

Typology: Slides

2011/2012

Uploaded on 11/03/2012

dharmaraaj
dharmaraaj 🇮🇳

4.4

(65)

153 documents

1 / 24

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Database
Management
Systems
Lecture - 6
Docsity.com
pf3
pf4
pf5
pf8
pf9
pfa
pfd
pfe
pff
pf12
pf13
pf14
pf15
pf16
pf17
pf18

Partial preview of the text

Download Detailed Diagram, Data Dictionary - Database Management - Lecture Slides and more Slides Introduction to Database Management Systems in PDF only on Docsity!

Database

Management

Systems

Lecture - 6

In Previous Lecture

We were discussing Context Diagram that…..

Detailed Diagrams

Show processes in successive levels of detail

shows major sub-processes

Detailed Diagrams

Outline numbering  1.1, 1.2, …, 1.n Level one, shows internal details for each major sub- process  1.1.1, 1.1.2,…1.1.n Level two

Detailed Diagrams

All process have both inputs and outputs  Outputs must differ from inputs Child diagrams and parent process must have same input/output

Detailed Diagram

Data Dictionary

May be integrated or freestanding

Integrated is referred by DBMS

Freestanding as a CASE tool

Cross Reference Matrix

A Data Dictionary tool Used to link different things, like functions to entities, or requirements to attributes Can be manual even

Summary

Analyze User Environment or

Preliminary Study + Requirements Analysis

Use of CASE or manual tools

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