Please enable JavaScript.
Coggle requires JavaScript to display documents.
Database (Types of Database Models (Relational Model (Constraints (Not…
Database
Types of Database Models
Flat File Model
Hierarchical Model
Network Model
Relational Model
Constraints
Not null
Primary
Unique
Foreign
Check
Object Oriented Model
DBMS
Oracle
Data type
Varchar2
Char
Number
Date
Long
Clob
Nclob
Raw
Long Raw
Blob
Bfile
Rowid
MariaDB
Postgre
MS.Access
SQL Server
Datum (singular)/Data
Char
Field
Record
Table
Structured Query Language
TCL
Commit
Rollback
DDL
Create
Alter
Add
modify
drop
Drop
DML
Insert
Update
Delete
Select
Data Modeling
Conceptual Data Modeling
Attributes
mandatory
must have a value
Unique identifier
Simple UID
Composite UID
optional
Relationships
Types of relationship/cardinality
one to one
one to many
many to many
Foreign key
Entity
noun
intangible
event
tangible
Logical/ERD
Physical
Data Model Notations
Barker Notation
Bachman Notation
Information Engineering
Data Storage
Physical Structure
Data files
Control Files
Online redo log files
Logical Structure
Data blocks
Extents
Segments
Table Spaces
Information
PL/SQL Data Type Categories
Scalar
Character/String
Char
Varchar2
Long
Numeric
Number
PLS_integer
Date
Date
Timestamp
Timestamp with time zone
Boolean
Composite
Record
Table
varray
Large Object (LOB)
Book (CLOB)
Photo (BLOB)
Movie (BFILE)
NCLOB (unicode characters)
Reference
Object
Schema (logical structures of data)
tables
views
indexes
packages
procedures