Query decomposition is a critical step in distributed query processing where a complex SQL query is broken down into simpler, smaller sub-queries that can be executed across different sites or nodes in a distributed database system. The goal of this process is to ensure that each sub-query can be processed locally, reducing the overhead of … Read more
Distributed Integrity Constraints are rules that ensure data consistency, accuracy, and reliability across multiple sites in a Distributed Database Management System (DDBMS). These constraints help maintain data integrity even when data is stored at different locations and accessed by multiple users simultaneously. The types of distributed integrity constraints are as follows: i. Primary Key Constraint: … Read more
COM_MIN Approach in Horizontal Fragmentation The COM_MIN (Complete and Minimal) approach is used in horizontal fragmentation to divide a database table into smaller, meaningful parts based on query conditions. The goal is to ensure that each fragment contains only the necessary data, making queries faster and reducing communication between database servers. How it Works: i. … Read more
A Distributed Database Management System (DDBMS) is a software system that manages a database distributed across multiple locations, interconnected by a network, yet presents it as a unified database to users. This distribution allows data to be stored closer to where it’s needed, enhancing accessibility and performance. The key characteristics of a DDBMS are: i. … Read more
Level Master Programme MCIS Semester Spring Year 2015 Course Ethical and Professional Issues in IT Full Marks 100 Pass Marks 60 Time 4 hrs Candidates are required to give their answers in their own words as far as practicable. The figures in the margin indicate full marks. Attempt all the questions. Group “A” Group “B” Read … Read more
Level Master Programme MCIS Semester Spring Year 2017 Course Ethical and Professional Issues in IT Full Marks 100 Pass Marks 60 Time 4 hrs Candidates are required to give their answers in their own words as far as practicable. The figures in the margin indicate full marks. Answer the questions: Group A 1. What do … Read more
Level Master Program MCIS Semester Spring Year 2014 Course Software Project Management Full Marks 100 Pass Marks 60 Time 4 hrs Candidates are required to give their answers in their own words as far as practicable. The figures in the margin indicates full marks Attempt all the questions Activity A B C D E F … Read more
Level Master Programme MCIS Semester Spring Year 2014 Course Ethical and Professional Issues in IT Full Marks 100 Pass Marks 60 Time 4 hrs Candidates are required to give their answers in their own words as far as practicable. The figures in the margin indicate full marks. Answer the questions: Group A 1. What do … Read more
Level Master Programme MCIS Semester Spring Year 2014 Course Ethical and Professional Issues in IT Full Marks 100 Pass Marks 60 Time 4 hrs Candidates are required to give their answers in their own words as far as practicable. The figures in the margin indicate full marks. Answer the questions: 1. What do you mean … Read more
Level Master Programme MCIS Semester Fall Year 2014 Course Ethical and Professional Issues in IT Full Marks 100 Pass Marks 60 Time 4 hrs Candidates are required to give their answers in their own words as far as practicable. The figures in the margin indicate full marks. Attempt all the questions. 1. What are the decision … Read more