Message from discussion
UML beginner diagram
Received: by 10.180.104.163 with SMTP id gf3mr1850006wib.0.1332141144329;
Mon, 19 Mar 2012 00:12:24 -0700 (PDT)
X-BeenThere: umlforum@googlegroups.com
Received: by 10.216.8.20 with SMTP id 20ls10798284weq.2.gmail; Mon, 19 Mar
2012 00:12:22 -0700 (PDT)
Received: by 10.180.106.42 with SMTP id gr10mr1372393wib.1.1332141142818;
Mon, 19 Mar 2012 00:12:22 -0700 (PDT)
Received: by 10.216.69.74 with SMTP id m52mswed;
Sun, 18 Mar 2012 09:49:12 -0700 (PDT)
Received: by 10.204.129.15 with SMTP id m15mr821849bks.2.1332089351594;
Sun, 18 Mar 2012 09:49:11 -0700 (PDT)
Received: by 10.204.129.15 with SMTP id m15mr821848bks.2.1332089351570;
Sun, 18 Mar 2012 09:49:11 -0700 (PDT)
Return-Path: <ps22041...@gmail.com>
Received: from mail-lpp01m010-f50.google.com (mail-lpp01m010-f50.google.com [209.85.215.50])
by gmr-mx.google.com with ESMTPS id cs9si14604365bkb.3.2012.03.18.09.49.11
(version=TLSv1/SSLv3 cipher=OTHER);
Sun, 18 Mar 2012 09:49:11 -0700 (PDT)
Received-SPF: pass (google.com: domain of ps22041...@gmail.com designates 209.85.215.50 as permitted sender) client-ip=209.85.215.50;
Authentication-Results: gmr-mx.google.com; spf=pass (google.com: domain of ps22041...@gmail.com designates 209.85.215.50 as permitted sender) smtp.mail=ps22041...@gmail.com; dkim=pass header...@gmail.com
Received: by lahm13 with SMTP id m13so5760857lah.37
for <umlforum@googlegroups.com>; Sun, 18 Mar 2012 09:49:11 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
d=gmail.com; s=20120113;
h=mime-version:in-reply-to:references:date:message-id:subject:from:to
:content-type;
bh=dQFHzMnB62/yRHvd0JjvjSeO+UcUDVkkwV0WrgV/WqY=;
b=0UMA9gwWGa+6c0K7E0WrLkikK3BRG3xv2+NblNqlYNW//H/I5EJZVlhHzg6jc5IXkY
aYTvV1KxmhBE9lOXD0dTTKY5NgoEt6jRX2CxL854P85hlXk3B8XQmDLOSLXAI5m/dltQ
ozrU0kkKI8fr3ZtuhV2qmDBeHg4DDE2dSVMx/9wEFcjDaDLzDJwQHlDAl2noKlOHAS5H
n+o9M+6CHNI/RL4HxCJeqGTlOz/EMAVYbZcuMsfLLD0j79LQQDO0PhaqulFG2GCg4MVl
tco3hVDu8ltJpe2czLSBvKiXnH/uDCRp4r4CUcxvyAHDhYal5mwHbA222ZlP418Tkv/3
J6sQ==
MIME-Version: 1.0
Received: by 10.152.105.19 with SMTP id gi19mr7014091lab.11.1332089351104;
Sun, 18 Mar 2012 09:49:11 -0700 (PDT)
Received: by 10.152.114.168 with HTTP; Sun, 18 Mar 2012 09:49:11 -0700 (PDT)
In-Reply-To: <CACiT7pkPuHyO8L4qO-727hO41EnnPaaU8ffo55vSTTsK4b8...@mail.gmail.com>
References: <5373812.1384.1331230687136.JavaMail.geo-discussion-forums@vbbed8>
<7570398.3831.1331483673297.JavaMail.geo-discussion-forums@vbbfw10>
<4F5F6962.7060...@verizon.net>
<14929525.1756.1331723909189.JavaMail.geo-discussion-forums@vbcv2>
<4F635A79.2060...@verizon.net>
<CACiT7pkPuHyO8L4qO-727hO41EnnPaaU8ffo55vSTTsK4b8...@mail.gmail.com>
Date: Sun, 18 Mar 2012 17:49:11 +0100
Message-ID: <CACiT7pnMXqssLiPLFAfdstZwP3tqH_5pk7gC1qUthdXmvzo...@mail.gmail.com>
Subject: Re: [UML Forum] Re: UML beginner diagram
From: PMar Kers <ps22041...@gmail.com>
To: umlforum@googlegroups.com
Content-Type: multipart/alternative; boundary=f46d040716e194e6ba04bb8738e8
--f46d040716e194e6ba04bb8738e8
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable
I for got to add the question... :)
delete restrict - maybe (for schools) , so does not affect the students_ori
table
update cascade for the courses table
delete cascade for both table school and courses for the contacts.
am I missing any constraint?
by the way is there any possibility of having an Inheritance?
regards
Mar
On Sun, Mar 18, 2012 at 5:17 PM, PMar Kers <ps22041...@gmail.com> wrote:
> Dear all,
>
> I will need to create restrictions or domains for my DB.
> and based in your help and suggestions so far, I manage to build this
> model (very similar to the previous). the relationship between the school=
s
> and courses I left as it was, following the suggestion from Simon. I also
> added the new table for students_ori this will help to connect the course=
s
> from the department of the university with the schools (from where the
> students come - origin). I believe this is the right path.
>
> best regards,
> Pedro
>
>
> On Fri, Mar 16, 2012 at 4:21 PM, H. S. Lahman <h.lah...@verizon.net>wrote=
:
>
>> Responding to Wright...
>>
>>
>> To H.S.: My membership of this group is set to =91no email=92, and I ge=
t
>>> notification of postings via RSS <feed://groups.google.com/**
>>> group/umlforum/feed/rss_v2_0_**msgs.xml<http://groups.google.com/group/=
umlforum/feed/rss_v2_0_msgs.xml>>;
>>> both of your responses to MARKERPED showed up there and are visible in =
the
>>> new Google Groups view.
>>>
>>
>> OK, thanks. At least they seem to be getting posted to the forum. I only
>> use the email connection and apparently Google has stopped echoing to th=
e
>> sender. I guess I'll just have to BCC myself.
>>
>>
>> --
>> Life is the only flaw in an otherwise perfect nonexistence
>> -- Schopenhauer
>>
>> Rene Descartes went into a bar. The bartender asked if he would like a
>> drink. Descartes said, "I think not," and disappeared.
>>
>> H. S. Lahman
>> H.lah...@verizon.net
>> software blog: http://pathfinderpeople.blogs.**com/hslahman/index.html<h=
ttp://pathfinderpeople.blogs.com/hslahman/index.html>
>>
>> --
>> You received this message because you are subscribed to the Google
>> Groups "UML Forum" group.
>> Public website: www.umlforum.com
>> To post to this group, send email to umlforum@googlegroups.com
>> To unsubscribe from this group, send email to
>> umlforum+unsubscribe@**googlegroups.com<umlforum%2Bunsubscribe@googlegro=
ups.com>
>> For more options, visit this group at
>> http://groups.google.com/**group/umlforum?hl=3Den?hl=3Den<http://groups.=
google.com/group/umlforum?hl=3Den?hl=3Den>
>>
>
>
--f46d040716e194e6ba04bb8738e8
Content-Type: text/html; charset=windows-1252
Content-Transfer-Encoding: quoted-printable
I for got to add the question... :)<div>delete restrict - maybe (for school=
s) , so does not affect the students_ori table</div><div>update cascade for=
the courses table</div><div>delete cascade for both table school and cours=
es for the contacts.</div>
<div>=A0am I missing any constraint?</div><div>by the way is there any poss=
ibility of having an Inheritance?</div><div><br></div><div>regards</div><di=
v>Mar<br><br><div class=3D"gmail_quote">On Sun, Mar 18, 2012 at 5:17 PM, PM=
ar Kers <span dir=3D"ltr"><<a href=3D"mailto:ps22041...@gmail.com">ps220=
41...@gmail.com</a>></span> wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex">Dear all,<div><br></div><div>I will need to =
create restrictions or domains for my DB.</div><div>and based in your help =
and=A0suggestions=A0so far, I manage to build this model (very similar to t=
he previous). the relationship between the schools and courses I left as it=
was, following the=A0suggestion=A0from Simon. I also added the new table f=
or students_ori this will help to connect the courses from the department o=
f the university with the schools (from where the students come -=A0origin)=
. I believe this is the right path.</div>
<div><br></div><div>best regards,</div><div>Pedro</div><div class=3D"HOEnZb=
"><div class=3D"h5"><div><br><br><div class=3D"gmail_quote">On Fri, Mar 16,=
2012 at 4:21 PM, H. S. Lahman <span dir=3D"ltr"><<a href=3D"mailto:h.la=
h...@verizon.net" target=3D"_blank">h.lah...@verizon.net</a>></span> wro=
te:<br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex">Responding to Wright...<div><br>
<br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex">
To H.S.: My membership of this group is set to =91no email=92, and I get no=
tification of postings via RSS <feed://<a href=3D"http://groups.google.c=
om/group/umlforum/feed/rss_v2_0_msgs.xml" target=3D"_blank">groups.google.c=
om/<u></u>group/umlforum/feed/rss_v2_0_<u></u>msgs.xml</a>>; both of you=
r responses to MARKERPED showed up there and are visible in the new Google =
Groups view.<br>
</blockquote>
<br></div>
OK, thanks. At least they seem to be getting posted to the forum. I only us=
e the email connection and apparently Google has stopped echoing to the sen=
der. I guess I'll just have to BCC myself.<div><div>
<br>
<br>
-- <br>
Life is the only flaw in an otherwise perfect nonexistence<br>
=A0 -- Schopenhauer<br>
<br>
Rene Descartes went into a bar. The bartender asked if he would like a drin=
k. Descartes said, "I think not," and disappeared.<br>
<br>
H. S. Lahman<br>
<a href=3D"mailto:H.lah...@verizon.net" target=3D"_blank">H.lahman@verizon.=
net</a><br>
software blog: <a href=3D"http://pathfinderpeople.blogs.com/hslahman/index.=
html" target=3D"_blank">http://pathfinderpeople.blogs.<u></u>com/hslahman/i=
ndex.html</a><br>
<br>
-- <br>
You received this message because you are subscribed to the Google<br>
Groups "UML Forum" group.<br>
Public website: <a href=3D"http://www.umlforum.com" target=3D"_blank">www.u=
mlforum.com</a><br>
To post to this group, send email to <a href=3D"mailto:umlforum@googlegroup=
s.com" target=3D"_blank">umlforum@googlegroups.com</a><br>
To unsubscribe from this group, send email to<br>
<a href=3D"mailto:umlforum%2Bunsubscribe@googlegroups.com" target=3D"_blank=
">umlforum+unsubscribe@<u></u>googlegroups.com</a><br>
For more options, visit this group at<br>
<a href=3D"http://groups.google.com/group/umlforum?hl=3Den?hl=3Den" target=
=3D"_blank">http://groups.google.com/<u></u>group/umlforum?hl=3Den?hl=3Den<=
/a><br>
</div></div></blockquote></div><br></div>
</div></div></blockquote></div><br></div>
--f46d040716e194e6ba04bb8738e8--