JAVA & DBMS CHEAT SHEET
JAVA FUNDAMENTALS
• Java is an object-oriented, platform-independent language.
• Java Flow: .java → Compiler → Bytecode → JVM → Output
OOP Concepts
• Encapsulation – Data hiding
• Inheritance – Code reuse
• Polymorphism – Many forms
• Abstraction – Hide implementation
JVM / JRE / JDK
• JVM – Executes bytecode
• JRE – JVM + libraries
• JDK – JRE + compiler
Exception Handling
try, catch, finally – prevents program crash
DBMS FUNDAMENTALS
• DBMS stores and manages data efficiently
• Table – rows & columns
• Schema – database structure
Keys
• Primary Key – unique, not null
• Foreign Key – links tables
SQL Commands
• DDL – CREATE, DROP
• DML – INSERT, UPDATE, DELETE
• DQL – SELECT
Normalization
• 1NF, 2NF, 3NF – reduces redundancy
Java + DBMS
• JDBC connects Java with database