database

Our system was going include a Java application. We decided this module that it would be more accessible to our user base if it was web based. Many students and instructors work on a several computers regularly, and to install our software on all of them may be an obstacle to using the system.

Functionality

1. provide course material
2. facilitate student annotation of material
3. search
4. material is organized in a flat graph structure rather than a hierarchal tree so that content can be categorized in multiple categories
5. permit instructors to read/edit/delete course material
6. allow students to store and organize favorite pages
7. dropbox functionality - drag and drop, or browse and submit
8. automatically naming and sorting files to save instructors time
9. take input from smart board and save it in the database
10. allow students and instructors to share the smart board

We then created a database that would store all the data necessary to perform the above actions. In order to do this we determined what our main concepts were. We came up with the following list:

1. Files
2. Learning Objects
3. Units
4. Courses
5. Users
6. Assignments
7. Keywords
8. Topics