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!
Consider the relations City (city_name, state) Hotel (name, address) City_hotel (hotel_name, city_name, owner)
Answer the following queries in relational algebra(i) Find out the names and address of hotels in Agra.(ii) List the names of cities that have no hotel.(iii) List the names of the hotels owned through ‘Taj Group'.
Ans: (i) Π name, address ( σ city_name= ‘Agra' (Hotelname=city_name City_hotel))(ii) Π city_name (City) - Π city_name(City_hotel)(iii) Π hotel_name ( σ owner='Taj Group' (City_hotel))
One-way Associations When an association is traversed only in the one direction, then it is implemented as a pointer i.e.an attribute which contains an object reference. If mu
Depending upon the rules we have found, we can classify the locks into two types. Shared Lock: A transaction might be acquiring shared lock on a data item in order to read it
The State of NewYork certifies firefighters throughout state and keep track all of them, as well as of the state’s fire departments. Each fire department has unique department numb
what is stracture of dabms
projects?
List the data structures implemented by the storage manager. The storage manager executes the following data structure a) Data files b) Data dictionary c) indices
Explain weak and strong entity sets? Weak and Strong entity sets: A physically powerful entity set has a primary key. All tuples in the group are distinguishable through that k
Define granularity, hierarchy of granularity of locks & multiple granularity locking. Explain the modified two phase locking along with multiple granularity locking. Ans: The s
It is not possible to make an ABAP/4 program, which having only Subroutines. False. We can make ABAP/4 program, which having only Subroutines.
Give an example of enforcement in Typing. You can understand the idea of enforcement as it makes sure objects of dissimilar classes may not be interchanged as below: Exampl
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: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd