Presentations and example database

This forum is for discussing the development of Rel examples and sample applications.
Post Reply
uyar
Posts: 3
Joined: Thu Aug 23, 2012 5:35 pm

Presentations and example database

Post by uyar »

For my "Database Management Systems" course at the Istanbul Technical University, Computer Engineering Department, I have incorporated Tutorial D into my presentations. The presentations are available on SlideShare:
http://www.slideshare.net/uyar/database ... onal-model
http://www.slideshare.net/uyar/database ... al-algebra
The sample database used in the presentations is also available:
http://ninova.itu.edu.tr/en/courses/fac ... ar?g276513
Any corrections and suggestions would be highly appreciated.
Chris Walton
Posts: 76
Joined: Sat Aug 18, 2012 2:13 pm

Re: Presentations and example database

Post by Chris Walton »

Syntax error in:
CONSTRAINT MOVIE_FKEY_DIRECTOR
MOVIE { DIRECTOR# } RENAME (DIRECTOR# AS PERSON#) <= PERSON { PERSON# };
CONSTRAINT CASTING_FKEY_MOVIE CASTING { MOVIE# } <= MOVIE { MOVIE# };
CONSTRAINT CASTING_FKEY_ACTOR
CASTING { ACTOR# } RENAME (ACTOR# AS PERSON#) <= PERSON { PERSON# };
should be (I think):
CONSTRAINT MOVIE_FKEY_DIRECTOR
MOVIE { DIRECTOR# } RENAME {DIRECTOR# AS PERSON#} <= PERSON { PERSON# };
CONSTRAINT CASTING_FKEY_MOVIE CASTING { MOVIE# } <= MOVIE { MOVIE# };
CONSTRAINT CASTING_FKEY_ACTOR
CASTING { ACTOR# } RENAME {ACTOR# AS PERSON#} <= PERSON { PERSON# };

As written, your script does not compile.
Dave
Site Admin
Posts: 368
Joined: Sun Nov 27, 2005 7:19 pm

Re: Presentations and example database

Post by Dave »

This is due syntax changes (as a result of syntax changes in Tutorial D) introduced in version 1.0.10. See the "Rel Version 1.0.10+ Syntax" document under Help at http://dbappbuilder.sourceforge.net
Post Reply