Please enable JavaScript.
Coggle requires JavaScript to display documents.
Computer Science - Coggle Diagram
Computer Science
Topic 4: Computer Systems
Hardware and Software
Boolean Logic, Expressions and Truth Tables
Software Classification and the role of Operating Systems
Classification of Programming Languages and Translators
Systems architecture(CPU, Performance, Fetch-Execute Cycle, Memory)
Difference between main memory and secondary storage
Why secondary storage is required and different types
Cloud Storage
Embedded Systems
Topic 3: Representation of Data
Converting between number base
Units of information
Character Encoding
Representing images - pixels, image size, colour depth
Representing sound - A → D, sample, sample rate, sample resolution & time
Data Compression - rationale, types, RLE, Huffman
Topic 6: Cyber Security
Definition and purpose
Cyber Security Threats
Penetration testing - purpose and types
Social Engineering
Malicious Code
Methods to detect and prevent Cyber Security Threats
Topic 7: Relational Databases & SQL
Concepts: Database, Relational Database, Table, Record, Field, Primary Key and Foreign Key
How Relational databases eliminate Data Inconsistency & Data Redundancy
SQL Queries using SELECT / FROM / WHERE / ORDER BY
SQL to Add, edit, delete records using INSERT INTO VALUES/UPDATE SET/DELETE FROM