Get fully solved assignment, plz drop a mail with your sub code
computeroperator4@gmail.com
Charges for mba rs 125/subject and rs 700/semester only.
For other rs 125/subject only
if urgent then call us
on 08791490301, 08273413412
[ Fall 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
Explain the functions of the following (a) Entities (b) Attributes (c)
Relationships 3+3+4
Answer
-
|
Entities
|
Entities are the principal data objects
about which information is to be collected; they usually denote a person,
place, thing, or event of informational interest. A particular occurrence
Q2
List and explain the important responsibilities of database manager.
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 3 Explain the Sequential File Organization with the help of diagrams.
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 superkey. To permit fast retrieval of records in
search-key order, we chain together records by pointers. The pointer in each
record points to the next record in search-key
Q4. Explain the LIKE Predicate.
Answer: The LIKE predicate searches for strings that have a certain
pattern. The pattern is specified after the LIKE keyword
in a scalar expression which can be as simple as a string constant or a complex
expression containing concatenation operators, scalar functions, etc. The
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
Q6. Explain any two features of Object
Oriented System.
Answer:
Object-oriented databases (OODBs) represent the
latest generation of database systems technology. Research and development of
OODBs has been driven largely by the high-performance data storage and access
requirements of design support environments, such as
Get fully solved assignment, plz drop a mail with your sub code
computeroperator4@gmail.com
Charges for mba rs 125/subject and rs 700/semester only.
For other rs 125/subject only
if urgent then call us
on 08791490301, 08273413412
No comments:
Post a Comment