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	FALL 2017
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. What is Database Management System (DBMS)? Briefly explain the different components of DBMS.

Answer: Organizations employ Database Management Systems (or DBMS) to help them effectively manage their data and derive relevant information out of it. A DBMS is a technology tool that directly supports data management. It is a package designed to define, manipulate, and manage data in a database.

Some general functions of a DBMS:

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 systems development, with conceptual modelling being considered the key to achieving data integration.

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 relational calculus, SQL consists of a data definition language, data manipulation language, and data control language. The scope of SQL includes data insert, query, update and delete, schema creation and modification, and data access control. Although SQL is often described as, and to a great extent is, a declarative language (4GL), it also includes procedural elements.

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.

SQL is a greater tool with web languages such as PHP,

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:

1) In a distributed database, data can be stored in different systems like personal computers, servers, mainframes, etc.

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 system. A server host runs one or more server programs which share their resources with clients. A client does not share any of its resources, but requests a server's content or service function. Clients therefore

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 not

Dear students get fully solved assignments

Send your semester & Specialization name to our mail id :

help.mbaassignments@gmail.com

or

call us at : 08263069601