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 Summer  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.

 

 

 

  1. 1. Explain the functions of the following:

(a) Entities

Answer:(a) Entities

Answer: Functions, variables, named constants, special forms, and macros are described using a distinctive typographical format. Table 1-1 illustrates the manner in which Common Lisp functions are documented. The first line specifies the name of the function, the manner in which it accepts arguments, and the fact that it is a function. If the function takes many arguments, then the names of the arguments may spill across two or three lines. The

 

 

 

(b) Attributes

Answer: The keyword __attribute__ allows you to specify special attributes when making a declaration. This keyword is followed by an attribute specification inside double parentheses. The following attributes are

 

 

(c) Relationships

Answer: A function is a set of rules to wich you input a value and get an output. So, the set of rules could be a human body and its complex Chemistry or the program inside a hard drive. An equation is simply two things being equal in at least one aspect. For example 3x=9 whether is 9 apples in one side and 3 groups of pears in the other side or if they’re all apples. This could occur with two variables as well, for instance y=x+3 if on one side you have a bag with 10 marbles and on the other a bag with 7 marbles and 3 loose. Yet that could

 

 

 

 

 

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. The storage manager handles storage-related items such

 

 

 

(b) Buffer Manager

Answer: The role of the Buffer Manager is to make page from the disk available to processes into the main memory (buffer pool). It is the responsibility of the buffer manager to allow process to get the pages they need, while minimizing disk accesses and unsatisfiable requests. by implementing a page

 

 

 

 

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

 

 

 

 

 

Q.4 Explain the Sequential File Organization with the help of diagrams.

Answer: A process-data diagram is a diagram that describes processes and data that act as output of these processes. On the left side the meta-process model can be viewed and on the right side the meta concept model can be viewed. A process-data diagram can be seen as combination of an business process model and data model.

The process-data diagram that is depicted at the right, gives an overview of all of these activities/processes and deliverables. The four gray

 

 

Q5. Explain basic operations of Relational algebra.

Answer : Relational database systems are expected to be equipped by a query language that can assist its user to query the database instances. This way its user empowers itself and can populate the results as required. There are two kinds of query languages, relational algebra and relational calculus. Relational

 

 

 

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. The   PROCESSORS directive is used to specify

 

 

 

Q.7 Write a note on the following

 

  1. 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

 

 

 

  1. 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. Superset mappings are used to create “view classes” that hide the underlying data model, or to map a class inheritance tree to the database using a Vertical mapping

 

 

Dear students get fully solved  assignments

Send your semester & Specialization name to our mail id :

 

“ help.mbaassignments@gmail.com ”

or

Call us at : 08263069601

 

Leave a Reply