Get fully solved assignment. Buy
online from website
online store
or
plz drop a mail with your sub
code
we will revert you within 2-3
hour or immediate
Charges rs 125/subject
if urgent then
call us on 08791490301, 08273413412
DRIVE
Spring 2017
PROGRAM
MASTER OF BUSINESS ADMINISTRATION (MBA)
SEMESTER
III
SUBJECT CODE & NAME
MI0034 – DATABASE MANAGEMENT SYSTEM
1 What is Database Management System
(DBMS)? Briefly explain the different components of DBMS.
Explain Database Management
System
Define Database Management System
Explain the components of DBMS
Answer: The major
component in the database is “data.” Data is a raw fact that can be recorded
and has specific meaning. The processed data is called information. For
example, the combination of letters “E” “L” “E” “P” “H” “A” “N” “T” has no
meaning to us unless it is used as a noun word “Elephant.” Here, the letter “E”
is a data and “Elephant” is information. The collection of
2 Explain
the different operations of relational algebra with suitable examples.
Explaining the various operations of
relational algebra with an example
Answer:
Relational Algebra
Relational algebra is a language in which one
relation gets defined by another relation without the original relation getting
changed. There are many operations that work with relational algebra. Some of
them are
3 a. Define SQL
b. Explain the different types of SQL
statements
a.
Defining SQL
b.
Defining four different types of SQL statements
Answer: A) SQL is a relational database language used to
communicate with a database. The American National Standards Institute declared
the standard language for RDBMS. Accordingly, the common relational database management
systems that SQL uses are Oracle, Sybase, Microsoft SQL Server
4. a. Define Distributed Database
Management System (DDBMS).
b. Elaborate advantages and
disadvantages of distributed database management system.
a.
Define distributed database management system
b.
Explain four advantages and four disadvantages of distributed database
management system
Answer: a) In a centralized database
system, all system components such as data, DBMS software, storage devices
reside at a single computer or site, where as in distributed database system
data is spread over one or more computer connected by a network. Distributed
database is thus a set of databases stored on multiple computers but it appears
to a user as a single database. The data on several computers can be
simultaneously accessed and modified (data from local and remo
5 With a neat diagram explain the
concept of three-schema architecture.
Diagram
Explain
the concept of three-schema architecture
Answer: The
Three-schema Architecture has three levels of architecture, an internal level,
a Conceptual level and an External level. The three schema architecture is also
referred as Client Server Architecture. In this architecture the major
advantages lies in that, the division of the architecture into levels allows
both developers and users to work on their own levels. They do not
6 Define client–server model ? Briefly
explain the advantages of client–server model
a.
Define client-server model with different parts
b.
Listing 3 advantages of client–server model
Answer: Client–server model
The client–server model is
basic to distributed systems; it allows clients to make requests that are
routed to the appropriate server in the form of transactions. The client–server
model consists of three parts.
1.
Client
Get fully solved assignment. Buy
online from website
online store
or
plz drop a mail with your sub
code
we will revert you within 2-3
hour or immediate
Charges rs 125/subject
if urgent then
call us on 08791490301, 08273413412
No comments:
Post a Comment