Kirill Simonov avatar Kirill Simonov committed 13ac23e

Updated tutorial to match schema changes.

Comments (0)

Files changed (2)

doc/dia/administrative-directory-schema.tex

     \end{columns}
 };
 
-\node[table] (school) [right=3 of department.south east, anchor=south west]
+\node[table] (school) [right=3 of department]
 {
     School
     \nodepart{second}
     \begin{columns}
         code                & PK        \\
         name                & NN,UK     \\
+        campus              &           \\
     \end{columns}
 };
 
 \coordinate (department/school)
     at ($ (department.text split east)!.5!(department.second split east) $);
 \coordinate (school/department/l)
-    at (department/school -| school.second west);
+    at ($ (school.text split west)!.167!(school.second split west) $);
 
 \coordinate (course/department)
     at ($ (course.text split west)!.1!(course.second split west) $);
 \coordinate (program/school) at
     ($ (program.text split east)!.1!(program.second split east) $);
 \coordinate (school/code/r)
-    at ($ (school.text split east)!.25!(school.second split east) $);
+    at ($ (school.text split east)!.167!(school.second split east) $);
 
 \coordinate (program/part of)
     at ($ (program.text split west)!.9!(program.second split west) $);
 
 \draw[o->]
     (department/school)
-    -- node[relation, below]
+    -- node[relation, below, near start, anchor=north west]
         {departments may belong to at most one school}
+    +(1.5,0)
+    |-
     (school/department/l);
 
 \draw[*->]
 
 __ http://demo.htsql.org/school
 
- ====  =============================
- code  name
- ====  =============================
- art   School of Art and Design
- bus   School of Business
- edu   College of Education
- egn   School of Engineering
- la    School of Arts and Humanities
- mus   School of Music & Dance
- ns    School of Natural Sciences
+ ====  ============================= ======
+ code  name                          campus
+ ====  ============================= ======
+ art   School of Art and Design      old
+ bus   School of Business            south
+ edu   College of Education          old
+ egn   School of Engineering         north
+ la    School of Arts and Humanities old
+ mus   School of Music & Dance       south
+ ns    School of Natural Sciences    old
  ph    Public Honorariums
  sc    School of Continuing Studies
- ====  =============================
+ ====  ============================= ======
 
 Scalar expressions, including arithmetic and boolean operations, can be
 written directly:
Tip: Filter by directory path e.g. /media app.js to search for public/media/app.js.
Tip: Use camelCasing e.g. ProjME to search for ProjectModifiedEvent.java.
Tip: Filter by extension type e.g. /repo .js to search for all .js files in the /repo directory.
Tip: Separate your search with spaces e.g. /ssh pom.xml to search for src/ssh/pom.xml.
Tip: Use ↑ and ↓ arrow keys to navigate and return to view the file.
Tip: You can also navigate files with Ctrl+j (next) and Ctrl+k (previous) and view the file with Ctrl+o.
Tip: You can also navigate files with Alt+j (next) and Alt+k (previous) and view the file with Alt+o.