Skip to main content
Ctrl
+
K
Introduction
The course and its tools
Overview
Syllabus
Installation
Communication
Assessment
Networks
Networks
Network models
Network Components
Network Performance
Data management
Data Management
Database Management Systems
Data and information
Flat File vs Relational Database
Relational Database Management Systems
Core database concepts
Organisation
Datatypes
Hierarchy of Data
Relationships
Primary and foreign keys
Composite Keys
Data anomalies
Data modelling
Data dictionaries
Entity Relationship Diagrams
Data Integrity
Factors influencing integrity
Validity vs Accuracy
Normalisation
Purpose of Normalisation
Process of normalisation
Normalise to First Normal Form
Normalise to Second Normal Form
Normalise to Third Noraml Form
Database creation and manipulation
SELECT
INSERT
DELETE
UPDATE
ORDER BY
INNER JOIN
Aggregate Functions
Development Issues
Ethical Issues
Security Issues
Ethical Issues
.md
.pdf
Organisation
Organisation
#
We will look at the structure of the database.
