What is a recursive relationship, Database Management System

Question:

(a) Can a set of data requirements be correctly modelled by two or more different ER diagrams? Explain your answer. You may use a small example, if you think it will help your explanation.

(b) What is a recursive relationship? Give an example of a many to many recursive relationship.

This question refers to the Appendix where the relational schema for an online DVD rental system is defined.

(c) Express the following queries using relational algebra:

(i) Find all DVD titles with their certificate being ‘15' and their type name being ‘Drama'

(ii) Find names of all members and the titles of DVDs, which they have rented between 1st

May 2007 and 31st
May 2007

(iii) Find names of all the members who have rented any DVD with type name ‘Comedy' but not any DVD with Type name ‘Action'

Posted Date: 11/14/2013 6:23:56 AM | Location : United States







Related Discussions:- What is a recursive relationship, Assignment Help, Ask Question on What is a recursive relationship, Get Answer, Expert's Help, What is a recursive relationship Discussions

Write discussion on What is a recursive relationship
Your posts are moderated
Related Questions
how to construct labelled precedence graph for view serialiability.please explain insteps with one solved examples

In problems 1 - 4, you are given the columns of a table, and a set of functional dependencies.  Determine the normal form of this table.  Remember that the normal form is the HIGHE


What is the purpose of storage manager? The storage manager is responsible for the following a) Interaction with the file manager b) Translation of DML commands in to low

What are the difference between clustered and a non-clustered index? A clustered index is a special type of index that reorders the way records in the table are physically stor

For the relations answer the following queries in SQL Street (name, location, city) House (number, street_name) Lives (name, house_number) (i) Obtain the names of persons who liv

i need help with creating database system for a library


Multilevel Indexing Scheme Consider the indexing scheme where the address of the block is consider in the index for each record, for a little file, this index would be little a

Accessing information about permissions to all users- Object level permissions: With the use of data dictionary you can see the permissions to user. Let us get the table name fro