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
What is advantage of two-way association? Two-way association advantages are following: a) Independent of the classes. b) Useful for existing predefined classes that are
The functions of DBA ?
What is catalog in DBMS? Catalog - A relational DBMS maintains information about every table and index in which it contains. A catalog is a collection of special tables that st
The database will enable college administrators the ability to track students initial major. This will help college officials decide how best to prepare students for their goals an
Differance between procedural and non procedural DML? Procedural and non procedural DML Procedural DML exactly what data is require and how to obtain those data. Non procedural
Explain the Check Clause The CHECK clause is employed to at the end of a CREATE TABLE statement specify table constraints. This is known as table-based constraint because it ap
About Attribute inheritance
The natural join is equal to which product? The natural join is equal to Combination of projection and Cartesian product
a) Distinguish between ‘database' and ‘Database Management Systems (DBMS)'. b) List and briefly describe five potential benefits of the database approach compared to conventio
State The position of object at any moment is called state. An object can have many states depend upon time. After receiving some input instructions, the object can change its
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