Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
which operation is used if we are interested in only certain columns of a tableprojection operation is used if we are interested in only certain
what is a relationship called when it is maintained between two entitiesa relationship is called binary relationship when it is maintained between
what is conceptual model a conceptual model is a independent of both hardware and
when it is better to use files than a dbms it is better to use files than a dbms when multiple users wish to access the
what are the properties in a relation in a relation ordering of rows is immaterial and no two rows are
which is the properties of entitiesattributes is the properties of
which file organization provides very fast access to any arbitrary record of a filehashed file organization provides very fast access to any
which product produces the relation that has attributes of r1 and r2 cartesian product produce the relation which has attributes of r1 and
key to represent relationship amongs tables is called a key that represent the relationship between tables is called foreign
what is relational algebrarelational algebra is a procedural query
set concept is used in which type of modellingset concept is used in network
e-r model uses this symbol to represent weak entity set a doubly outlined rectangle symbol is used to represent weak entity
describe the statement in sql which allows to change the definition of a tablein sql alter statement is used to allow the changes the definition of a
what is the meaning of data independencedata independence means a programs that are not dependent on the physical attributes of data and a programs
which method is used to key transformation a hash method is used to key
what are the technique to define a schema completely a schema is completely define by ddl and dml query
by which techniquestransaction processing is associatedtransaction processing is associated by producing detail summary or exception reports and
why does a dbms query language is designeda dbms query language is designed to support end users who use english-like commands support in the
whta is the advantage of the database management approachthe advantage of the database management approach is data is integrated and can be accessed
which element in the database can modified by changing the data dictionarydata elements in the database can be changed or modified through changing
what count function return in sqlcount function within sql returns the number of values count function counts all the not null values in the exact
what subschema expresses a subschema expresses the external view external schemas are called also called as
what was the method in which records are physically stored in a specified order according to a key field in each record a method in which records are
what does conceptual design worka conceptual design involves modelling independent of the
what is relational model featurea relational model feature is much more data independence than some other database