Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
explain candidate keycandidate key - a candidate key is a minimal superkey that can be used to uniquely identify a tuple in the
what is key key - a single attribute or a combination of two or more attributes of an entity set which is used to recognize one or more instances
consider the following relational schema person ss name address car registrationnumber year model accident date driver carregno owns ss
describe application programming interfaceapplication programming interface - commercial sql implementations take one of the two primary techniques
explain view in rdbmsview - a view is a relation virtual rather than base and could be used in query expressions which is queries can be written by
explain what is rdbms rdbms - rdbms is a database management system dbms which stores data within the form of relations relational databases are
explain cursors in sqlcursors in sql - an object used to store the output of a query for row-through-row processing through the application programs
what is nested queries explain in detailsnested queries - a select query could have subquerys in it while a select query having another select query
explain the integrity constraints not null unique primary key with an example each is the combination not null primary key a valid combination
describe a technique for direct search explain how data is stored within a file so which direct searching can be performedfor a file of unordered
explain sorted file with advantages sorted file the sort utility shall perform one of the subsequent functions1sort lines of all the named files
explain heap file with advantagesheap file is an unordered set or a group of records stored on a set of pages this class gives basic support for
when are they useful justify with an examplethe temporary tables are commonly used to support specialized rollups or exact application processing
what are temporary tables temporary tables exist solely for a particular session or whose data persists for the duration of the
explain outer joinouter join - if there are any values in one table which do not have corresponding values in the other in an equi-join which will
explain natural joinnatural join - similar as equi-join except in which the join attributes having similar names are not involved in the resulting
what is equi joinequi join - it generates all the combinations of tuples from two relations which satisfy a join condition along with only equality
what is theta join explaintheta join - the theta join operation is an extension to the natural-join
define a view and a trigger construct a view for the above relations that have the information about suppliers and the elements they supply the view
consider the following relations s s sname status city sp s p qty p p pname color weight citygive an expression within sql for each of
what are the advantages of embedded query language give an example of an embedded sql queryembedded query language - sql could be implemented within
explain entity integrity and referential integrity rules within relational model show how these are realized in sqlentity integrity rule - no primary
define the five basic operators of relational algebrafive basic operators of relational algebra are1 union cupcupcupcup - selects tuples which are in
how does oracle act as odbc and give examples of front end uses with odbcodbc achieve portability at the level of the executable by introducing an
what is odbc odbc - open database connectivity which is also denoted by odbc enable the integration of sql along with a common-purpose programming