What is a recursive relationship, Database Management System


(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
Consider the relations: PROJECT(proj#,proj_name,chief_architect) EMPLOYEE(emp#,emp_name) ASSIGNED(proj#,emp#) Use relational algebra to express the subsequent queries: (i) Get

basic structure of xml

what is object-identity

compare the features of oracle RDBMS with MySQL and Microsoft SQL server

Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pictori

Update Anomaly : This anomaly is occurred due to data redundancy. Redundant information makes updates more complex since, for example, varying the name of the instructor of MCS-014

Give two profit of Reuse of Code. Reusing the implementation . Place existing class directly inside a new class. The new class can be made up of any number and type of the oth

Need an expert in ER database theoretical and modeling database system Project Description: Need an expert in ER database theoretical and modeling database systems? Skills