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

(Prefer mailing. Call in emergency )

ASSIGNMENT

DRIVE	FALL 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 important properties 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 database and end users or application programs, ensuring that data is consistently organized and remains easily accessible.

The DBMS manages three important things: the data, the database engine that allows data to be accessed, locked and modified -- and the database

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.

The three-schema approach offers three types of schemas with schema techniques based on formal language descriptions:

Question. 3. a. Define SQL

Answer: Structured Query Language (SQL) is a standard computer language for relational database management and data manipulation. SQL is used to query, insert, update and modify data. Most relational databases support SQL, which is an added benefit for database administrators (DBAs), as they are often required to support databases across several different platforms.

First developed in the early 1970s at IBM

b. Explain the different types of SQL statements

Answer: Types of SQL Statements: The tables in the following sections provide a functional summary of SQL statements and are divided into these categories:

·       Data Definition Language (DDL) Statements

·       Data Manipulation Language (DML) Statements

·       Transaction Control Statements

·       Session Control Statements

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

Answer: A DDBMS (distributed database management system) is a centralized application that manages a distributed database as if it were all stored on the same computer. The DDBMS synchronizes all the data periodically, and in cases where multiple users must access the same data, ensures that updates and deletes performed on the data at one location will be automatically reflected in the data stored elsewhere.

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

Answer: Advantages

·       Management of distributed data with different levels of transparency like network transparency, fragmentation transparency, replication transparency, etc.

·       Increase reliability and availability

·       Easier expansion

·       Reflects organizational structure — database fragments potentially stored within the departments they relate to

·        

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

Answer: A client-server network is designed for end-users, called clients, to access resources such as files, songs, video collections, or some other service from a central computer called a server. A server's sole purpose is to do what its name implies - serve its clients! You may have been using this configuration and not even have known it. Have you ever played Xbox Live or used the PlayStation Network? Your Xbox One is the client, and when it

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

Dear students get fully solved assignments

Send your semester & Specialization name to our mail id :

“ help.mbaassignments@gmail.com ”

or

Call us at : 08263069601

(Prefer mailing. Call in emergency )