A class register has a row for each student and a column for each detail, such as the name or the date of birth.
3 lessons, about 1 h 15 min3 simulations10 problems3 practice questionsPython in every lesson
A database table stores data about many things of one kind, such as the members of a club. Each row is a record and each column is a field. You learn these words, count records and fields, and define a single-table database from a list of what has to be stored.
Each field stores one kind of data, so each field gets a data type: text, character, Boolean, integer, real or date/time. Each table also needs a primary key, a field whose value is different in every record. You choose suitable data types and pick a suitable primary key for a table.
A database is only useful if its data is sensible. Validation is a check that the computer makes on data before it goes into a table. You choose suitable checks for each field: range, length, type, presence, format and check digit, and you write validation in Python before a record is added.
Log in to join the discussion.
Loading…