Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Solved Assignments
Asked Questions
Answered Questions
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
write down any four application of a stack i conversion of infix to postfix form ii reversing of a line iii removal of recursion iv
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
explain the concept of a data model data model - model is an abstraction procedure which hides irrelevant details although highlighting details
create student db and execute insert querystudent name student class major course course name course credit hours department section section
create student db and perform delete operationstudent name student class major course course name course credit hours department section section
create student database and retrieve course name taught by kingstudent name student class major course course name course credit hours department
create a student database and retrieve the names of all students majoring in lsquocsconsider the following relational database student name student
create an index for the table client field clientno of q command create index clientclientno on
write the syntax of creating an index syntax of creating an index create bitmap unique index ltindexnamegt on lttablenamegtltcolumnname1gt