|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.|
One of the good thing about this academy is that students have the opportunity to work on live projects also, which is industry's current demand.
WOW! What an institute for Graphic designing. I enjoyed it my friends. Now I creates very much innovative and creative designs using Photoshop.
Hi, My name is Sumant. I am a student of Attitude Academy. I am Learning Advance MS Excel here. Teachers are very supported. Overall good experience here.
Attitude is one of the best institute at Yamuna Vihar and Uttam Nagar. I feel very lucky because all teachers are very good and teach us very well. You must be come here for your best future.
Complete C, C++, Java, PHP, Python, Data Structure, Dot Net, MySQL, JSP training classes is provided here.
I am very much impressed with the faculty, the way of teaching and the most important and impressive is the real time project work which is 100% practical.
Wonderful dresses I am stitching for myself, my family and the institute, after learning dress designing from this institute. So happy...
Very good computer institute from the faculty to the facility. Good interaction between students and trainer. Problems are listened and solved by the trainer immediately.
Best BCA, MCA, B.Tech & Computer Science coaching classes at this Yamuna vihar, Uttam nagar location in Delhi. I will recommend this to all students.
Best FD and DD, I am doing 6 months course from here, Anjali and Divya mam are best. Such an experienced and great faculty of fashion and dress designing here.
Mamta mam is best Tally GST Taxation trainer. Learning e-accounting in this institute in a better way.
I have Completed my Tally.ERP9 Course with good experience. And now I feel that I am very confident about my interview and job.