Please enable JavaScript.
Coggle requires JavaScript to display documents.
Information Systems + Databases (Types (Information (e.g. DB), Decision…
Information Systems + Databases
Hypermedia
Organisation:
Node + link
URL (Uniform Resource Locator)
Metadata (data about data) e.g. HTML tags
Storyboard (linear, hierarchical, composite, non-linear)
HTML editors, web editor
Displaying
Different views of a DB e.g. forms + reports
Relational DB
Organisation:
Entities + attributes
Relationships - 1 to 1, 1 to many, many to many
linking primary + foreign keys
schema diagram
normalisation
Flat file DB
Organisation:
File, record, field, character
Primary key
Types
Information (e.g. DB)
Decision Making
Management Information
Transaction Processing
Information Systems + Databases -> Storage + Retrieval
Separation of data from DBMS
DBMS is the software handles the data
Data file is separate to the DBMS
Types of Access
Direct + Sequential
Online + Offline storage
Centralised + distributed DB
Tools to extract data
DB - SQL (SELECT, FROM, WHERE, ORDERBY)
Hypermedia
Search engine -> intelligent agent
Indexing
Reports in DB
Types of storage media
HDD
SSD
CD
DVD
Flash
Magnetic tape + disk
Encryption + decryption
Encode
Decode
Symmetric: Public key
Asymmetric: Private key