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!
Explain the difference between using functions along with and without grouping attributes in relational algebra. Give examples.
Ans: Group functions are used to group data of similar type. GAMMA = grouping and aggregation Applying GAMMAL(R)• Group R according to all the grouping attributes on list L.1. That is: form one group for each distinct list of values for those attributes in R.• Within each group, compute AGG(A ) for each aggregation on list L.• Result has one tuple for each group:1. The grouping attributes and2. Their group's aggregations. Example: Grouping /Aggregation R = ( A B C ) 1 2 3 4 5 6 1 2 5 GAMMAA,B,AVG(C) (R) = ? First, group R by A and B : A B C 1 2 3 1 2 5 4 5 6 Then, average C within groups: A B AVG(C) 1 2 4 4 5 6
#question. acompani datdbase needs to store information about employees (identified by a social security number,with salary and phone as attributes) and departments (identified by
What is the meaning of Recovery? In deferred update methods, if a transaction fails before arriving its commit point, it will not have altered the database in any way, so UNDO
Why DML is used for? DML is used to Manipulation and processing of database. DML is provided for manipulation & processing of database. (Data stored in the database is processed
A database for the Service and Maintenance (SM) section of a Computer sales and service Company has to be developed. SM gives after sales service to customers. SM branch has a numb
Define Deadlock prevention These protocols make sure that the system will never enter a deadlock state. There are two methods to deadlock prevention. One approach makes sure t
Explain the Attribute inheritance Ans: Throughout the rendering of the objects in a view, attribute sets of objects higher in the view hierarchy are inherited via objects below
What is inheritance? Inheritance is an object orientation concept that allows reusability of code / design. Basic sense of inheritance is that if one class is predefined than a
management information system based on functional organisation
folding method and mid square method using visual basic
Question : (a) Database Management Systems (DBMS) is the foundation of business intelligence. Explain the following concepts related to DBMS: (i) Entity Relationship Diagr
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