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!
Consider employee (e_no, e_name, e_salary, d_code), dept(d_code, d_name) and dependent (depndt_name, e_no, relation). Show the names of employees in purchase and accounts departments with at least one dependent.
SELECT e_name FROM employee, dependent, dept WHERE employee.d_code=dept.d_code AND employee.e_no=dependant.e_no AND d_name IN (‘ACCOUNTS', ‘PURCHASE') GROUP BY e_name HAVING COUNT (e_no)>=1
Illustrate about the advanced object design Advanced object design is a complex task. The objects discovered through analysis serve as a skeleton of design. The operations reco
Hot Backup: Some sites cannot terminate the database while creating a backup copy of the files. The cold backup is not a reliable option. So different kinds of backing up database
Different stages of DDLC ?
Explain the Dynamic Hashing Techniques There are two methods in it: extendible hashing - stores an access structure in addition to the file, and therefore is somewhat identica
What are the various forms of data transparency? a) fragmentation transparency b) replication transparency c) location transparency
usecase diagram,activity diagraM,SEQUENCE DIAGRAM
What are the failures of Controlling Events Between Objects Failure Unintentional termination of system. Several possible causes: failure of system hardware, o
CREATE TABLE prodtrans ( pno number (4) ptype char (1) CHECK (ptype in ('I','R','S')), qty number (5) FOREIGN KEY pno REFERENCES product (pno) ON DELETE CASCADE);
Before we talk about the relational model in more detail, let us first define some very basic terms used in this model. Tuple Every row in a table shows a record and is cal
Write A short note on temporary tables? Temporary Tables - Temporary tables exists solely for a particular session, or whose data persists for the duration of the transaction
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