Types of Data Models Conceptual Data Models Implementation

  • Slides: 31
Download presentation

ประเภทของแบบจำลองขอมล (Types of Data Models) Conceptual Data Models Implementation Data Models

ประเภทของแบบจำลองขอมล (Types of Data Models) Conceptual Data Models Implementation Data Models

พนฐานการสรางแบบจำลองขอมล (Data Models Basic Building Blocks) Entities Attributes Relationships Constraints

พนฐานการสรางแบบจำลองขอมล (Data Models Basic Building Blocks) Entities Attributes Relationships Constraints

พนฐานการสรางแบบจำลองขอมล (Data Models Basic Building Blocks) - ความสมพนธระหวาง Entities 1: 1 1: M Attributes

พนฐานการสรางแบบจำลองขอมล (Data Models Basic Building Blocks) - ความสมพนธระหวาง Entities 1: 1 1: M Attributes M : M หรอ M : N Relationships Constraints

แบบจำลองฐานขอมล (Database Model) Hierarchical Database Model Network Database Model Relational Database Model Object-Oriented Database

แบบจำลองฐานขอมล (Database Model) Hierarchical Database Model Network Database Model Relational Database Model Object-Oriented Database Model Multidimensional Database Model

โครงสรางขอมลเชงสมพนธ (Relational Data Structure) Primary Key : PK Attribute (Field, Column) Cardinality Tuple (Record,

โครงสรางขอมลเชงสมพนธ (Relational Data Structure) Primary Key : PK Attribute (Field, Column) Cardinality Tuple (Record, Row) Relation (Table, File) Degree Domain : Rang of Data in each Field Foreign Key : FK

กฎ 12 ขอของคอดด (Codd’s 12 Relational Database Model) • • • Information Guaranteed Access

กฎ 12 ขอของคอดด (Codd’s 12 Relational Database Model) • • • Information Guaranteed Access Systematic Treatment of Null Dynamic On-Line Catalog Based on the Relational Model Comprehensive Data Sublanguage View Updating High-Level Insert, Update and Delete Physical Data Independence Logical Data Independence Integrity Independence Distribution Independence Nonsubversion

คย (Keys) Candidate Key : CK Primary Key : PK Alternate Key / Secondary

คย (Keys) Candidate Key : CK Primary Key : PK Alternate Key / Secondary Key Foreign Key : FK Composite/Concatenated/Compound Key Super Key

Conceptual Models Conceptual model A conceptual model isConceptual Models Conceptual model A conceptual model is
Conceptual Models HCIUIST Course Solange Karsenty Conceptual ModelsConceptual Models HCIUIST Course Solange Karsenty Conceptual Models
Conceptual Models HCIUIST Course Solange Karsenty Conceptual ModelsConceptual Models HCIUIST Course Solange Karsenty Conceptual Models
Conceptual vs Craftsmanship First Conceptual Conceptual art DefinitionConceptual vs Craftsmanship First Conceptual Conceptual art Definition
Conceptual Framework NEED FOR CONCEPTUAL FRAMEWORKS The ConceptualConceptual Framework NEED FOR CONCEPTUAL FRAMEWORKS The Conceptual
Open Conceptual Data Models Making the Conceptual LayerOpen Conceptual Data Models Making the Conceptual Layer
Preliminary Conceptual Model Development Develop preliminary conceptual modelsPreliminary Conceptual Model Development Develop preliminary conceptual models
Four Types Four Types Four Types Four TypesFour Types Four Types Four Types Four Types
Enum Types ENUMERATED DATA TYPES Enumerated Data TypesEnum Types ENUMERATED DATA TYPES Enumerated Data Types
Understanding Models How models help algorithms models ImplementationUnderstanding Models How models help algorithms models Implementation
Discrete models Types of discrete models Binary modelsDiscrete models Types of discrete models Binary models
Data Types and Variables Numeral Types Text TypesData Types and Variables Numeral Types Text Types
MODELS AND TECHNOLOGICAL DESIGN MODELS MODELS Models helpMODELS AND TECHNOLOGICAL DESIGN MODELS MODELS Models help
Unit 2 Data Models Chapter 7 Conceptual dataUnit 2 Data Models Chapter 7 Conceptual data
From Conceptual Models to Simulation Models Model DrivenFrom Conceptual Models to Simulation Models Model Driven
ID Conceptual Models Mental Models Summary CSSE 477ID Conceptual Models Mental Models Summary CSSE 477
C Data Types Primary data types Derived dataC Data Types Primary data types Derived data
Data types Outline Primitive data types Structured dataData types Outline Primitive data types Structured data
Geographical Data Types Geographical Data Geometrical data typesGeographical Data Types Geographical Data Geometrical data types
Geographical Data Types Geographical Data Geometrical data typesGeographical Data Types Geographical Data Geometrical data types
Data types Outline Primitive data types Structured dataData types Outline Primitive data types Structured data
Data Types and Data Structures Data Types KeywordsData Types and Data Structures Data Types Keywords
Types of Data Types of data Categorical dataTypes of Data Types of data Categorical data
Data Types Analysis Types of Data QUANTITATIVE DATAData Types Analysis Types of Data QUANTITATIVE DATA