You know ? 
Author Message
 You know ?

According to  ENTITY-RELATION MODEL in a data-base, i have to find out the
good diagram for this model. It's about a school who wants to keep track
of its courses and the results of its students. From that data-base, it's
suppose to be possible to create, on each session, the schedule of the
students. These schedules must contain ;

                         -the code of the course
                         -the title of the  course
                         -the group number
                         -the theacher's name of the group-course
                         -the day and hour of that group-course
                         -the local of this group-course

I think that i have the solution but i want to be sure "'cause you know
sometimes words have two meanigs !", and to take other advices. Here is
what i think it should be; (I could't draw it 'cause last time i tried it
my caracters were flying around anywhere on the screen)

My solution is;

A first entity named "Students" with complements : student's code (Key),
name, address and tel. The second entity is "Courses"  with complements :
group number (Key), code of the course, title of the course and the day
and hour of the course. The third entity is "Teachers" with complements :
teacher's name (Key) (supposing that no teacher has the same name),
qualifications and the teacher's office.

Between the entities "Students" and "Courses", i made the RELATION
"Enrolment" with complements : student's code, code of the course, date
and price of the course. Between the entities "Courses" and "Teachers", i
made the RELATION "Schedule" with complements : Name of the teacher , Code
of the course, Local of the course and the group number.

Am I right ?
Thanks for helping.

--
J'MOR



Thu, 09 Jul 1998 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. I know one of you knows where to find this article

2. Don't know the field name but do know the column order

3. I know you know this ...

4. I don′t know oracle, but i need know

5. How does SET RELATION know what it knows?

6. Does anyone know of any VB4.x developers that know Fixed Income Trading???

7. I know this can be done ! ( But I am not smart enough to know how :) )

8. I know this is a crosspost, but I need to know which is the best one for posting INET FTP queries

9. I know I know HELP: File Specs for .DBF files. Where can I find them????

10. I know this sounds silly but I've really got to know...

11. does anyone know of a good book which refers to ADP development and deployment

12. Does anyone know why CHECK Constraint text does not appear


 
Powered by phpBB® Forum Software