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!
Example: -Show the employees whose job title is the similar as that of employee 7566 and salary is extra than the salary of employee 7788.
Let consider the given partial relation EMP. Let us make some sub-queries for them
EMPNO
ENAME
JOB
SAL
DEPTNO
7566
Nirmal
MANAGER
2975
10
7788
Kailash
ANALYST
3000
7839
Karuna
PRESIDENT
5000
20
7902
Ashwin
7905
Ashwini
4000
SELECT ENAME, JOB
FROM EMP
WHERE JOB = (SELECT JOB
WHERE EMPPNO = 7566)
AND SAL > (SELECT SAL
WHERE EMPPNO=7788);
Output: Job title for the employee 7566 occurs to be 'MANAGER')
Give the levels of data abstraction? There are three levels of Data Abstraction a) Physical level b) logical level c) view level
Question: Describe briefly the three parts of the Relational Model. (a) The term integrity refers to the accuracy or correctness of the data in the database. Define the fol
I need a professional to prepare a database to collect and store basic information. The information can be basic info such as contact details etc. One requirement i have is f
What are the types of storage devices? Primary storage Secondary storage Tertiary storage Volatile storage Nonvolatile storage
What is the full form of DDL? DDL is stand for Data Definition Language.
What is Information System?
What is equi join? Equi Join - It generates all the combinations of tuples from two relations which satisfy a join condition along with only equality comparison (=).
what is Nested relational model? Explain with examples.
To delete a particular column in a relation which command is used ? To delete a particular column in a relation ALTER command is used.
Data Handling and Research Methods: The dataset encompassing 130 participants contains several variables measuring detrimental health related behaviours referring to the use o
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