Re: Learning Management System MySql Database design

[Grzegorz Agacinski]

Hi

I think you need to define the scope of the project, list core functionality it will provide - otherwise you can go forever with yor project as there is always someting you can add. Once you know scope and data flow you can start collecting and designing base for your projects: database. Think what you need for each fucntinality and writhe it down - do now warry at this moment (now just list anything you think about). Next step woould be to structure you findings: for create tables, columns, data type to store it. Next think again what you crated, try to think about normalization and how easy it would to add soemthing new (as probably new functions will be needed in the future). You need spend time to craete good database schema.

Think as well if you would like to use data for any reports: e.g. to say how many students worked on the projects X between date1 and date2, how many strudents finsised task1 before task1, etc - it depends what are the obejctives of your projects.


I hope this will help

Greg

Grzegorz Agacinski
http://webdevsphere.com