Design and Applications of Databases

The Entity-Relationship data model (ER), database schema design based on the ER model, the relational data model, translation from the ER to the relational model, relational schema analysis based on functional dependencies, relational schema normal forms, the SQL language, the QBE language, form-based interaction, report writers, system catalogs, views and integrity constraints, application development with embedded SQL, application development over standard application programming interfaces (ODBC, JDBC), distributed databases, client-server architectures, databases and the web, object-oriented databases.