Study Note: Database Management
NoteDatabase Management
A DBMS stores and manages data with less redundancy, better integrity and security. Models: hierarchical, network, relational (tables of rows and columns; E. F. Codd) and object-oriented. A primary key uniquely identifies a row; a foreign key links to another table. Normalisation reduces redundancy.
SQL: DDL (CREATE, ALTER, DROP), DML (SELECT, INSERT, UPDATE, DELETE), DCL (GRANT, REVOKE). Example:
SELECT name, marks FROM student WHERE marks >= 80 ORDER BY marks DESC; Group functions: COUNT, SUM, AVG, MAX, MIN with GROUP BY.