Re: Representing Student Activity Score

> > Could you show how to explicity represent the following info in RM:
> > john take test.
> > john get 95.
> > (john get 95) for (john take test).
>
> PERSON SCORE
> John 50
> Mary 75

A program could derive each tuple's relationship to a person and score (ie tuple1's person is john, tuple1's score is 50. It doesn't encode the original info explicitly.

> Or, if you want a sentence as a result;
> SELECT person||' scored '||score||' in the exam.' FROM =test_scores;
> John scored 50 in the exam.
> Mary scored 75 in the exam.

In the above, which is closer to desired, the SQL statement itself is providing some of the relationship between the data, not data in the db, unlike that shown at www.xdb2.com/Example/StudentActivityScore.asp Received on Fri Jul 23 2004 - 02:42:21 CEST