SMU MBA SEM 3 – MI0034 – DATABASE MANAGEMENT SYSTEM SUMMER 2016

SMU MBA SUMMER 2016-2017

Dear Students,

SMU MBA SUMMER 2016 Assignments are available. For Booking ,Kindly mail us on kvsude@gmail.com OR call us to +91 9995105420  or S M S your “ Email ID ” us in the following Format  “  On +91 9995105420 we will reach back you with in 24H ”

 

DRIVE

SUMMER 2016

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

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

 

2 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

 

 

3 a. Define SQL

  1. Explain the different types of SQL statements
  2. Defining SQL
  3. 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, Access, and so on. When the database is structured using the relational data

 

 

  1. a. Define Distributed Database Management System (DDBMS).
  2. Elaborate advantages and disadvantages of distributed database management system.
  3. Define distributed database management system
  4. 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

 

5 Define client–server model ? Briefly explain the advantages of client–server model

  1. Define client-server model with different parts
  2. 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

 

 

6 Briefly explain the basic concepts of object-oriented data model.

Explain the basic concepts of object-oriented data model

 

Answer: A data model is a logic organisation of the real-world objects (entities), constraints put on them and the relationships that exists among objects.

 

The basic

 

SMU MBA SUMMER 2016-2017

Dear Students,

SMU MBA SUMMER 2016 Assignments are available. For Booking ,Kindly mail us on kvsude@gmail.com OR call us to +91 9995105420  or S M S your “ Email ID ” us in the following Format  “  On +91 9995105420 we will reach back you with in 24H ”