Databases: Practice

A relational database stores data in tables of records and fields, linked by primary and foreign keys so that the same data is not repeated across a flat file. Recall on key choice, data types, SQL clause order and aggregate functions leads into writing full SQL queries on a Students table: marks above 75, class 10A sorted by name, and a count of class 10B.