Sunday 27 September 2015

mit202 smu msc it summer 2015 IInd sem assignment

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 and rs 500/semester only.
if urgent then call us on 08791490301, 08273413412

[Summer 2014 ] ASSIGNMENT
PROGRAM M.Sc IT
SEMESTER 2
SUBJECT CODE & NAME-MIT202– Data Base Management System(DBMS)
CREDIT 4, BK ID B1479, MAX. MARKS 60

Q1 What are the applications of database system?
Answer:
A database application is a computer program whose primary purpose is entering and retrieving information from a computerized database. Early examples of database applications were accounting systems and


Q2 Write the functions of the following (a) Storage Manager (b) Buffer Manager   3+2
Answer –    
Storage manager 

                The Storage Manager: The Storage Manager interfaces with the operating system (OS) to write data to the disk efficiently. Because the storage functions reside in a separate subsystem, the MySQL engine operates at a level of abstraction away from the operating system. This means

Q3. What are the important responsibilities of database manager? Explain
Answer - Databases typically require a large amount of storage space. Corporate databases are usually measured in terms of gigabytes of data. Since the main memory of computers cannot store this information, it is stored on disks. Data is moved between disk storage and main

Q no 4 Explain the Sequential File Organization.
Answer - A sequential file is designed for efficient processing of records in sorted order based on some search-key. A search key is any attribute or set of attributes; it need not be the primary key, or even a

Qno 5 Explain basic operations of Relational algebra?
Answer - Basic operations are the traditional set operations: union, difference, intersection and Cartesian product. Three of these four basic operations- union, intersection, and difference – require that operand relations be union compatible. Two relations are union compatible if they have the same parity

Q6 What are the disadvantages of Data Distribution
Answer - Disadvantages of Data Distribution The primary disadvantage of distributed database systems is the added complexity required to ensure proper coordination among the sites. This increased

Q no 7 Write a note on the following a) SUBSET Mapping b) SUPERSET Mapping  5+5
Answer -  As a result, VBSF supports two types of class-to-table mappings that help overcome the differences between relational and object models: SUBSET and SUPERSET.
SUBSET Mapping: This type of mapping is used when all the attributes of a persistent class are mapped

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 and rs 500/semester only.
if urgent then call us on 08791490301, 08273413412



No comments:

Post a Comment