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 the main advantage of the object model? What are its different components? The object model focuses on the logical data structures. Each object model comprises of many
Compare the Nested-loop join and block-nested loop join Ans: Nested loop join - It is costly as worst case cost, no. of block accesses needed is n r * b s + b r where b
coventions for displaying an ER schema as ER diagram
Let us first describe the term relationships. What Are Relationships? A relationship can be defined as: A set of associations or connection, or A rule for communic
Explain degree of relation? Degree of a Relation - The degree or arity of a relation is the number of attributes n of its relation schema.
Hi is anyone well versed in accounting information systems available now to help me work through an important assignment due tomorrow at noon?
Northwind Pty Ltd sells a variety of food products throughout the world. They want to use the reporting features of SAP''s Business Information Warehouse to better understand thei
Control Files : The redo and control files logs support the rest of the architecture. Every database must have at least one control file, although you have more than one to guard
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE? HAVING CLAUSE - HAVING CLAUSE is used only with SELECT statement. - It is normally used in a GROUP BY
Type of views : Simple views and Difficult Views Feature Simple Views Complex Views Number of tables One
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