Skip to main content

MCA312- ADVANCED DATABASE MANAGEMENT SYSTEM


For Assignment Solution Contact
Niraj kumar
Call and whatsapp (9899682018)
Mail:-Nirajkumar294@gmail.com 


ASSIGNMENT

DRIVE
SPRING 2019
PROGRAM
MASTER OF COMPUTER APPLICATION
SEMESTER
III
SUBJECT CODE & NAME
MCA312- ADVANCED DATABASE MANAGEMENT SYSTEM
BK ID
B1649
NUMBER OF ASSIGNMNETS,
CREDITS & MARKS
2, 4 CREDITS, 30 MARKS EACH

Note –The Assignment is divided into 2 sets. You have to answer all questions in both sets. Average of both assignments score scored by you will be considered as your IA score. Kindly note that answers for 10 marks questions should be approximately of 400 words. Each question is followed by evaluation scheme.


Q.No
Assignment Set -1
Questions
Marks
Total
Marks
1
Differentiate between Two-Tier client/server databases and Multi-tier client/server databases.
5+5
10
2
Describe the most important classes of parallel machines.
10
10
3
Differentiate between Serialisability and Recoverability.
10
10




Q.No
Assignment Set -2
Questions
Marks
Total
Marks
1
What are the major design issues of parallel system?
4+6
10
2
Differentiate between homogeneous and heterogeneous
Database.
10
10
3
What are the storage methods in ORDBMS? Briefly
describe.
10
10











Comments

Post a Comment

Popular posts from this blog

Define algorithm and write a note on Complexity and Time- Space Tradeoff with example.

ASSIGNMENT SET -2 Q.1.Define algorithm and write a note on Complexity and Time- Space Tradeoff with example. Answer:- Algorithm is a step-by-step procedure, which defines a set of instructions to be executed in a certain order to get the desired output. Algorithms are generally created independent of underlying languages, i.e. an algorithm can be implemented in more than one programming language. From the data structure point of view, following are some important categories of algorithms − Search − Algorithm to search an item in a data structure. Sort − Algorithm to sort items in a certain order. Insert − Algorithm to insert item in a data structure. Update − Algorithm to update an existing item in a data structure. Delete − Algorithm to delete an existing item from a data structure. Characteristics of an Algorithm Not all procedures can be called an algorithm. An algorithm should have the following characteristics − Unambiguous − Algorithm should be clear a...
Post a Comment
Read more

SQL Server interview questions along with their answers

1.     What is SQL Server? SQL Server is a relational database management system (RDBMS) developed by Microsoft. It is used to store, retrieve, and manage data efficiently. What is the difference between SQL and SQL Server? SQL (Structured Query Language) is a standard language used to communicate with and manipulate databases. SQL Server is a relational database management system that implements the SQL language.  What are the different types of backups available in SQL Server? SQL Server supports several types of backups, including Full Backup, Differential Backup, Transaction Log Backup, and File or Filegroup Backup. What is normalization in SQL Server? Normalization is the process of organizing data in a database to reduce redundancy and dependency. It helps in improving data integrity and performance.  What is a clustered index? A clustered index determines the physical order of data in a table. A table can have only one clustered index, and it...
Post a Comment
Read more

Business_Communication_and_Etiquette_-_Assignment_December_2018

Business_Communication_and_Etiquette_-_Assignment_December_2018                                                             NMIMS Global Access School for Continuing Education (NGA-SCE) Course: Business Communication and Etiquette Internal Assignment Applicable for December 2018 Examination 1. Large organizations where there are many people working closely, create unofficial and informal channels of communication. What is this kind of communication known as and what purpose does it serve in large organizations? List different types of this communication along with drawbacks if any. (10 Marks) 2. Explain the various forms that non-verbal communication takes which impacts cultural aspect of communication. How does verbal and non-verbal communication relate to each other? (10 Marks) 3. Zenstar Technologies has the task of collati...
Post a Comment
Read more