Bca Se Syllabus
SYLLABUS FOR BACHELOR OF COMPUTER APPLICATIONS - SIMULTANEOUS ENTRY (BCA- SE)
FIRST YEAR
BCA 06 Introduction to Database Management System
Block 1 : 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 : 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 : 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 : 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.
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.
SECOND YEAR
BCA 09 Relational Database Management Systems
Block 1 : RDBMS Terminology – Introduction to Database Management System –
FIRST YEAR
BCA 06 Introduction to Database Management System
Block 1 : 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 : 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 : 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 : 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.
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.
SECOND YEAR
BCA 09 Relational Database Management Systems
Block 1 : RDBMS Terminology – Introduction to Database Management System –