Bachelor of Computer Application (BCA) Community Share and Help
Syllabus BCA302
Database Management System
Gujarat University TY BCA Syllabus (Revised) Effective from June, 2006
| Part - I : Database Concepts | ||
| 1. | File System and Databases | 10% |
| Introducing the databases | ||
| the historical roots of the databases | ||
| a file system critique | ||
| database systems | ||
| database models | ||
| 2. | The Relational Database Model | 20% |
| Logical view of data | ||
| keys | ||
| integrity rules | ||
| relational database operators | ||
| the data dictionary and system catalog | ||
| relationship within the relationaldatabase | ||
| data redundancy | ||
| index | ||
| Part - II: Design and Implementation Concepts | ||
| 1. | E -R Modeling | 10% |
| Basic modeling concepts | ||
| data models | ||
| degree of data abstraction | ||
| the E-R model (with example) | ||
| 2. | Normalization of Database tables | 10% |
| Database tables | ||
| normalization | ||
| database design(with example) | ||
| higher level normal forms | ||
| de-normalization | ||
| 3. | Structured QueryLanguage (SQL) | 20% |
| Introduction to SQL | ||
| Data Defrinition commands | ||
| data manipulation commands | ||
| queries | ||
| advanced data management | ||
| commands | ||
| complex queries | ||
| updatable views | ||
| converting an E-R model into a Database structure (with example) | ||
| rules governing relationship among tables. | ||
| Part - III: Advanced Database Concepts | ||
| 1. | Transaction Management and Concurrency Control | 20% |
| What is transaction | ||
| properties | ||
| transaction log | ||
| concurrency control | ||
| concurrency control with locking mehtods | ||
| concurrency control with time stamping methods | ||
| concurrency control with Optimisticmethods | ||
| database recovery | ||
| 2. | Distributed Database Management Systems | 10% |
| Advantages | ||
| disadvantages | ||
| distributed database | ||
| distributed processing DDBMS components | ||
| Text Book: | ||
| Database Systems- Design, Implemenation and Management 4th Edition : Rob & Coronel (Course Technology - Thomson Learning) | ||
| Reference Books | ||
| Database Management System : Vipin Desai (Galgotia Pub.) | ||
| Modern Database Management 7th Edition : Hoffer, Prescott and McFadden, Pearson Education. | ||
| Database Management System : Korth (McGrow Hill) | ||
| Understanding SQL : Martin Grubber (BPB) | ||
| SQL a Complete Reference : Alex Leon, Mathews Leon, (Tata Mcgraw-Hill) |
| Total Marks of this Subject | 150 Marks |
| External (University ) Examination | 70 Marks |
| Practicle Examination | 50 Marks |
| Internal Sessional Examination | 20 Marks |
| Term Work | 10 Marks |
| Teaching Hours per week | 3 Hrs |
| Practicals | Based on SQL |
Last Updated on 11th Jun 2009