The Movies.com database consists of three relations: MOVIES(MID Category, EIDR), MOVIEVIEWERS(VID, AGE, ZIPCODE), and SUBSCRIPTIONS (MID VID
Question:
The "Movies.com" database consists of three relations: MOVIES(MID Category, EIDR), MOVIEVIEWERS(VID, AGE, ZIPCODE), and SUBSCRIPTIONS (MID VID DURATION). Underlined attributes represent keys for the respective relations. Relation SUBSCRIPTIONS has a key that consists of two attributes, MID and VID. Attributes MID and VID in SUBSCRIPTIONS are also foreign keys,w.r.t attribute MID in relation to MOVIES and attribute VID in relation to MOVIEVIEWERS. Attribute "DURATION" in relation to SUBSCRIPTION is always a strictly positive integer. The same applies to the attribute "age" in relation to MOVIEVIEWERS and the attribute "EIDR" in relation to MOVIES (We assume that the EIDR is composed of 4 integers).
The tables below show a plausible instance of the database:
With respect to the database schema presented above, provide an example of two distinct relational algebra expressions that are logically equivalent but syntactically different. Explain in your own words what "query logical equivalence" means.
Modern Systems Analysis And Design
ISBN: 9780134204925
8th Edition
Authors: Joseph Valacich, Joey George