Databases - Part 3

the limitations of a file-based approach to storage and retrieval of data
the features of a relational database that overcome the limitations of a
file-based approach
the terminology associated with a relational database model
entity-relationship (E-R) diagrams to document database design
normalisation to third normal form (3NF)
producing a normalised database design for a given set of data or
tables
the features provided by a database management system (DBMS)
the software tools provided by a DBMS
the creation and modification of a database structure using a database
definition language (DDL)
queries and the maintenance of a database using a database
manipulation language (DML)
using SQL as a DDL and as a DML
how to understand a given SQL script
how to write an SQL script.