Comsci unit3&4

Domain integrity defintion

Enforces rules for data type and range to ensure accurate and valid data

Referential integrity definition

Data referenced in one instance must exist. Relationships between tables are maintained.

Atomicity in ACID

All operations are treated as a single unit, either the entire transaction succeeds or the transaction is aborted. Ensures no partially-complete operations

Consistency in ACID

Any transactions and data written preserves the database in the same, valid state, and follows all constraints

Isolation in ACID

Transactions performed simultaneously result in the same database state as if the transactions were performed seperately

Durability in ACID

guarantees that once a transaction has been committed, it will remain committed even in the case of a system failure

Binary search vs linear search

unfinished

APP11

Requires organisations to take active measures to ensure the security of personal info it holds, and to actively consider whether it is permitted to retain personal info

SQL injection definition

Use of malicious SQL code for backend database manipulation to access info that was not meant to be displayed

SQL injection mitigation strategies

unfinished

4 actions in response to data breach

unfinished

Notifiable data breaches amendment

Introduce mandatory data breach notifications. Ensure that individuals affected by data breaches are informed and can take steps to mitigate impact, while also holding the organisation accountable for failing to protect info

Encapsulation in OOP definition

Bundling data/methods into a class and restricting direct access for security reasons

Inheritance in OOP definition

unfinished

Polymorphism in OOP definition

unfinished

Public vs private IP address

unfinished

Entity integrity

unfinished

Cross site scripting definition

Allows injection of client-side scripts into webpages that are viewed by others

Insertion sort VS selection sort

unfinished

TCP/IP layers

Network Access, Internet, Transport, Application

Purpose of normalising data to 1st normal form

unfinished

Purpose of normalising data from 1NF to 2nd normal form

unfinished

Transport layer purpose in DoD TCP/IP model

ensures delivery of data between hosts (end-to-end)

Network Access layer purpose in DoD TCP/IP model

handles physical transmission of data over networks (hop-to-hop)

Application layer purpose in DoD TCP/IP model

provides services and protocols apps use to access the network

Linear/Waterfall system

unfinished

Iterative system

unfinished

OSI model layers

Physical, Data Link, Network, Transport, Session, Presentation, Application

Internet layer purpose in DoD TCP/IP model

handles logical addressing and routing across multiple networks

Physical layer purpose in OSI model

transmits raw bits as electrical signals and sends through cables

Data link layer purpose in OSI model

handles MAC addresses and formats+packages data

Network layer purpose in OSI model

determines the physical path data will be sent on across networks

Transport layer purpose in OSI model

transmits data between systems

Session layer purpose in OSI model

Maintains connections and controls sessions

Presentation layer purpose in OSI model

Ensures data is encrypted and readable

Application layer purpose in OSI model

Human-Computer interaction layer, provides network services directly to applications