MCA World :: Computer Application ::
 Questions :  Answers : Solutions of TMA & Project Assignment  of  MCA courses of IGNOU, NIT & Other Universities.

::: Database Management System

Home • Introduction to Software • Data Structures • System Engineering • Database Management System • Discrete Mathematics • Numerical & Statistical Computing • Software Engineering • Operation Research • Accounting & Finance • Computer Architecture • Operating Systems • Intelligent Systems • Relational Database • Obejct Oiented Systems

Database Management System
RDBMS VS OODBMS • Data Independence in DBMS • Data Redundancy • Functional Dependency • Entity Types & Relationship

Main Chapters

Home
Introduction to Software
Data Structures
System Engineering
Database Management System
Discrete Mathematics
Numerical & Statistical Computing
Software Engineering
Operation Research
Accounting & Finance
Computer Architecture
Operating Systems
Intelligent Systems
Relational Database
Obejct Oiented Systems
Database Management System

 Problems Discussed in this chapter

Question 1: Discuss the advantages and disadvantages of object oriented database management system in comparison with RDBMS. Discuss types of applications suitable for object oriented DBMS and RDBMS.

Click for Answer

Question 2: Discuss the concept of data independence and explain its importance in database environment with the help of a suitable example.

Question 3: Describe the problem that are associated with redundant data. Can data redundancies be completely eliminated when the database approach is used? Why or why not?

Click for Answer

Question 4:  Describe the concept of functional dependency. How is this associated with  the process of normalization?

Click for Answer

Question 5:  Describe the rules for deriving relations that represent strong entity types,  weak entity types, one-to-one binary relationship types, one-to-many relationship types, multi-valued attributes, and super class / subclass  relationships.

Click for Answer

[ RDBMS VS OODBMS ] [ Data Independence in DBMS ] [ Data Redundancy ] [ Functional Dependency ] [ Entity Types & Relationship ]
 

 
 
 

Home • Introduction to Software • Data Structures • System Engineering • Database Management System • Discrete Mathematics • Numerical & Statistical Computing • Software Engineering • Operation Research • Accounting & Finance • Computer Architecture • Operating Systems • Intelligent Systems • Relational Database • Obejct Oiented Systems

This is complete MCA study materials containing question, solutions, answers, programming, scripts, TMA, Project assignment solutions for aspiring MCA or BCA student. This website may be useful for all in general and IGNOU student in particulars. Disclaimer : Execution and correctness of programs/answers may be established by the users himself and the mcaworld.net shall not held responsible for any damage/loss caused due to the use of code over this site.

Dear Visitor, If you are not able to find what you have been looking for on this site, please do try your search once again with different combination of words in the following Google Tool Bar, Specially designed to provide enhanced search option. Thank you.
Google

Webmaster Bipin Bihari Pandey, An IT Expert of DotNet Technology, MCA from IGNOU
bipin9830@rediffmail.com or bipin9830@yahoo.com