Page 1 of 1

Presentations and example database

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

Re: Presentations and example database

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

Re: Presentations and example database

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