Database Exercises for lab assignments and final exam:

MySQL Client SQL File Operations Relational database terminology Single Entity Database(Employee) Single Entity Database(Student) Database backup and restore Table update Aggregate Functions and Grouping Relational model concepts One-to-Many Database Querys Database and Table Design Concepts One-to-Many Table Administration 1:M Relational Database Modeling Table administration Multiple relation querys Views Indexes

PHP/MySQL Query A form for query Database Modeling PHP/MySQL Basics Security and Data sharing Managing Database Objects Normalizing: Application Point of View Normalizing to minimize anomalies Many-to-Many Table Administration Database and table design II Relational Operations Character String functions Date functions

The links above are to documents distributed in class. Solutions were provided in class. They are referred to as "practice" because it is expected that reworking the exercise (soon) will better prepare you to apply the information to an assignment or exam.

updated 11 May 2015