| 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. |
I had enrolled in the Graphic Designing training Course. The course was well taught by the trainer and the learning environment was great. they provide best and updated Study material and Give training on real industry assignments , they gi
I had enrolled in the Interior Designing training Course. The course was well taught by the trainer and the learning environment was great. they provide best and updated Study material and Give training on real industry assignments , they
I am proud that I could participate this amazing course at the amazing Attitude Academy. It was an honor to work with knowledgeable tutors who helped us in all the ways possible. All I can say is Thank you Attitude Academy!
Being a student at Attitude Academy Yamuna Vihar as a super over experience. I am perceiving in financial accounting course I spend six month in this institute. I learnt so many things here there is not been academic also extra curriculum a
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.