Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
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'
Question: In relation to distributed database answer the following questions: (i) Give a brief definition of distributed database. Support your answer with an appropriate di
Indexed (Indexed Sequential) File Organisation It organises the file like a big dictionary, i.e., records are kept in order of the key but an index is stored which also allows
Question : Object-Oriented Database (OODM) is defined as a logical data model that captures the semantics of objects supported in object-oriented programming. An Object-Oriente
Order by clause By using this rows can be sorted It is used in the last portion of select statement By default it gets ascending order DESC: is used
Question: In a multi-user database environment, locking mechanisms can be used to solve the three basic problems of concurrency. On the other hand, however, locking may also le
Failure Controlling Methods: Failures can be handled using different recovery methods that are talk about later in the unit. But the first question is doing we really require recov
Illustrate the collaboration and relationship diagram A collaboration is the society of interfaces, classes and other elements which work together to provide some cooperative b
Describe sequential file organization. Explain the rules for (i) Inserting a new record. (ii) Deleting an existing record. Ans:A sequential f
explain normalization,and give the examples 1NF,2NF,3NF,BCNF.AND FUNCTIONAL DEPANDENACY AND DECOMPOSITION TECHNIQUES.
What is OOM? Object oriented modeling is an approach by which modeling of systems is done by visualizing the system based on real world concepts. Object oriented modeling does
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd