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 reasons having variable length records
Sequences Sequences: Automatically produce unique numbers Are sharable Are typically used to make a primary key value Replace application code Speed up t
Explain Deadlock detection and recovery Deadlock Detection - A deadlock is said to take place when there is a circular chain of transaction, every waiting for the release of a
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
Define Timestamp ordering Ans In timestamp-based method, a serial order is made among the concurrent transaction by assigning to every transaction a unique nondecreasing number
Determine the Other System Design Issue How to realise subsystems; through hardware or software? How is object model mapped on chosen hardware software? Mapping
Differentiate between logical database design and physical database design. Show how this separation leads to data independence? Basis Logical Databas
What are the states of transaction? The states of transaction are:- a) Active b) Partially committed c) Failed d) Aborted e )Committed f) Terminated
1) Information about a bank is about customers and their account. Customer has a name, address which consists of house number, area and city, and one or more phone numbers. Ac
List two restrictions that are applied on the modification (updation, insertion or deletion) of base tables through view. Ans: The two restrictions are: 1. If a view
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