Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Solved Assignments
Asked Questions
Answered Questions
explain everything you can tell from the followinga 00-01-00-01-13-fd-f4-c0-00-1e-33-92-ce-99b fe802c1e18af749b91c512c 20028b646e3a8b646e3ad
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
1 bob has been given the task of changing the ip address and enabling telnet access on a cisco 2950 enterprise switchthe current ip address is
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
consider the subsequent relation schemes project project projectname chiefarchitect employee emp empname assignedto project emp give
question 34 by experimentation work out the lowest snr under which 4 users can si- multaneously communicate without error via this system for
differentiate between logical database design and physical database design show how this separation leads to data independencebasislogical database
what is foreign keyforeign key - let there are two relations in tables r and s any candidate key of the relation r that is referred in the relation s
what is candidate keycandidate key - a candidate key of an entity set is a minimal superkey which uniquely identifies each row in the
what is primary keyprimary key - primary key is one of the candidate keys which uniquely identifies each row in the
explain five duties of database administrator 1 dba administers the three stages of the database and in consultation along with the whole user
what is disadvantages of dbms 1 cost of software and hardware and migration - a important disadvantage of the dbms system is cost2 reduced response
what are the advantages of dbms 1 centralized management and control - one of the major advantages of using a database system is in which the
what is a databasedatabase - basically in simple terms a database is a collection of inter related data andor information stored so which it is
which two files are used during operation of the dbmsdata dictionary and transaction log are two files used during operation of the
which data type can store unstructured dataraw data type can store unstructured