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')
Problem: You are given the following schema 1. Flights(flno, from, to, distance) 2. Aircraft(aid, flno, aname, cruisingRange) 3. Certified(eid, aid) 4. Employees(eid, ena
What are the responsibility of File manager? File Manager : Manager allocation of space on disk storage and the data structures used to represent within stored on disk. It is a
What are the benefits of OOA technology? Using OOA technology can produce many benefits, such as: i) Reusability of code ii) Productivity is gained through direct mappi
Define in which normalisation form if an attribute of a composite key is dependent on an attribute of other composite key. Ans: 3NF A relation is in 3 NF if an attribute of
Gaps in sequence values can happen when: - A rollback happens that is when a statement changes are not accepted. - When the system crashes - When a sequence i
Add generation capabilities and/or tailor the built-in functionality of generator. This enables you to produce "all" the test data for the MySQL tables you produced in the previous
Is it mandatory to declare all the tables in Report by the key word tables for all the tables that exist in the structure of LDB, and are being explained in the Database part of LD
construct an er diagram for a hospital with a set of patients and a set of medical doctors. associate with each patient a log of various test and examination conducted.convert er d
Introductory course and so does not require any fancy coding. I will provide a guidance document to help you in producing the solutions.
Set Difference If R1 and R2 are two union compatible relations or relations then result of R3 =R1- R2 is the relation that have only those tuples that are in R1 but not in R2.
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