Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Solved Assignments
Asked Questions
Answered Questions
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
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