Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
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
normal 0 false false false en-in x-none x-none microsoftinternetexplorer4
how to insert data in your table from another tableinsert into lttable-name gt ltselect-statementgt eg to insert tuples from employee into nemp
how to create a table from existing tablecreate table lttable-namegt as ltselect-statementgteg to create a new table lsquonemp with employee names
an orchestra database consists of the following relations conducts conductor composition requires composition instrument plays player instrument
define a table in sql known as client that is used to store information about the clients define clientno as the primary key whose first letter must
what is relationship instance relationship instance - a relationship is a relation between two or more entities an instance of relationship set is a
what is multivalued attributemultivalued attribute - multivalued attribute might have more than one value for an entity for instance previousdegrees
describe data manipulation language data manipulation language dml - a data manipulation language is a language which enables users to access or
what is primary key explainprimary key - primary key is one of the candidate keys it should be selected such in which its attribute values are never
differentiate between various levels of data abstraction data abstraction - abstraction is the procedure to hide the irrelevant things from the users
list any two significant differences between a file processing system and a dbms file processing system vs dbmsdata independence - data independence
what are the uses of odbc under what circumstances we use this technology odbc expose database capabilities within a standardized way to the