Home Movies Database

Home movies database was my final team project for ICS 113; Database Fundamentals. My three group members and I created a movies database using Microsoft Access for families to manage movie collections at home. It was three-week project, and we built a database and gave an end of project presentation to report our works in class.

The idea of project was from one of my group members. He has too many DVDs, Blu-rays, and movie collection shelves in different places at his home. So, we decided to develop a database to organize movie collections and created seven tables, data fields, data input forms, relationships, primary and foreign keys. The databases we created contained information related movie, actors, casts like the popular online database, IMDb, but also contained information for user convenience. For example, location table represented where the searching movie collection is located.

I was in charge of database design, tables, input forms and spent most of my time to test our database as an user to find errors and mistakes my group made. In this project, I had a chance to apply my learning of entire ICS 113 and experienced in collaborative work with my group members. while we helped each others and made decisions together, also developed communication skills and had responsibilities as one team. After presentation, there was general interest in our database, so my group shared the database to the whole class.