Results 1 to 6 of 6
Thread: Help (Ralational & ER model)

121204, 08:31 #1Registered User
 Join Date
 Dec 2004
 Posts
 7
Help (Relational & ER model)
Hi guys...I'm new here.Nice to meet you all
So,i've just started a lesson in the university i'm studying which called database systems. I have an exersise to do for relational & er model. I need your opinions (cause as i can see it's not something fixed)for some questions.
1)Which is the strongest spots of each model?
2)Is there any weak spot in each one?If yes, which one (maybe more than one)?
3)Try to imagine a model which concludes(completely or partly) both models.Does this make sense?If yes,what could it be this supermodel?
I would appreciate very much if you could answer me these questions.
Thanks in advance!Last edited by MPSP; 121204 at 19:40.

121204, 08:42 #2SQL Consultant
 Join Date
 Apr 2002
 Location
 Toronto, Canada
 Posts
 20,002
1)Which is the strongest spots of each model?
relational model and er model are apples and oranges
the relational model's main strength is that it is based on math
the er model's main strength is that it is visual
2)Is there any weak spot in each one?If yes, which one (maybe more than one)?
relational model has no weaknesses  some people will argue this point, but they are wrong!!!
er model's main weakness is that it does not always mean you get a good database out of the design effort
3)Try to imagine a model which concludes(completely or partly) both models.Does this make sense?If yes,what could it be this supermodel?
this doesn't make sense

121204, 14:16 #3Registered User
 Join Date
 Dec 2004
 Posts
 7
First of all thanks for answering.
Can you please explain what do you mean when you say apples and oranges?
Why it doesn't make sense (the super model)?Can you tell me some more things about that?
And what do you mean by "out of the design effort"?
Sorry for all these questions but i'm completely new!
I hope i'll get an answer.
Tnx again.Last edited by MPSP; 121204 at 14:52.

121204, 16:39 #4Registered User
 Join Date
 Oct 2002
 Location
 Baghdad, Iraq
 Posts
 697
Originally Posted by r937
Originally Posted by MPSP
As to what it means... Say you're a judge whose job is to determine who has the best produce. If you choose some apples from Farmer Abe and some oranges from Farmer Bob your results won't make sense because the taste is fundamentally different.

121204, 17:02 #5Registered User
 Join Date
 Oct 2002
 Location
 Baghdad, Iraq
 Posts
 697
Originally Posted by MPSP
If I were designing a toolset to do relational modelling, I would want to allow the user to use different strategies to draft his schema. In this case, the ER model's structures would be defined relationally and you could use simple macro replacement to build the logically correct relational expressions.
If the user were a scientific user doing Matlabtype work, I would also want the vectors, matrices &c. to be defined relationally.
Thus, a vector variable v might be backed by a relational variable rv that has constraints on it that it have a PK column Offset and a column of arbitrary data Values. Vector operations would then be translated into the appropriate relational operations.
What's important is that it would all be application independent: having designed your structures in your Matlabtype program, you could browse them with a spreadsheet, and all the various apps could share the DBMS with stepping on each other's toes.

121204, 17:05 #6SQL Consultant
 Join Date
 Apr 2002
 Location
 Toronto, Canada
 Posts
 20,002
Originally Posted by MPSPThe relational model for management of a database is a data model based on predicate logic and set theory.
The fundamental assumption of the relational model is that all data is represented as mathematical relations, i.e., a subset of the Cartesian product of n sets. In the mathematical model, reasoning about such data is done in twovalued predicate logic (that is, without NULLs), meaning there are two possible evaluations for each proposition: either true or false. Data is operated upon by means of a relational calculus and algebra.
 Relational model