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))
There are two major types of fragmentation: Horizontal& Vertical. Horizontal fragments, as the name suggests are subsets of tuples and vertical fragments are subsets of attributes
Benefits of Hashed file Organisation 1. Insertion or search on hash-key is quick. 2. Best if equality search is required on hash-key. Drawbacks of Hashed file
Which two tools are used to administer users for Active Directory?
Create centralized relational database using Top down method- Construction of Logical Model: Translation EERD into Relational Schema: Use the 8 steps algorithm of converting EERD
In a job interview with a branch manager of a bank that operates in multiple Canadian provinces and the Yukon, you learn that all of the information is captured in real time in a s
Define lock? Lock is the most common used to execute the requirement is to permit a transaction to access a data item only if it is currently holding a lock on that item.
draw er diagram using entities crop,employee,department,plot,cultivation plan,machinery,seed,fertilizer
Define upgrade and downgrade? It gives a mechanism for conversion from shared lock to exclusive lock is called as upgrade. It gives a mechanism for conversion from exclusive
discuss the array implementation of a stack.
Describe DROP TABLE command of SQL along with both the options - CASCADE and RESTRICT. DROP TABLE command - This command drops the specified table. Dropping a table also dro
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