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!
Views in relational algebra:
1. Basic expression contains either
a) A relation in the database.
b) A constant relation.
2. General expressions are madde out of smaller sub expressions using
a) σp(E1) select (p a predicate)
b) ∏s(E1) project (s a list of attributes)
c) Px(E1)rename (x a relation name)
d) E1∪E2 union
e) E1- E2 set difference
f) E1x x E2 cartesian product
What are the disadvantages of relational data ? Disadvantages • Performance - If the number of tables among that relationships to be established are large and the tables t
Differentiate between Key and superkey? Key and superkey - A key a single attribute or a combination of two or more attributes of an entity set in which is used to identify o
Code an Oracle Database trigger to enforce the constraint that an employee can never change his or her department.
Need for Client Server Computing- Client/Server (C/S) architecture includes running the application on multiple machines in which every machine with its component software tackles
What are the benefits of decomposing a system? The benefits of decomposing a system into subsystems are that after decomposition, each individual component become smaller and e
Compare the Nested-loop join and block-nested loop join Ans: Nested loop join - It is costly as worst case cost, no. of block accesses needed is n r * b s + b r where b
(a) Why did SAP introduce the extended star schema?
Question 1: (a) Explain the legal meaning of :- (i) Computer Service Person (ii) Data holding (b) Explain how the law ensures Data protection and Security. Qu
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
Q. State the Technique for converting a state diagram to code. i) Identify the major control path. Starting with first state, find the path from diagram that corresponds
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