A comprehensive report featuring key database concepts, roles, and technologies. This repository contains a structured report for the Database Systems coursework, covering essential foundational topics such as database types, DBMS advantages, cloud integrations, and key roles.
- Flat File Systems vs Relational Databases
- DBMS Advantages Mind Map
- Roles in a Database System
- Types of Databases
- Cloud Storage and Databases
- Project Assets
A detailed comparison between traditional flat file systems and relational databases based on structure, redundancy, relationships, and real-world usage.
A visual mind map illustrating core DBMS benefits:
- Security
- Integrity
- Redundancy
- Backup
- Concurrency
- Data Sharing
- System Analyst – gathers requirements and models needs
- Database Designer – creates data models and relationships
- Database Developer – implements queries and logic
- DBA (Database Admin) – handles backups, tuning, and access control
- Application Developer – connects the database to applications
- BI Developer – builds reports and dashboards
Relational: SQL, Oracle, PostgreSQL
Non-Relational: MongoDB, Cassandra
Centralized: Single-node systems
Distributed: Multi-node systems
Cloud-Based: Managed solutions like AWS RDS, Google Cloud Spanner
Covers how cloud services integrate with database systems, along with pros/cons of using platforms like Azure SQL, Amazon RDS, etc.
- 📝 Database Course Report (PDF)
- 🧠 DBMS Mind Map (in
/assetsfolder)
[Alzahra Ahmed Said AlBreiki] – Codeline Training Program, June 2025
📣 This project serves as a complete reference for new trainees learning foundational database concepts in a practical format.