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

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

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

NMIMS Global Access Assignment _2019

Business_Statistics_Assignment_June_2019 Business_Law_Assignment_June_2019 Essentials_of_HRM_Assignment_June_2019 Financial_Accounting_and_Analysis_Assignment_June_2019 Marketing_Management_Assignment_June_2019 Strategic_Management_Assignment_June_2019 For Assignment Solution Contact Niraj kumar Call and whatsapp (9899682018) Mail:-Nirajkumar294@gmail.com
Post a Comment
Read more