Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
differentiate between primary and secondary storageprimary and secondary storage - primary storage device stores the data temporarily primary storage
differentiate between key and superkeykey and superkey - a key a single attribute or a combination of two or more attributes of an entity set in
define database layerthe database layer defines the data formats used in the
differentiate between procedural and non procedural languages procedural and non procedural languages - a procedural language specifies the
explain the relevance of data dictionary in a database systemdata dictionary is a database in its own right residing on the disk that consist of meta
a well-maintained relational dbms has a high level of data integrity what features of a relational dbms contribute towards this level of
explain what is aggregation aggregation this is used whenever we intend to show a relationship between an entity and the relationship there is no
describe specialsation and generalizationspecialisation generalization this is a top down and bottom up approach to the design of database it
describe identifying relationshipidentifying relationship it is relationship among strong entity and a weak entity it is represented through a doubly
explain the three data models namely relational network and hierarchical and evaluate their relative advantages and disadvantageshierarchical model
explain the disadvantages of file oriented approachin the oriented approach applications are designed in isolation design of application is optimized
explain retrieval in qberetrieval in qbe a gui for expressing queries based on the domain relational calculus drc actually invented before guis very
explain group by clause in sqlgroup by clause in sql the group by clause can be used in a select statement to collect data across multiple records
what is oracle databse structureoracle database structure the relational model has three main aspectsstructures structures are well-defined objects
write short note on data modelsdata models a data model is an abstract model which elaborates how data is represented and accessed the term data
consider the relations described below physician regno name telno citypatient pname street city visit pname regno dateofvisit fee where the regno and
using sql create a view rs for the relations r and s the view consists of the columns a and d renamed as x and y in that order insert a tuple lt10
what is a view in sql when can views be updated a view is a virtual table which consists of columns from one or more tables through it is same to a
define union compatibility explain why intersection of two relations cannot be performed if they are not union compatible two relations ra1 a2-------
for the relations r and s given belowr sabc147258369compute i
differentiate between natural join and outer joinnatural join is a binary operator which is written as r s where as r and s are relations the output
explain triggertrigger a database trigger is procedural code which is automatically executed within response to certain events on a particular table
describe database state in detailsdatabase state the actual data within the database at a particular moment in time is known as a database
describe the host languagehost language you could write applications along with sql statements embedded inside a host language the sql statements
define dbmsdbms database management system dbms is computer software designed for the reason of supervision databases based on a variety of data