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 » Wed Oct 17, 2012 2:46 pm

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 » Sun Aug 18, 2013 11:36 am

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 » Tue Aug 20, 2013 1:57 pm

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