Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
what are the several kinds of the update operations on relations also explain the constraints on these update operation give instance in support of
express the subsequent query in sql assumes which the data is stored within employee table with relevant fieldsi display name job salary and hire
what are the constituents of file also elaborates all the possible file operationsa file is organised logically as sequence of record these records
what is bucket overflow and how bucket overflow is handled through over flow chaining or closed hashing ans bucket unit of storage holding records
what is data independencedata independence techniques which permit data to be changed without affecting the applications in which procedure it there
explain record based logical modelsrecord-based logical models also define data at the conceptual and view levels unlike object-oriented models are
what is an e-r model draw an e-r diagram for the company database with following descriptionsthe company is organized within departments each
describes the several relationship constraints through giving suitable exampleconstraints on relationships there are two kinds of constraints on
how many types of users works on database users are differentiated through the way they expect to interact along with the systemi application
what is dbms and what are functions of dbms dbms consist of collection of integrated data and set of program to admission those datathe functions
what is oracle process explain any four processes started by oracleoracle process is as follows smon the system monitor carries out a crash recovery
write a short note on built in function in qbebuilt in function in qbe qbe involves various built in functions like avg maxminsum and cnt we must
we define a view in sql through using the create view command to describe a view we must provide the view a name and must state the query in which
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