Syllabus MCA First year Syllabus of Tamilnadu Open University Introduction to Database Management System pape

MCA First year Syllabus of Tamilnadu Open University Introduction to Database Management System pape

Posted Date: 31-Jan-2011	Category: Syllabus	Rating:
Author: Ravi	Member Level: Diamond	Points: 2

MCA Introduction to Database Management System Syllabus of Tamilnadu Open University, Reference books for MCA Introduction to Database Management System paper Tamilnadu Open University is listed in this article. Details Introduction to Database Management System syllabus is given in this article.

MCA First year Syllabus of Tamilnadu Open University Introduction to Database Management System paper

TNOU MCA Paper Code : MCA 05
TNOU MCA Paper Title: Introduction to Database Management System

Block 1 Syllabus : DBMS concepts : Introduction – Basics of Database – Three views of Data – Three level architecture of DBMS – Facilities – Elements of DBMS – Advantages and disadvantages – Database Models : File Management system and its drawbacks – Database Models : E-R Model, Hierarchical Model, Network Model, Relational Model.

Block 2 Syllabus: File Organization: Introduction – Methods of File Organization – Sequential, Direct, Index Sequential – Multi Key file organization – Management Considerations: Objectives – Conversion – Evaluation of DBMS – Administration of DBMS.

Block 3 Syllabus: RDBMS and DDBMS: Introduction – Relational Model – Concept – Definition of a relation – Relational algebra and relational completeness – Normalization: Objectives – Functional dependency – Anomalies in a database – Properties of Normalization – Various Normalization techniques – Examples of database design – SQL: Types of SQL commands – Data definition – Data Manipulation statements – Distributed Databases: Structure of Distributed database – Design of Distributed database.

Block 4 Syllabus : Trends in DBMS : Objectives – Next generation Database – Application – Object Oriented system – Object Oriented DBMS – Pitfalls of RDBMS – Comparison of RDBMS and OODBMS – Client/Server Database : Objective – Evolution – Client/Server computing – Critical Products – Knowledge base Management system : Objectives – Definition and importance of Knowledge – Difference of KBMS and DBMS.

MCA Reference Books:

1. Database System Concepts by Silberschatz, Korth and Sudarshan, McGraw Hill.
2. An Introduction to Database systems by Bibin C. Desai, Galgotia Publications.

Post Comment:

Notify me by email when others post comments to this article.

Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.

No HTML formatting and links to other web sites are allowed.

This is a strictly moderated site. Absolutely no spam allowed.

Name:	Sign In to fill automatically.
Email:	(Will not be published, but required to validate comment)
	Type the numbers and letters shown on the left.