Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
explain weak and strong entity type weak and strong entity type an entity set which does not have a primary key is referred to as a weak entity set
write short notes on extension and intensionin any data model it is significant to distinguish among the description of the database and the database
explain several types of constraints that can be specified using create table command explain cascade and restrict clauses of drop schema
consider the relations empenoenameagebasicsalary workinenodno deptdnodnamecity express the following queries in sqli find names of employees who work
consider a table student stdid stdname dateofbirth percentmarks deptname write a qbe query to display names of computer science department students
differentiate between join and outer joinouter joins return all rows from at least one of the tables or views mentioned within the from clause as
consider the relations projectprojprojnamechiefarchitect employeeempempname assignedprojemp use relational algebra to express the subsequent queriesi
what do you understand by raid explain raid level 4 and level5raid - it is stands for redundant array of inexpensive disks as named by the inventor
what is hash file organization what are the causes of bucket overflow within a hash file organization what can be completed to decrease the
explain what is aggregationaggregation aggregation is an significant concept in database design whereas composite objects could be modelled during
define specialisation and generalization in briefspecialisation generalization generalization or specialization represents the is a relationship set
define identify relationshipidentifying relationship an identifying relationship means in which the child table cannot be uniquely recognize without
explain the terms primary key candidate key alternate key and secondary key in the given table identify every keystudentsidregno name cityprimary
what are the dbms languages briefly explain data definition language ddla database schema is specified through a set of definitions expressed
discuss the differences among the candidate keys and the primary key of a relation give instance to describe your answera candidate key is one that
what is d command work in the respect of qbed it is the command inside qbe to delete tuples from the
explain p command in the respect of qbep it is the command in which is used to print logically display the value of the attribute in
explain i command in qbe i it is the command in qbe that is used to insert tuple s into the
explain cnt in the respects of qbe cnt it is one of the aggregation commands given in qbe it is used to identify number of
how is the database organised in oracledatabase organized within oracle in terms of table and table holds attributes and valuesa database consists of
if one requires to access data using logical database the use of events is unavoidableyes if someone wants to access data using logical database then
is it mandatory to declare all the tables in report by the key word tables for all the tables that exist in the structure of ldb and are being
though all the abap4 dictionary structures that exists in the structure of the ldb being described in database program we are explaining the
what are the advantages of logical databases it offers a simple-to-use selection screens you can change the pre-generated selection screen to
for the relations answer the following queries in sqlstreet name location city house number streetname lives name housenumberi obtain the names of