Course Decription

This course covers the design, organization, representation, and manipulation of databases. Topics include the relational model, data definition, data manipulation, queries (SQL), communication and representation (XML), design concepts, security, and integrity.

Team Project

This course required the completion of a team project. The project guidelines are as follows:

  1. Defining the project (one or two pages of description)
  2. Converting the description to ER model.
  3. Converting ER to RM.
  4. Implementing the RM with SQL on MySQL server, i.e. creating a database on MySQL server.
  5. Building the GUI with PhP or JSP (or any other web language you are familiar with); a website that people could use to have access to your database.

My team project can be found here

Course Notes

Module 2