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!
Relational Algebra is a set of basic operations used to influence the data in relational model. These operations allow the user to specify basic retrieval request. The result of retrieval is a new relation, produced from one or more relations. These operations can be divided in two categories:
• Basic Set Operations
1) UNION
2) SET DIFFERENCE
3) INTERSECTION
4) CARTESIAN PRODUCT
• Relational Operations
1) JOIN
2) PROJECT
3) SELECT
4) DIVISION
Describe Parameteric end users? Parametric end users might be given update access, but are commonly not permitted to change the structure of data.
Shared lock or Read Lock It is requested by a transaction that needs to just read the value of data item. A shared lock on a data item does not permit an exclusive lock
Which database level is closest to the users? External database level is closest to the users.
Give a sample of the Dynamic Model. The sample of dynamic model is given below: Dynamic model for the car: Brake and Accelerator Brake or Applies Accelerator
What is difference among mysql_connect and mysql_pconnect? Mysql_connect() opens a new connection to the database while mysql_pconnect() opens persistent connection to the data
1. Determine that the Checkpoints are a part of Ans: Checkpoints are a part of Recovery measures
What is the way a particular application views the data from the database that the application uses? Sub schema is the way a particular application views the data from the data
Question: This form represents one of a number used for each sailing of a range of boats. A passenger may go on many sailings and will have the same passenger number for each.
What are composite attributes? Composite attributes can be separated in to sub parts.
Illustrate the statement 'Projection operation distributes over the union operation'. Give an example. Ans: Π L (E 1 ∪ E 2 ) = (Π L (E 1 )) ∪ (Π L (E 2 )) This says th
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