BCA3020 - Database Management System

Dear students get fully solved  SMU BBA Spring 2014 assignments

Send your semester & Specialization name to our mail id :

“ help.mbaassignments@gmail.com ”

or

Call us at : 08263069601

SPRING 2014, ASSIGNMENT

DRIVE	SPRING 2014
PROGRAM	BACHELOR OF COMPUTER APPLICATION
SUBJECT CODE & NAME	BCA3020/IMC3020- Database Management System
SEMESTER	THIRD
CREDITS	4
MAX. MARKS	60
BK ID	B

Answer all questions

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

2 Write a note on:

Ø  MySQL Architecture

Answer : MySQL's architecture consists of a web of interrelated function sets, which work together to fulfil the various needs of the database server. A number of authors3 have implied that these function sets are indeed components, or entirely encapsulated packages; however, there is little evidence in the source code that this is the case.

Indeed, the architecture includes separate function libraries, composed of functions that handle similar tasks, but there is not, in the traditional object-oriented programming sense, a full component-level separation of functionality.

Ø  Primary Subsystems

Answer : To increase availability and scalability, you can set up DB2 UDB for z/OS as a parallel database, known as DB2 data sharing. With this setup, multiple DB2 subsystems share the same SAP database. Each subsystem is called a data sharing member, and the set of subsystems is referred to as a data sharing

3 What are the attributes used in the E-R model? Explain with the example of Student database.

Answer : Entity-Relationship (ER) Model

In the ER model, the main concepts are entity, attribute, and relationship.

Entities and Attributes

Entity: An entity represents some "thing" (in the miniworld) that is of interest to us, i.e., about which we want to maintain some data. An entity could represent a physical object (e.g., house, person, automobile, widget) or a less tangible concept (e.g., company, job, academic course, business transaction).

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

Answer : A relational database management system (RDBMS) is a program that lets you create, update, and administer a relational database. Most commercial RDBMS's use the Structured Query Language (SQL) to access the database, although SQL was invented after the development of the relational model and is not necessary for its use.

The leading RDBMS products are Oracle, IBM's DB2 and Microsoft's SQL Server. Despite repeated challenges by competing technologies, as well as the claim by some experts that no current RDBMS has fully implemented relational principles, the majority of new corporate databases are still being created and managed with an RDBMS.

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

Answer : Embedded SQL is a method of inserting inline SQL statements or queries into the code of a programming language, which is known as a host language. Because the host language cannot parse SQL, the inserted SQL is parsed by an embedded SQL preprocessor.

Embedded SQL (ESQL) is a SQL-92 standard application programming interface (API) for SQL database access. ESQL requires a two-step compilation process:

·         A precompiler translates Embedded SQL statements into commands in the programming language used to write the application.

6 Briefly explain the reasons behind Object-relational impedance mismatch.

Answer : The O/R Impedance Mismatch

Why does this impedance mismatch exist?  The object-oriented paradigm is based on proven software engineering principles.  The relational paradigm, however, is based on proven mathematical principles.  Because the underlying paradigms are different the two technologies do not work together seamlessly. The impedance mismatch becomes apparent when you look at the preferred approach to access: With the object paradigm you traverse objects via their relationships whereas with the relational paradigm you join

Dear students get fully solved  SMU BBA Spring 2014 assignments

Send your semester & Specialization name to our mail id :

“ help.mbaassignments@gmail.com ”

or

Call us at : 08263069601