BCA3020 - Database Management System

Dear students get fully solved assignments

Send your semester & Specialization name to our mail id :

“ help.mbaassignments@gmail.com ”

or

Call us at : 08263069601

ASSIGNMENT

DRIVE	SPRING 2015
PROGRAM	BCA (REVISED FALL 2012)
Semester	3
SUBJECT CODE & NAME	BCA3020 - Database Management System
CREDIT	4
BK ID	B 1479
MAX.MARKS	60

Note: Answer all questions. Kindly note that answers for 10 marks questions should be approximately of 400 words. Each question is followed by evaluation scheme.

Q.1 What is Database? Explain its properties.

Answer: A database is a collection of information that is organized so that it can easily be accessed, managed, and updated. In one view, databases can be classified according to types of content: bibliographic, full-text, numeric, and images. In computing, databases are sometimes classified according to their organizational approach. The most prevalent approach is the relational database, a tabular database in which data is defined so that it can be reorganized and accessed in a number of different ways. A distributed database is one that can be dispersed or replicated among different points in a network. An object-oriented programming database is one that is congruent with the data defined in object classes and subclasses.

Q.2 Write the functions of the following

(a) Storage Manager

Answer: Storage Resource Monitor provides comprehensive storage performance monitoring and alerting across all your storage arrays to ensure peak performance and avoid capacity surprises.

Storage Manager is the interface to the systems storage service.

Q.3 List and explain the important responsibilities of database manager.

Answer: A database manager (DB manager) is a computer program, or a set of computer programs, that provide basic database management functionalities including creation and maintenance of databases. Database managers have several capabilities including the ability to back up and restore, attach and detach, create, clone, delete and rename the databases. Database managers are used to manage local and remote databases. They discover databases based on the Web server and provide the ability to connect to any of the databases residing in the network. They provide a handful of administrative functionalities such as managing tables, views and stored procedures, as well as run ad hoc queries.

Q.4 What is Relational Database Management System? Explain three aspects of RDBMS.

Answer: A relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as invented by E. F. Codd, of IBM's San Jose Research Laboratory. Many popular databases currently in use are based on the relational database model.

RDBMSs are a common choice for the storage of information in new databases used for financial records, manufacturing and logistical information, personnel data, and other applications since the 1980s. Relational databases have often replaced legacy hierarchical databases and network databases because they are easier to understand and use. However, relational databases have been challenged by object databases, which were introduced in an attempt to address the object-relational impedance mismatch in relational databases, and XML databases.

Q.5 What do you mean by Embedded SQL? How do you declare variables and exceptions?

Answer: Advantages of PL/SQL:

·         Better Performance

·         Integration with Oracle

·         Cursor FOR Loops

·         Procedures and Functions

·         Packages

·         PL/SQL Tables

·         User-Defined Records

Q.6 What are the disadvantages of Data Distribution?

Answer: In a distributed database, data is stored in different systems across a network. For Example, in mainframes, personal computers, laptops, cell phones, etc. Array expressions specify concurrency but not   locality. That is, they specify opportunities for parallel execution   but not how these opportunities should be exploited so as to minimize communication costs on a parallel computer. HPF introduces data distribution directives to provide the programmer with control over locality. These directives work as follows

Q.7 Write a note on the following

a) SUBSET Mapping

Answer: In DBMS Writing a Java application that stores data in a RDBMS can be as simple as slapping a few data-aware components on a form. However, if you rely on data-aware controls you lose the benefits of encapsulation and set yourself up for a larger maintenance burden ahead. (See the sidebar "Benefits of the Business Object"). Proper object-relational integration requires a strategy for mapping the object model to the relational model in order for Java objects to become persistent to the RDBMS. A persistent object is one that can automatically store and retrieve itself in permanent storage.

b) SUPERSET Mapping

Answer: A persistent class with a superset mapping contains attributes derived from columns of multiple tables. This type of mapping is also known as table spanning.

Dear students get fully solved assignments

Send your semester & Specialization name to our mail id :

“ help.mbaassignments@gmail.com ”

or

Call us at : 08263069601