Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Solved Assignments
Asked Questions
Answered Questions
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
explain odbc odbc - open database connectivity odbc enable the integration of sql along with a general-reasons programming
explain different categories of failures that occur in oracle database categories of failures - in oracle database subsequent types of failures can
describe integrity constraintsintegrity constraints - a database is just as excellent as the information stored in it and a dbms must therefore help
write a short note on temporary tablestemporary tables - temporary tables exists solely for a particular session or whose data persists for the
what is the purpose of tables private synonyms and public synonyms if there are multiple objects of similar name on an oracle database that order are
what are the features of embedded sql explain embedded sql - sql could be implemented within two ways it can be used interactively or embedded in a
consider the following relational schema doctordnameregno patientpname disease assignedto pnamedname give expression in both tuple calculus and
what are the disadvantages of relational data disadvantagesbull performance - if the number of tables among that relationships to be established are
what are the advantages of relational data model normal 0 false false false en-in x-none x-none microsoftinternetexplorer4
explain the concepts of relational data modelrelational data model - the relational model was first introduced through prof ef codd of the ibm
explain algorithm of er to relational mapping er-to-relational mapping algorithm1 step 1 mapping of regular entity types for each strong entity type
explain er relationship modelan entity-relationship model erm an entity-relationship model erm is an abstract theoretical illustration of structured
change the city of first bank corporation to lsquonew delhiupdate companyset city lsquonew delhiwhere companyname lsquofirst bank