Open source projects allow free access to source code, enabling users to study, modify, and redistribute it, while closed source projects keep their code private. Databases, typically created in an RDBMS like MySQL, consist of tables that store data, and can be modified using specific commands. SaaS, PaaS, and IaaS are service models where SaaS provides software, PaaS offers platforms for application development, and IaaS delivers infrastructure services.