Learning by doing is an important strategy to retain knowledge. This course teaches students the ability to develop a  real-world database application. In this process, the students apply the theories and practice developed in class. This is not a team project. Instead, each student should complete it independently.

After this course, you should be able to

• identify, collect and analyze the requirements
• make the requirements concrete by using ER modeling
• design a relational database
• load and query database
• improve performance using indexes and views
• develop a small web application

Part #1. Project plan and database design using ER/EER data model

Part #2. Relational database design (tables, constraints)

Part #3. Database implementation using commercial DBMS (SQL)

Part #4. Performance analysis (bulk load, indexes, views)

Part #5. Application development (JDBC etc.)

More details for each assignment will appear later.

I hope you enjoy it!