Please enable JavaScript.
Coggle requires JavaScript to display documents.
Database Design 002 (Process (Conceptual Modeling (Transforms…
Database Design
002
Process
Conceptual Modeling
Transforms
Specifications
Database domain
To Logical Schema
Logical Design
Transforms
Conceptual schema
logical schema
Eg. headers of relational tables
Physical design
Determines
Implementation details
Adds to logical schema persistent storage structures
Improve performance
indexes
Clusters
Partitions
materialized views
Database Domaim
Selected fragment
of real world
Describe by
contents of a
database
Give an example
Database schema
Description of stored data
Expressed in the terms
of a particular data abstraction level
Conceptual Schema
Classes objects
Properties of objects
identifiers
Association
Logical schema
attributes
Value of atttributes
Row
Columsn
header
Table
Physical schema
file
Indexes
Clusters
data blocks
Object Modeling
Specification database domain
Transform into simplified class
diagram
Principles
Content of database
Quantised
(expressed in multiples of basic unit)
discrete objects
known and definable boundaries
nouns
Eg. Building, roads, and land parcels
Where it begins and ends
Vs Continuous data
Each location
measured from a fixed registration pt
eg. Elevation (Fixed point sea level)
Describe by
attributes (properties)
Operations (methods)
class of objects
Common
properties
semanitics
identifiers
link
Conceptual connection btw 2 objs
Association
Genralization