Using a Database to Track Downloaded Artist Artworks
Following the principle that “it’s not yours unless it’s on your own hard drive,” and with my phone’s growing image …
Object-Oriented Basics
Object-Oriented (OO) is a highly practical, systematic approach to software development. Procedural vs. Object-Oriented …
Database Study Seven: Database Control Functions
Transaction Management A transaction is a sequence of operations that are “all or nothing.” Transactions and programs …
Database Learning 6: Database Design
Database Design Strategies Top-down and bottom-up; usually a combination of both is used. Database Design Steps The “New …
Database Study Five: Normal Forms
Relations in a relational database must meet certain normalization requirements. Normal forms are used to measure …
Relational Database Theory: Database Learning Part 4
Relational Schema A relational schema is formally defined as a 5-tuple (including the relation name): R<U, D, dom, F> R: …
Database Learning Part 3: SQL
SQL Classification DDL (Data Definition Language) In a database system, every database, table, view, and index is an …
Database Learning 2: The Relational Model
Basic Terms in the Relational Model A relational database system is a database system that supports the relational …
Database Learning 1: Introduction to Databases
Introduction My previous database notes were a bit of a mess, so I’m rewriting them while reviewing the material (though …
Learning Linux Chapter 12: Managing Disks and Filesystems
Chapter 12: Managing Disks and Filesystems 12.1 Understanding Disk Storage The fundamental principles of data storage …