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!
Explain Data Dictionary in short?
read-set(T) : Each data items that are read by a transaction T Timestamps : for all transaction T, the start-time and the end time are reserved for all the three phases.
Which database object does not physically exist? A view database object does not physically exist.
Aggregation : One limitation of the E-R diagram is that they do not permit representation of relationships between relationships. In such a case the relationship along with its ent
In a relational model how relations are termed? In a relational model, relations are termed as tables. (The term ‘relation’ is the technical name of the ‘table’ in RDBMS)
limitations and benefits in database tecknowlagy
Data Control The data control mostly refers to commands that permit system and data privileges to be passed to several users. These commands are usually available to database admi
Consider the join of a relation R with relation S. If R has m tuples and S has n tuples, then the maximum size of join is: If R has m tuples and S has n tuples then maximum siz
Explain Growing Phase of locking Growing Phase: In this phase the transaction can only obtain locks, but cannot release any lock. The transaction enters the growing phase as so
A relation instance indicates as r is a collection of tuples for a given relational schema at a exact point of time. A relation state r of the relation schema R (A 1 ,A 2 ,.....
What are composite objects? Objects that have other objects are known as complex objects or composite objects.
A data dictionary subsystem keeps way of the definitions of all data items in database. This includes elementary-level data items, fields, group and record-level data structures, as well as relational tables. It keeps way of relationships that is between varieties of data structures. It maintains indexes that are used to access data speedily. It also keeps track of screen and report format definitions that might be used by a range of application programs.
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