Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
define signalit allows methods to respond to events triggered by themselves or by other processes each signal corresponds to an exacting event a
what is bankers algorithm bankers algorithm is a deadlock avoidance algorithm that is applicable to a resource-allocation system with multiple
define deadlock avoidance an alternative method for avoiding deadlocks is to needs additional information about how resources are to be requested
define deadlock preventiondeadlock prevention is a set of methods for ensuring that at least one of the four essential conditions like mutual
define data conversionhelpful to load data into temporary staging tables then can write sql code to do much of data processing sql code is simpler
write the motivations led to development of oo-dbms1 programmer frustration with rdbmss2 requirement for special
what are domain constraints a domain is a set of values that might be assigned to an attribute all
what is trigger triggers are statements that are executed automatically by the system as the side effect of a modification to the
what is the use of group by clause group by clause is used to apply aggregate functions to a set of tuples
write short notes on schema diagram a database schema along with primary key and foreign key dependencies can be depicted pictorially by
define query language a query is a statement requesting the retrieval of information the portion of dml that includes information retrieval is
write short notes on domain relational calculus the domain relational calculus uses domain variables that take on values from an attribute
write short notes on relational model the relational model uses a collection of tables to show both data and
define the terms i ddl ii dml ddl data base schema is specified by a set of definitions expressed by a special
explain the two types of participation constraint total the participation of an entity set e in a relationship set r is said to be total if each
define weak and strong entity sets weak entity set entity set that do not have key attribute of their
define single valued and multivalued attributes single valued attributes attributes with a single value for a particular entity are known as
what is an entity relationship model the entity relationship model is a collection of basic objects known
what is a data dictionary a data dictionary is a data structure which keeps meta data about the structure of the database ie the schema of the
what is storage manager a storage manager is a program module that gives the interface between the low
define the terms 1 physical schema 2 logical schema physical schema the physical schema explains the database design at the physical level
define instance and schema instance collection of data kept in the data base at a particular moment is
normal 0 false false false en-in x-none x-none microsoftinternetexplorer4
timestamps for read operationsif ts t lt w-timestamp q then the transaction t is trying to read a value of data item q which has already been
timestamp ordering protocola timestamp is a tag that can be attached to any transaction or any data item which indicates a specific time on which the