Information Management#

Information Management is a core course covering how organizations collect, store, process, and secure data. It bridges raw computer hardware with business decision-making.

Information and Data Management Fundamentals
./fundamentals
Entity-Relationship Diagram

Entity-Relationship Diagram (ERD) is a data modeling technique that graphically illustrates an information system’s entities and the relationships between those entities. It’s a conceptual and representational model fo data used to represent the entity framework infrastructure.

./erd
Re-Engineering of Databases

Database re-engineering is a comprehensive process that involves analyzing, modifying, and optimizing an existing database system to better meet organizational needs.

./reengineering_of_databases
Unified Modeling Language

A widely adopted standard for visualizing, specifying, constructing, and documenting the artifacts of software systems.

./uml
Database Normalization

An important process in relational database design aimed at organizing data to minimize redundancy, enhance data integrity, and improve database efficiency. It is a systematic process used in relational database design to organize data efficiently by dividing large, complex tables into smaller, related tables.

./database_normalization
MySQL
./mysql
Database Administration

Database administration focuses on the operational management of database systems so that they remain available, reliable, secure, and performant. Three core responsibilities are concurrency ontrol, security management, and backup and recovery. These functions direectly affect the quality, reliability, and safety of the data that supports organizational processes.

./db_administration
Distributed Databases

Distributed databases are colelctions of logically related data that are physically stored across multiple sites, servers, or geographical locations. Despite being distributed, they are intended to appear to users as a coherent system that supports consistent storage and retrieval of information.

./distributed_db
Patterns of Data Distribution

In distributed database systems, patterns of data distribution determine how data is stored across multiple servers or locations. Appropriate choices influence reliability, scalability, performance, and security. Three common patterns are replication, vertical partitioning, and horizontal partitioning.

./data_distribution