What about replying to the answers you already received in the other
threads about the very same topic instead of starting from scratch
every time? Also, you'll have to find the final answer yourself, it's
about the basic design of your app. You got a bunch of advise already
which should help you to figure out the final solution.
On 13 Sep 2008, at 03:15, soldier.coder wrote:
> But I guess such thinking on my part is futile. So let me lay it all
> out for you.
> My tables:
>
> courses-- this is here to provide in ID and a course
> name for display.
> course_id
> course_name
>
> categories -- another look up table for category names
> category_id
> category_name
>
> So right now I can look up course names and categories in, say
> dropdowns, but I really have
> no place to store *which* categories are for *which* courses. So
>
> weights
> course_id
> category_id
> number(number of grades in this category)
> weight (weight for entire category)
>
> At this point I can pick and store the grading categories for a course
> along with how many
> grades will be stored for what category and the percentage of the
> total grade for the course
> that grades in this category represent. But I still have no storage
> for the actual grades.
> But I can't have grades yet -- because I have no students...
>
> students
> student_id
> first_name
> last_name
> email
> user_name
> password
>
> now I can store grades
>
> grades
> course_id
> student_id
> category_id
> date_assigned
> number_grade
>
> at the some point you need to sum up all the grades in a particular
> category, then multiply
> the total of the category by the weight for the category:
>
> category_totals
> course_id
> student_id
> category_id
> category_raw_total
> category_total_x_weight
>
> then finally, by summing the category_total_x_weight for a particular
> course, and student,
> you get the final grade.
>
> final_grades
> course_id
> student_id
> final_grade
>
> *Soo! That is my whole database setup.
>
> I hate to ask, but could someone tell me how to set up my models?
> I have these huge gaps in my understanding.
>
> For instance, I can see that weights "belongs to" courses and
> categories.
>
> So I should have something like this for Weight model:
>class Weight extends AppModel {
> var $name = 'Weight';
> var $belongsTo = array (
> 'Course' => array('className' => 'Course', 'foreignKey'
> => 'course_id',
> 'conditions' =>null, 'fields'=>null),
> 'Category' => array('className' => 'Category', 'foreignKey'
> => 'category_id',
>'conditions' =>null, 'fields' =>null)
> )
> }
> ?>
>
> But then do I need to establish or describe some kind of relationship
> going the other way for
> Course and Category?
>
> >
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---
