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

Explain the Static or conservative Two Phase Locking: Static (or conservative) Two Phase Locking: In this type of scheme, all the data items are locked earlier than any opera

(1)     Insert into PERSON Violated constraint: - Key constraint Reason: - Primary key 1 already exists in PERSON. Dealing: - DBMS could ask the user to provide valid PER

Draw an Entity-Relationship model for the relational schema given in the Appendix. Show all the entities, relationships, relationship names, and attributes and also underline the

A relation instance indicates as r is a collection of tuples for a given relational schema at a exact point of time. A relation state r of the relation schema R (A 1 ,A 2 ,.....

Describe different steps of the object-oriented design process.  The broad steps of the object-oriented design process are: a. Define context and modes of use of the system

What are the reasons of bucket overflow? Explain any two methods for solving this problem. Ans:  It is general for file structures to be divided into equal-length partitions, k

What does Aggregation mean?

Benefits of using heuristics

in case of functional dependencies how we get the higher normal form.