Please enable JavaScript.
Coggle requires JavaScript to display documents.
Unit 10: Databases - Coggle Diagram
Unit 10: Databases
Section C: Database Designs
Data Types
Date
integer
real
BLOB
Logical
Memo
Text
Hyperlink
Data Entry
Case
Field Format
Field Validation
Lookup
Sorting and Indexing
Interface Design
REport DEsign
Normalization
fields
computing fields
field format
field validation
lookup routine
tables
relationships
Section B: Database Tools
DBMSs
Security
Multiple Users
Physical Storage
Dedicated Applications
Spreadsheet Software
Word Processing Software
Sort
Mail Merge
Section A: Database Basics
Types
Analytica
executive dashboards
OLAP
operational
collect and store data
view data
find data
update data
organize data
distribute data
move or remove data
Cardinality
one-to-one
one-to-many
many-to-many
Models
graph
hierarchical
Flat file
object
multi-dimensional
relational
document-oriented
Section D: SQL
Commands
Select
Insert
Delete
Create
Update
Join
Parameters
Search Operators
AND
OR
NOT
Section E: Big Data
The Data Universe
Big Data
High Velocity
High Volume
Unknown Veracity
Low Density
Diversified Variety
NoSQL Characteristics
Distributed
Dynamically Scaling
Data Flexible
Non-relational
NoSQL Data Models
Column oriented
document oriented
graph
