MI0034 – 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	WINTER 2016
PROGRAM	MASTER OF BUSINESS ADMINISTRATION (MBA)
SEMESTER	III
SUBJECT CODE & NAME	MI0034 – DATABASE MANAGEMENT SYSTEM
BK ID	B1966
CREDITS	4
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.

Question.1. Define Database and Database Management System (DBMS). Briefly explain the importantproperties of database.

Answer:A database management system (DBMS) is system software for creating and managing databases. The DBMS provides users and programmers with a systematic way to create, retrieve, update and manage data.

A DBMS makes it possible for end users to create, read, update and delete data in a database. The DBMS essentially serves as an interface between the

Question.2. With a neat diagram explain the concept of three-schema architecture.

Answer:The three-schema approach, or three-schema concept, in software engineering is an approach to building information systems and systems information management that originated in the 1970s. It proposes three different views in

Question.3. a. Define SQL

Answer:SQL is a domain-specific language used in programming and designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS).

Originally based upon relational algebra and tuple

b. Explain the different types of SQL statements

Answer:SQL is a very powerful and diverse database language use to storing data into databases. SQL is loosely typed language so you can learn easily.

In this SQL tutorial, we use command line examples to know about executing speed of SQL. It's take very bit of time for executing and retrieving result.

Question.4. a. Define Distributed Database Management System (DDBMS).

Answer:A distributed database is a database in which storage devices are not all attached to a common processor. It may be stored in multiple computers, located in the same physical location; or may be dispersed over a network of interconnected computers. Unlike parallel systems, in which the processors are tightly coupled and constitute a single database system, a distributed database system consists of loosely coupled sites that share no physical components.

b. Elaborate advantages and disadvantages of distributed database management system.

Answer:In a distributed database, data is stored in different systems across a network. For Example, in mainframes, personal computers, laptops, cell phones, etc.

Advantages of distributed database:

Question.5. Define client–server model. Briefly explain the advantages of client–server model.

Answer:The client–server model is a distributed application structure that partitions tasks or workloads between the providers of a resource or service, called servers, and service requesters, called clients. Often clients and servers communicate over a computer network on separate hardware, but both client and server may reside in the same

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

Answer:Imagine we have to design database for college. What is the real world entities involved with college? They are college, Students, Lecturer, Course, Subject, Marks etc. Once all the entities are listed, we find out the relationship between them and try to map all of them. Also we list what are the attributes related to each entity like student id, name, lecturer name, course that he is teaching, different subjects, pass mark, grade levels etc. Here we are

Dear students get fully solved assignments

Send your semester & Specialization name to our mail id :

help.mbaassignments@gmail.com

or

call us at : 08263069601