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