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))
How can we Classify the operations on classes This step fundamentally means all three models functional, object and dynamic (studied in last section) must be combined so that
What are temporary tables? Temporary tables exist solely for a particular session or whose data persists for the duration of the transaction.
What is aggregate function? Briefly describe it? Aggregate functions are functions that take a collection of values as input and return a one value. SQL offers 5 built-in aggre
Explain Record Based Logical Models? Record-Based logical Models: Also define data at the conceptual and view levels. Unlike object-oriented models, are used to state overall
Write short notes on Schema diagram. A database schema along with primary key and foreign key dependencies can be depicted pictorially by schema diagram. Every relation appears
What is the use of group by clause? Group by clause is used to apply aggregate functions to a set of tuples. The attributes given in the group by clause are used to
define normalisation and functional dependency
How does the system cope up with a record crash when recovery is going on after the first crash? Ans: In a system the undo and redo operations are needed to be idempotent to c
In which form of relational database developer refers to a record? In a tuple form of relational database developer refers to a record.
What is an entity relationship model? The entity relationship model is a collection of basic objects known as entities and relationship between those objects. An
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