Please enable JavaScript.
Coggle requires JavaScript to display documents.
Introduction - Coggle Diagram
Introduction
Database models
ERD
Graphical Symbols
Rectangle
Ellipse
Diamond
line
Hierarchical
Parent-child relation ship (1-n)
Network
many-many relationship (n-n)
Object-oriented
objects (data and relationships)
Relational
tables
rows
cols
Structure of DB
4 types of users
Naive users
Sophisticated users
Application developers
Database Adminstrators
4 mediums of interactions
Application interface
Application programs
Query tools
Administrative tools
Query Processor
Query Evaluation Engine
DDL Interpreter
DML Compiler
Compiler and Linker
Storage Manager
Buffer Manager
File Manager
Authentication & Integrity
Transaction manager
Disk Storage
Data
Indices
Statistics
Data Dictionary
database abstractions
Data Independency
Physical data independence
Logical data independence
3 Levels
Physical / Internal Level
Logical / Conceptual
View / External level