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!
Aggregate functions
Example: Find the total number of employees.
SELECT COUNT (*) FROM EMP;
Example: //Find the minimum, maximum and average salaries of employees of department D1//.
SELECT MIN(SAL), MAX (SAL), AVG(SAL) FROM EMP
WHERE DEPTNO = 'D1' ;
Describe briefly models which define the operations on classes. The three models which are used to define operations on classes are as: Object Model = data dictionary + Obje
Winfield is a small city with a population of 22,000 with buses serves three routes in Winfield and neighboring areas. As the city’s IT director, you have been asked to set up an i
what are the main characteristics of database
What is substitutability? Any method of a class-say A can equally well be adjured with any object belonging to any subclasses B of A. This characteristic leads to code reuse, a
Which language used in application programs to request data from the DBMS is referred? Language which is used in application program is DML to request data from the DBMS is ref
What is Object Oriented model? This model is based on collection of objects. An object has values stored in instance variables with in the object. An object also having bodies
A collection of a same kind of entities is known as an Entity Set or entity type. Example: For the COLLEGE database defines earlier objects of concern are Students, Faculty,
Column Constraints: NOT NULL, UNIQUE, CHECK, PRIMARY KEY, DEFAULT, REFERENCES, On delete Cascade : Using this key whenever a parent row is removed in a referenced
External failure : A failure can also result because of an external cause, such as earthquakes, fire, floods, etc. The database must be duly backed up to avoid troubles occurring d
Normal 0 false false false EN-US X-NONE X-NONE
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