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

Networking interview questions .

What is LAN? LAN is a computer network that spans a relatively small area. Most LANs are confined to a single building or group of buildings. However, one LAN can be connected to other LANs over any distance via telephone lines and radio waves. A system of LANs connected in this way is called a wide-area network (WAN). Most LANs connect workstations and personal computers. Each node (individual computer) in a LAN has its own CPU with which it executes programs, but it also is able to access data and devices anywhere on the LAN. This means that many users can share expensive devices, such as laser printers, as well as data. Users can also use the LAN to communicate with each other, by sending e-mail or engaging in chat sessions. What's the difference Between an Intranet and the Internet? There's one major distinction between an intranet and the Internet: The Internet is an open, public space, while an intranet is designed to be a private space. An intranet may b...
1 comment
Read more

For Assignment Solution Contact Omegaitsolution.com https://www.omegaitsolution.com 9899682018 DEC 2018 NMIMS Solved Assignments,

For Assignment Solution Contact Omegaitsolution.com https://www.omegaitsolution.com 9899682018 1. The manager of a company was analysing the trend of the products of its company (Commodity Y) getting replaced by another substitute product available in the market which gives the same level of satisfaction to the consumers. Calculate the rate of Marginal Rate of Substitution and analyse the result. Combination Units of Commodity Y Units of Commodity X Total Utility a 40 10 U b 25 14 U c 17 19 U d 10 27 U e 7 38 U 2. Neha has just completed her MBA and joined a startup company. The company was planning to launch a new product in the market so the management wanted to understand the different factors that can impact the demand and supply of their products in the market. Help Neha to prepare a report on the factors impacting d...
2 comments
Read more