Process Management Contents Define Process 1 Discuss Process Control Block 2 Describe Cooperative Process 3 Explain the Concept of Inter-Process Communication 5 Explain the Principle of Concurrency and Process Synchronisation 6 Describe concept of Mutual Exclusion 6...
Introduction to DBMS and ER Diagram Contents ALO: Describe Database and its need 1 ALO: Differentiate between Database System and File System 2 ALO: Describe DBMS and its Advantages 6 ALO: Describe Functions of DBMS 8 ALO: Recall Characteristics of Data...
Transaction and Concurrency Control Contents Recall the concept of Query Processing 2 Recall the concept of Query Optimization 3 Describe the steps used in the Query Optimization 4 Write an Algorithm to Optimise Select Operation 6 Write an Algorithm to Optimise...
Relational Algebra and Relational Calculus Contents Recall Relational Database and its characteristics 1 Define and classify Integrity Constraints 2 Recall Relational Algebra and its various Operations 4 Describe the following Operations : Selection,...
Functional Dependency and Normalization Contents Recall the basics of Relational Schema 1 Describe design issues of Relational Schema 2 Recall the term Functional Dependency 3 Recall the rules of Inference and Armstrong’s Axioms 4 Describe Attribute...