| S. No. | Counselling Sessions | Number of Sessions | Comments |
|---|---|---|---|
| 1. | Theory Sessions | 5 | Two sessions each on first two Blocks and one session on Block 3 & 4 |
| 2. | Practical Sessions | 2 | These two practical sessions may be used for solving assignment problems. These sessions are not compulsory. |
| Session Type | Number of Sessions | Block to be Covered | Topics to be covered |
|---|---|---|---|
| Theory Counselling | Block-1 | Block 1: Unit 1 and Unit 2 | The Database system, structure of a database, three level Architecture of databases and its importance, the relational model, the entity relationship model, conversion of ER diagrams to Relational Database. |
| Theory Counselling | 2 | Block 1: Unit 3 and Unit 4 | The concepts of integrity, referential integrity, functional dependency, the normal forms till BCNF, sequential file organization, indexes, index and B tree, multi key file organization. |
| Theory Counselling | 3 | Block 2: Unit 1 | The Structured Query Language: data definition and manipulation commands, views, nested queries, examples |
| Theory Counselling | 4 | Block 2: Unit 2, Unit 3 and Unit 4 | Transactions, concurrency related problems and control, locks, two phase locking, deadlock. Database recovery techniques, security and integrity, authorization, data access control, The need and advantages of the distributed and client server database systems, data replication and fragmentation, distributed queries. |
| Theory Counselling | 5 | Block 3 and Block 4 | Discuss the various issues on the case studies of these blocks. Suggest how these studies can be improved. |
| Practical Sessions | 1&2 | Assignment Problem | Design, implement and test the MCS 023 assignment problem. |
Attitude Academy is great place to learn. It gives me great to say with pride that, I have completed my Graphics Designing Course from Attitude Academy.The relationship between faculities and student is very cordial, which gave me an opport
Excellent institute. I would like to recommend it to everyone l know.
Wonderful dresses I am stitching for myself, my family and the institute, after learning dress designing from this institute. So happy...
I have Completed my Tally.ERP9 Course with good experience. And now I feel that I am very confident about my interview and job.