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!
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 aggregate functions:
a) Average: avg
b) Minimum:min
c) Maximum: max
d) Total:sum
e) Count:count
Average: avg
Select avg (balance)
From account
Where branch-name='perryridge'
Count :count
Select branch-name,count(distinct customer-name)
From depositior,account
Where depositor.account-number=account.account-number
groupby branch-name
what is correlation in nested query
What are ways of finding out either an update is required or not for derived attributes? The ways to find out an update is required or, not are as: Explicit update
#question. Draw a picture of a moving source and the waves surrounding it according to what you observed in this experiment. How does the spacing of the wave-fronts in front of the
What is called mirroring? The simplest approach to introducing redundancy is to duplicate each disk. This method is called mirroring or shadowing.
Explain how the associations are implemented as classes. A general approach in this case is to transform an association class into a simple class linked to two original classes
Give short note on the following terms:Dirty pages and ETL a.) Dirty pages. These are buffer pages which comprise modifications which haven't been written to disk. b.
Lossless-Join Decomposition Let us show an intuitive decomposition of a relation. We require a better basis for deciding decompositions since intuition may not always be r
(1) Insert into PERSON Violated constraint: - Key constraint Reason: - Primary key 1 already exists in PERSON. Dealing: - DBMS could ask the user to provide valid PER
Give the forms of triggers? The triggering event can be insert or delete. For updated the trigger can state columns. The referencing old row as clause The referencing
What is Interaction Diagram An interaction diagram shows an interaction, comprises of a set of objects and their relationships including the messages that may be dispatched be
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