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')
Domain Constraints Domain constraints are primarily formed for defining the logically correct values for an attribute of a relation. The relation allows attributes of a relatio
Illustrate the term- Abstracting Out Common Behaviour Inheritance is not every time recognised during analysis phase of development, thus it is necessary to re-evaluate object
Log based recovery: Let us first describe the term transaction log in the context of DBMS. A transaction log is a record in DBMS that remains track of all the transactions of a dat
Give detail description on Transactions. - Using transactions we can group all SQL commands into a single unit. - Transaction begins with some task and finishes only when a
Find out the names and company names of all employees sorted in ascending order of company name and descending order of employee names of by which company. SELECT EMPLOYEE_NAME,
What is association? Give an example of association Association is used for establishing relationships among classes. Association describe links among/between classes. For exa
Question: (a) Prepare an ERD for the scenario given below. (b) Convert the ER diagram produced in (a) above into its physical design. You have to choose an appropriate Pri
Explain current page table and shadow page table. The key idea behind the shadow paging method is to maintain two page tables during the life of the transaction: the current pa
State the terms Designing the database and Normalization Designing the database: Out of the ERD we have formed, it is very easy to verify the tables, the attributes which the
An ideal data dictionary should have everything a DBA wants to know about the database. 1 Conceptual, External, and internal database descriptions. 2. Descriptions of attr
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