M
mmm
Hi everyone,
I tried to map from ORM diagram to ER model but I found that the constraint
I've set on ORM diagram is not mapped!
My facts and constraints are:
1. Student(IdStu) is in University(IdUni) (constraint: each student must be
in 1 univ)
2. Student practices Sport(IdSpo)
3. Student practices Art(IdArt)
The external mandatory constraint on facts 2 and 3 is: every student must
practice Sport or Art.
After mapping, 3 tables created are
1. Student(Student IDStu, Is in University IdUni),
2. Student practices Art(Student IdStu, Art),
3. Student practices Sport(Student IdStu, Sport IdSpo).
There's a relationship from the table "Student practices Art" to "Student"
and a relationship from the table "Student practices Sport" to "Student".
So the problem is this model does not tell us that every student must
practice Art or Sport!
Is it impossible to convert from ORM to ER with full information/constraints?
Thank you very much and awaiting for your reply.
I tried to map from ORM diagram to ER model but I found that the constraint
I've set on ORM diagram is not mapped!
My facts and constraints are:
1. Student(IdStu) is in University(IdUni) (constraint: each student must be
in 1 univ)
2. Student practices Sport(IdSpo)
3. Student practices Art(IdArt)
The external mandatory constraint on facts 2 and 3 is: every student must
practice Sport or Art.
After mapping, 3 tables created are
1. Student(Student IDStu, Is in University IdUni),
2. Student practices Art(Student IdStu, Art),
3. Student practices Sport(Student IdStu, Sport IdSpo).
There's a relationship from the table "Student practices Art" to "Student"
and a relationship from the table "Student practices Sport" to "Student".
So the problem is this model does not tell us that every student must
practice Art or Sport!
Is it impossible to convert from ORM to ER with full information/constraints?
Thank you very much and awaiting for your reply.