Arial
Times New Roman
Wingdings
Monotype Sorts
Symbol
\\HK\Apple LaserWriter Select 3
PRIV
winspool
\\HK\Apple LaserWriter Select 360
LPT1:
obat 4.0\PDF Out
Relationships
Tracking text is used to annotate the Relationship shape.
`9Copyright © 1998 Visio Corporation. All rights reserved.
10 = Tracking Text
DB Engineer /CMD=1003 PinX PinY User.OldPinX User.OldPinY
PinX guard(pntx(par(pnt(Sheet. !Controls.X ,Sheet. !Controls.Y
PinY guard(pnty(par(pnt(Sheet. !Controls.X ,Sheet. !Controls.Y
Shape ID to Track `BEnter the sheet id of the shape that you want this text to follow.
Control Row to Track `wIdentify the 'Tracked' shpe's control point by entering it's row number within the controls section of the shape sheet.
0 = IDEF1X; 2 = Relational
`SOverrides the relationship notation specifed by the IDEF1X or Relational notations.
`)Set to hide all relationships on the page
Set to hide relationship text.
`*Set to hide PK, FK, and Index annotations.
`'Set to hide the PK section of Entities.
`.Set to hide the Datatype section for Entities.
`\Set to hide the vertical lines seperating the Annotation and Datatype sections for Entities.
`jSet to hide the horizontal line seperating the Primary Key section from the other columns within Entities.
Use the Relationship connector to define a foreign key between two tables.
Vis_D200.chm!#20000 `7Copyright 1999 Visio Corporation. All rights reserved.
IDEF1X Notation
Crow's Foot Notation
Relational Notation
Relationship (Foreign Key)
`%Unique identifier used by the add-on.
`BSet to indicate the relationship is an 'Identifying Relationship'.
`C25=exactly one, 28=one or more, 29=zero one or more, 30=zero or one
`-Set to indicate the relationship is optional.
`RSet to override Database | Document | Options locally for this relationship shape.
`NSet to allow free-form editing (manual edits are not maintained in the model.)
User.DBNotation `7This formula conditionally sets the DBNotation setting.
`3Calculates a reference point for Relationship text.
User.CrowsFoot `<This formula conditionally sets the CrowsFoot notation flag.
Shape's version.
`"reference to associated text shape
Q(-DT Q(-DT
`'Locate referencial integrity text here.
Locate cardinality text here.
Database Properties... `0Edit the model properties for this relationship. DB Engineer /CMD=1001
Relational Notation `4Display this relationship using Relational notation. User.CrowsFoot User.Override user.dbnotation
IDEF1X Notation `0Display this relationship using IDEF1X notation. User.CrowsFoot User.Override user.dbnotation
Crow's Foot Notation `5Display this relationship using Crow's Foot symbols. User.CrowsFoot User.Override
Lock Text Edit Toggel Lock Text Edit LockTextEdit Guard(0) LockTextEdit Guard(1)
Lock Delete Toggel Lock Delete LockDelete Guard(0) LockDelete Guard(1)
Database Model master stores embedded model information.
VUUUU
@VUUUU
hdi'O
%DocTitleLong
%PageDesc
%Date %Time
Page %PageNo of %PageCount
ZUI}
ZUIQO
G[QO
is partly identified by
kursid
partly identifies
is identified by
matr
identifies
CMandatoryConstraint
matrnr
gebdat
is of
bemerkung
semester
anzstudenten
CObjTypeM
akzeptiert
CRole
CPredicate
CElemArrayOfCells
CElemCell
anmeldung
mci2
user
userid
CConstraintList
CUCIndexConstraint
CRoleArray
gruppenname
team
regtime
vordi
vordiplom
prax
praxissem
kurse
dozentkuerzel
studiengang
zeitraum
kurs
name
studenten
email
INTEGER
vorname
teams
groesse
gruppen
maxanz
zeit
acce
CTimeStamp
Date of last Validation
time
CLogicalKey
ein Student hat sich angemeldet
melden sich an
Tabelle wird vom Dozenten angelegt und verwaltet.
Das Attribut "kursid" ist ein K
rzel, das aus den beschreibenden Attributen "name", "zeitraum" und "studiengang" konstruiert wird. Beispiel: "MCI2P-SS2002-WI"
Das Fremdschl
ssel-Attribut "kursid" ist ein K
rzel, das aus den beschreibenden Attributen der Tabelle "kurse" konstruiert wird. Beispiel: "MCI2P-SS2002-WI"
CMappingGroup
Ein Eintrag in dieser Tabelle bedeutet, dass sich ein Student, der sich durch Matrikelnummer und Geburtsdatum identifizioert hat, f
r einen Kurs angemeldet hat.
Die Zuordnung zu einer Gruppe kann sp
ter erfolgen. Die GruppenId geh
rt daher nicht zum Primary Key.
Bei der Verkn
pfung der Tabelle "anmeldung" zu den Tabellen "kurse", "gruppen" und "teams" ist folgendes zu beachten:
1. Beim ersten Eintrag in die Tabelle "anmeldung" muss der Kurs gew
hlt werden.
2. Danach muss eine Gruppe ausgw
3. Danach muss ein Team ausgew
CRolePath
CAggregate
CMappingNodeArray
CAggregateInst
CMappingNodeList
zum Kurs anmelden
CForeignKey
DIn dieser Tabelle werden die Stammdaten eines Studenten gespeichert.
arbeiten zusammen
haben
tragen sich ein
waehlen aus
CMapCode
db1.txt
'D:\doc\mci2\+ws0203\praktikum\DB\db.txt
Logical Model Document
Visio 20
should
through
throughout
till
toward
under
underneath
until
upon
value
were
will
with
within
would
could
despite
down
during
except
identified
about
above
across
after
against
along
around
before
behind
below
beneath
beside
besides
beyond
concerning
contained
contains
excepting
identify
inside
into
like
might
near
number
onto
outside
over
regarding
round
shall
since
string
Entities Entities
0 = IDEF1X, 2 = Relational
`@Set to hide the PK seperator lines in the Entities on this page.
`;Set to hide the Tabstop lines in the Entities on this page.
Use the Entity shape to represent a table in your database schema.
Entity
`-Identifies the shape's version to the add-on.
Set for dependent tables.
`KSet to allow free-from edits (manual edits are not maintained in the model)
`LSet if this shape's Database | Document | Options have have local overrides.
User.DBNotation `*Conditionally sets the DBNotation setting.
Database Properties... `2Edit the database model properties for this table. DB Engineer /CMD=1001
Show Related Tables `0Connect this table to all of its related tables. DB Engineer /CMD=1002
width of this shape's text
height of this shape's text
`*Subshape id within the Entity group shape.
Edit Table Name... Edit the table's name
`*Subshape ID within the Entity group shape.
`9specifies the number of columns in the tables primary key
`HSet to hide the horizontal line seperating the PK columns from the rest.
`&Set to hide the 1st vertical tab line.
`&Set to hide the 2nd vertical tab line.
`*Indicates the number of lines in the text.
Edit Column Text... Edit the table's column text.
Show Lines `<Set to display lines seperating PK's, Annotations, and Types User.DBHidePKSeperatorLine User.DBHideTabLine1 User.DBHideTabLine2
Categories
Use the Parent to category connector to connect a category shape to its parent table.
Parent Category Connector
`LSet to allow free form edits (manual edits are not maintained in the model.)
Shape's version number.
Database Properties... `4Edit the model properties of the connected category. DB Engineer /CMD=1001
C:\Programme\Visio\Solutions\Database\Entity Relationship.vss
C:\Programme\Visio\Solutions\Database\Object Relational.vss
Table Inheritance Table Inheritance
Composite Types
Type Inheritance
`$Set to hide category discriminators.
`:Set to hide PK, FK, and Index annotations within Entities.
`0Set to Hide Primary Key section within Entities.
`.Set to hide Datatypes section within Entities.
`bSet to hide the vertical lines that seperate the Annotation and Datatype sections within Entities.
`bSet to hide the horizontal line that seperates the PK section from the other columns of an Entity.
`&{21F2C86A-9239-4C6B-9FC5-468FFA20B197}
Database Properties...
Show Related Tables
`&{31827B19-9424-43FC-92C5-2582344EA7D9}
`&{05D2F5C7-E825-48E5-A050-52A9DF5A5549}
`&{5212270F-18F2-4959-BD9E-5564B7D61153}
`&{0721C98F-5C5B-4FD6-99D7-047EB120475B}
?Aud
`&{72E40B6C-78C9-4967-BD25-5E1BBC162F13}
`&{68BABC77-6964-4F27-8BFF-D6AC9DED67EA}
`&{E1007E48-4C04-44A9-B78E-CFD89F01AA37}
`&{C122DF9A-F534-430E-A279-6D63C9B8CA78}
`&{D80EC672-92EB-401C-815C-F4B540935F33}
P4-DT
`&{B34FC494-AB42-4730-8531-984ACE4B9968}
Guide
Gesture Format
Connector
Dynamic Connector
DBNotation
DBCrowsFoot
DBHideRelationships
DBHideRelationshipText
DBHideAnnotations
DBHidePKRow
White line
DBHideTypes
DBHideVerticalLines
DBHideHorizontalLine
DBShapeType
RefShapeGuid
Identifying
DBCardinality
CrowsFoot
Optional
Override
ManualEdits
OverrideDBNotation
EndAngle
OverrideCrowsFoot
BeginAngle
RITextRefGuid
Arial centered
Arial top left
Arial top
Times centered
Times top
Times top left
CardTextRefGuid
Tracking Text
DBEventTrigger
OldPinX
OldPinY
Hide
SetPinX
SetPinY
RefSheetID
RefControl
Watermark Title
Database Model
VisioExtendedData1
DBShapeVersion
Visio Extended Data
DBDependent
Width
Height
SubShapeID
PKCount
DBHidePKSeperatorLine
DBHideTabLine1
DBHideTabLine2
LineCount
Relationship
DBHideDiscriminator
Parent to category
ER-Diagramm
ER-Source-Diagramm
DB Engineer
/CMD=1 /MODEL=2
ER_Sourc
e_Model
9std
ole>
\WINNT\S
ystem32\
STDOLE2.
TLB#
tomation#
Forms>
DD452EE1
608C4D0B
DFM20.
DLL#Micr@osoft
\ Object
Library
21DF-7EE
E-27DA17`3CDBB@
OKUME~1\
hk\LOKAL
Temp\VB
R.exd
ISXDATA@FH>
FE9117F6
D1-B7F5@K
60081C26 8D}#1E
ogramme\
Visio\So
4DDB-994
4B5AC
b}Thi
sDocumen
uQ@ne
VisioExtendedData2, 268293, 1, VISXDATALib, VisioExtendedData
Attribut
e VB_Nam
e = "Thi
|Global
Spac
dCreat
Pred
ecla
BExpo
Templ
ateDeriv
Bustomi
2Contr
Visio
Extended
VISXDATA8Lib
Win16
Win32
VBA6
ER_Source_Model;
stdole
MSFormsC
VISXDATALibY
ThisDocument<
_Evaluate
VisioExtendedData23
Documentj
EngineerF
_B_var_Engineer
_B_var_DB
ID="{645E11EC-E877-11D2-BC81-006008BF0962}"
Document=ThisDocument/&H00000000
Name="ER_Source_Model"
HelpContextID="0"
VersionCompatible32="393222000"
CMG="FFFD4D3175511755175517551755"
DPB="9D9F2FCF536C546C546C"
GC="3B39897526762676D9"
[Host Extender Info]
&H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000
&H00000002={000D0D06-0000-0000-C000-000000000046};Visio2000;&H00000000
[Workspace]
ThisDocument=0, 0, 0, 0, C
ThisDocument