Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
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
explain stand alone query language in detailsstand alone query language - the query language that can be used interactively is known as stand alone
describe object relational model object relational model - this model combines the characteristics of both relational model and object oriented model
explain object oriented model object oriented model - this model is based on the object-oriented programming language paradigm it involves the
explain relational model and their use in dbmsrelational model - the relational model was first introduced through ef codd of the ibm research in the
explain network model in dbmsnetwork model - it was formalised within the late year of 1960s through the database task group of the conference on
explain hierarchical model hierarchical model - it was established to model several kinds of hierarchical organizations which exist in the real world