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.
Presentations and example database
-
- Posts: 76
- Joined: Sat Aug 18, 2012 2:13 pm
Re: Presentations and example database
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.
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
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