MCA Syllabus of Tamilnadu Open University Relational Database Management System paper


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

MCA Syllabus of Tamilnadu Open University Relational Database Management System paper


TNOU MCA Paper Code : MCA 21
TNOU MCA Paper Title: Relational Database Management System



Block 1 Syllabus : Database Management System : Database – Database Management System – Features – Advantages – Database Scheme – Schema and subschema – Manipulative capabilities – Guidelines – Different User Interfaces-Relational Model : Concepts of Relational Model – Comments on the Relational Model : Semantic issues, Navigation, Efficiency – DBMS based on the Relational Model : The mapping operation – Data manipulation facilities – Data Definition facilities – Data Control facilities

Block 2 Syllabus: Introduction to Oracle: Types of Databases - Relational Database properties - Benefits of Oracle - Client/ Server systems – Oracle Database Architecture: Overview of Oracle Architecture – Process - Physical files – CPU - Network System Tables - Oracle Users - Logical Structures.

Block 3 Syllabus: Oracle Database Fundamentals: Elements of SQL Language: Database Objects, Data Access SQL Commands, DML Commands – Oracle Queries – Basic Query, Using Expressions, Working with NULL values, Joining Multiple Tables in a Query, Selecting Distinct Values, Using Sub queries, Unions and Multiple part Queries-

Block 4 Syllabus : Table Handling and Embedded SQL : Table Creation : Create table statement - Privileges required - Describing Table Definitions - Modifying Tables - Renaming a Table - Copying another table - Dropping a Table – Other Database Objects - Reason for Database Objects - Indexes – Embedded SQL : Languages supported by Oracle Precompiler - Embedded SQL : Languages supported by Oracle Precompiler, Embedded SQL statements.


MCA Reference Books:

1. An Introduction to Database System by C.J.Date, Addison Wesley.
2. Database system concepts by Silberschatz, Korth and Sudarshan, McGraw Hill.
3. An Introduction to Database Systems by Bipin C.Desai, Galgotia publications.


Related Articles

More articles: Tamilnadu Open University

Comments

No responses found. Be the first to comment...


  • 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:
    Email: