page1
A2
COMPUTING
Relational Database 0
VOCABULARY – know the definitions:
Prior knowledge – GRAPHS
Entity, attribute, record, field.
Classes of entities. Tables of records.
Common features of a class, of records in a table.
Repeated fields - association with other entities.
Association - relationship.
Entity relationship diagram, nature of relationship.
One-to-one, one-to-many, many-to-many.
Primary key, foreign (or alien) key, composite primary key.
First Normal Form - no repeated fields.
Second Normal Form - functional dependency on the (whole) primary key.
Third Normal Form - no transitive dependency.
Relational database management system ...
Relational integrity.
Form, Query, Report.
SQL (Standard query language).
LAMP servers - Linux, Apache, MySQL, PHP.