Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Solved Assignments
Asked Questions
Answered Questions
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
define what can be used as a criterion for classification of data structures utilized in language
define the ldquoturn-aroundrdquo time of a user job turn- around time is total time taken to execute the
the term lsquopage trafficrsquo explains page trafficrsquo explains the movement of pages in and out of
the scheduling technique in which cpu is allocated to the process with least cpu-burst time is known as shortest job first scheduling is a
a scheduler that selects processes from secondary storage device is known
from hardware perspective every information system can be divided into three task areas presentation application logic and data storagethe r3 basis
explain what is aggregation aggregation this is used whenever we intend to show a relationship between an entity and the relationship there is no
define instancean instance is an administrative unit in which components of r3 systems giving one or more services are grouped together the
describe specialsation and generalizationspecialisation generalization this is a top down and bottom up approach to the design of database it
interval among the time of submission and completion of the job is known
describe identifying relationshipidentifying relationship it is relationship among strong entity and a weak entity it is represented through a doubly
what components of the re system initiate the start of background jobs at the specified timethe batch scheduler initiates the begin of background
what are the phases of background processingphases are- job schedulingjob processingjob
what is the exclusive feature of unixshell is the exclusive feature of
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
define the load address for the first word of the program is known asload address origin is called as a load address for the first word of the
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