Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
what is a recursive relationship give an example not used in the texta recursive relationship is a relationship among an entity and itself for
what is the archtetypeinstance patternthe archetypeinstance pattern happens when one entity tracks occurrences of another entity a common example is
what is a foreign key and what is it used fora foreign key is used to establish relationships between relations in the relational model technically a
what is sql and why is it importantsql stands for structured query language and is the most significant data processing language in use today it is
what is enterprise resource planning erp and what kind of a database is used in an erp applicationenterprise resource planning erp is an information
what are stand-alone proceduresprocedures that are not part of a package are called as stand-alone because they independently defined a good example
what are stored-procedures and what are the advantages of using themstored procedures are database objects that perform a user defined operation a
what is database triggera database trigger is a plsql block that can explained to automatically execute for insert update and delete statements
name the three major set of files on disk that compose a database in oraclethere are three main sets of files on disk that compose a database all the
what do you mean by correlated subquerysubqueries or nested queries are used to bring back a set of rows to be used by the parent query depending on
what is a phantom deadlock in distributed deadlock detection the delay in propagating local information might cause the deadlock detection algorithms
what do you mean by atomicity and aggregation atomicity either all actions are carried out or none are users should not have to worry about the
what is system catalog or catalog relation how is better known asa rdbms maintains a explanation of all the data that it contains information about
what are partial alternate artificial compound and natural keypartial key it is a set of attributes that can uniquely recognize weak entities and
what is functional dependency a functional dependency is shown by x y among two sets of attributes x and y that are subsets of r specifies a
what is normalizationit is a method of analysing the given relation schemas based on their functional dependencies fds and primary key to attain the
how does tuple-oriented relational calculus vary from domain-oriented relational calculusthe tuple-oriented calculus uses a tuple variables ie
what is dml data manipulation languagethis language that enable user to access or manipulate data as organised by appropriate data modelprocedural
what is data storagethe storage structures and access methods used by database system are specified by a set of explanation in a special type of ddl
what is object oriented model this model is based on collection of objects an object has values stored in instance variables with in the object an
what is e-r modelthis data model is based on real world that having of basic objects called entities and of relationship between these objects
what is a view how it is related to data independencea view might be thought of as a virtual table that is a table that does not really exist in its
what is system r what are its two major subsystemssystem r was intended and developed over a period of 1974-79 at ibm san jose research center it is
write the c program having class name studentinfo that is used to store the vu student information this class should store your vuid campus id name
question acompani datdbase needs to store information about employees identified by a social security numberwith salary and phone as attributes and