Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
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
what are views explain how views are different from tables a view in sql terminology is a one table in which is derived from other tables these other
write a program within embedded sql to associative the total trip expenses of the salesman named lsquojohn for the relationsexec sql begin declare
why are cursors necessary in embedded sql a cursor is an object used to store the output of a query for row-by-row processing through the application
what is the difference between a key and a superkey key - a key a single attribute or a combination of two or more attributes of an entity set which
consider the subsequent relations for a database which keeps track of business trips of salespersons in a sales office salesperson ssn name startyear
what is dml query langaugedata manipulation language dml - a data manipulation language is a language in which enables users to access or manipulate
describe embedded query languageembedded query language - a query language eg sql can be implemented in two ways it can be used interactively or