Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
describe drop table command of sql along with both the options - cascade and restrict drop table command - this command drops the specified table
given the following relations vehicle regno make colour personeno name address ownereno regno write expressions in the relational algebra to answer
given the following relationstrain name start destticket pnrno start dest fare passenger name address pnrno write sql expressions for the following
define a relation relation - a relations is a named two-dimensional table of data mathematically a relation can be described as a subset of the
differance between ddl and sdlddl and sdl - the data definition language ddl is used through dba and database designers to describe internal schema
what is conceptual schemaconceptual schema - conceptual schema elaborates the structure of the overall database for a community of users it hides the
what is catalog in dbmscatalog - a relational dbms maintains information about every table and index in which it contains a catalog is a collection
explain degree of relationdegree of a relation - the degree or arity of a relation is the number of attributes n of its relation
explain interblock gapinterblock gap - a track of a disk is separated into equal-sized disk blocks blocks are separated through fixed-size gaps
what is distributed system distributed system - a distributed system consists of a number of processing parts in which are interconnected through a
what is derived and stored attributederived and stored attribute - in a few cases two or more attribute values are associated for example age and
what are the purpose for having variable length records what kinds of separator characters are required for each variable-length records -
describe participation constraintsparticipation constraints - the participation constraint exacts whether the existence of an entity depends on its
what is cardinality ratiocardinality ratios - the cardinality ratios for relationship kinds specifies the maximum number of relationship instances in
with the help of an example display how records can be deleted and updated in qbe i increase payrate of employees along with the skill of lsquocook
describe interfaces for the dbainterfaces for the dba - most database systems holds privileged commands which could be used only through the dbas
explain interfaces for parametric usersinterfaces for parametric users - parametric users such as bank tellers frequent have a little set of
what is natural language interfacesnatural language interfaces - these interfaces accept requests written within english or a few other language and
describe graphical user interfacegraphical user interfaces guis - a gui typically displays a schema to the user in diagrammatic form the user can
define forms based interfacesforms-based interfaces - a forms-based interface display a form to each user forms are commonly designed and programmed
describe the menu based interfaces for web clients or browsingmenu-based interfaces for web clients or browsing - these interfaces present the user
what are the different kinds of database end users discuss the major activities of eachend-users - end-users are the people whose jobs need access
define the following constraints for the table clienti baldue must be at least 1000ii name is a unique keyialter table client add constraint
explain the two constraints check and foreign key in sql along with an example for each give the syntax check constraint - check constraint specifies
what do you mean through integrity constraints integrity constraints -an integrity constraint is a condition specified on a database schema and