University : Mohanlal Sukhadia University
Degree : BCA
Applicable For : Second Year
Announcement : Syllabus
Website : https://www.mlsu.ac.in/index.php
Download Syllabus :
BCA 201 : http://www.syllabus.gen.in/uploads/1016-BCA201.pdf
BCA 202 : http://www.syllabus.gen.in/uploads/1016-BCA202.pdf
BCA 203 : http://www.syllabus.gen.in/uploads/1016-BCA203.pdf
BCA 204 : http://www.syllabus.gen.in/uploads/1016-BCA204.pdf
BCA 205 : http://www.syllabus.gen.in/uploads/1016-BCA205.pdf
BCA 206 : http://www.syllabus.gen.in/uploads/1016-BCA206.pdf
BCA II-Year Syllabus :
BCA- 202 : Database Management Systems
UNIT-I :
Introduction : Purpose of the data base system, data abstraction, data model, data independence, data definition language, data manipulation language, data base administrator, data base users, overall structure.
Related : Mohanlal Sukhadia University BCA I-Year Syllabus : www.syllabus.gen.in/1013.html
ER Model : entities, mapping constrains, keys, E-R diagram, reduction E-R diagrams to tables, generation, aggregation, design of an E-R database scheme.
UNIT-II :
Relational Model : The catalog, base tables and views. Relational Data Objects Domains and Relations: Domains, relations, kinds of relations, relations and predicates, relational databases.
Relational Data Integrity – Candidate keys and related matters: Candidate keys. Primary and alternate keys. Foreign keys, foreign key rules, nulls. Candidate keys and nulls, foreign key and nulls.
UNIT-III :
The SQL Language: Data definition, retrieval and up-date operations. Table expressions-conditional expressions, embedded SQL. Views : Introduction, what are views for, data definition, data manipulation, SQL support.
UNIT-IV :
Network model : basic concepts, data structure diagrams, DBTG CODASYL model, DBTG data retrieval facility, DBTG update facility, DBTG set processing facility, mapping networks to file, networks system.
Hierarchical model : basic concepts, tree structure diagrams, data retrieval facility, update facility, virtual records, mapping hierarchical to files, hierarchical system.
UNIT-V :
File and system structure : overall system structure, file organisation, logical and physical file organization, sequential and random, hierarchical, inverted, null list,indexing and hashing, B-tree index files.
Recommended Books :
1. Date C.J., Database Systems, Addision Wesley.
2. Korth, Database Systems Concepts, McGraw Hill.
BCA 203 : Fundamentals of Operating Systems
UNIT-I :
Introduction: What is an operating system? Mainframe, desktop, multiprocessor, distributed, clustered, realtime and handheld systems.Operating System Structures: System components, operating system services, system calls, systems programs, system structure, virtual machines.
UNIT-II :
Process: Process concept, process scheduling, operations on processes, cooperating processes. Inter process communication.
UNIT-III :
Process Synchronization: The critical section problem, semaphores, classical problems of synchronization. Deadlocks : Deadlock characterization, methods for handling deadlocks. Deadlock prevention, avoidance and detection. Recovery from deadlocks.
UNIT-IV :
Memory Management: Swapping, contiguous memory allocation, paging, segmentation, segmentation with paging. Virtual Memory : Demand paging, page replacement, allocation of frames, thrasing.
UNIT-V :
Linux : History, design principles, kernel modules, process management, scheduling, memory management, file systems, input and output, inter process communication, network structure, security.