|
|
Course Title: Teaching ICT and Object Oriented Programming & Database
Course NO.: ICTED 321 Full Mark:100(75+25) Nature of the Course : Theory 75% + Practical 25% Pass Mark: (35%+40%) Periods Per weak: 6+3 Total number of working periods 150 per year [Note: 1 period = 50 min] COURSE DESCRIPTION:- Object-oriented programming is an approach to thinking about computation and problem solving in Object Oriented Paradigms. This course lays out the principles of object-oriented programming in C++ Programming Language. The course helps the students to discover the basic concepts of object-oriented programming in C++. The database management system consists of introduction, data models, relational model, relational languages, relational database design, security issues, query processing, filing and files structure, crash recover, concurrency control, and advanced database model. It also introduces the concept of computer science teaching methodology. General Objectives
|
SN | Objectives | Contents | Period | Testing Strategies | Reference | Evaluation |
1 | -Familiarization of the oriented programming system. -Development of the program. -Case study of different types of systems related to object oriented programming. |
Introduction to Object Oriented Parogramming | 16 |
-Lecture -Practical -Discussion -Group work | Lafore Chap 1 |
-Short question -Long question -Multiple choice |
2 | -Understand the classes, methods, and messages. |
Classes, Methods and Messages | 17 hr | -Lecture -Practical -Discussion -Group work | Lafore Chap 7 - 9 |
-Short question -Long question -Multiple choice |
3 | -Identify different types of inheritances. |
Inheritance and Software Re usability | 11Hr |
-Lecture -Practical -Discussion -Group work | Lafore Chap 10 |
Oral Test -Short question -Long question -Multiple choice |
4 | -Understand polymorphism and its importance. -Comprehend varieties of polymorphic variables and its applications. |
Polymorphism | 12hr |
-Lecture -Practical -Discussion -Group work | Lafore Chap 13 | -Short
question -Long question -Multiple choice |
5. | -Understand basic of database. -Application of database. | Introduction | 4hr | -Lecture -Discussion | Majumdar Chap 1 | -Short
question -Multiple choice |
6. | -Identify different data model | Data Models | 5hr |
-Lecture -Practical -Discussion -Group work | Majumdar Chap 3, 4 | -Short
question
-Multiple choice |
7. | -Understand and apply relational algebra. -Understand and apply relational calculus. | Relational Model Definitions and terminology, structure of relational databases, The relational algebra, The relational calculus, Schemas and Views. | 5hr | -Lecture -Practical -Discussion -Group work | Majumdar Chap 4 | -Short
question -Long question -Multiple choice |
8. | -Define and carry out implementation of different relational languages. | Relational languages SQL, DDL and DML, QBE. | 5hr |
-Lecture -Discussion -Group work | Majumdar Chap 4 |
-Short
question -Long question -Multiple choice |
9. | -Identify different types of relational database design. -Understand the use of normalization for reducing redundancy. | Relational Database Design Introduction, Integrity constraints, Referential Integrity, Multi-valued and Join Dependencies, Normalization, Normal Forms, User schema or views design, Decomposition of relation schemes. | 10hr | -Lecture -Practical -Discussion -Group work | Majumdar Chap 5, 6 | -Short
question -Long question -Multiple choice |
10. | -Determine security principle in the database design. | Security Needs of security, Security and integrity violations, Access control, Authorization, Security and Views, Encryption and decryption. | 3hr | -Lecture -Practical -Discussion -Group work | Majumdar Chap 9 | -Short
question -Long question -Multiple choice |
11. | -Extraction of required information from database. -Implementation of query processing system. | Query Processing Introduction to query processing, Query interpretation, Equivalence of expressions, Query Optimization, Join strategies, Query decomposition. | 4hr | -Lecture -Practical -Discussion -Group work | Majumdar Chap 6 | -Short
question -Long question -Multiple choice |
12. | -Understand the need of filing system. -Implementation of the different types of filing system. |
Filing and File Structure Needs of filing, Overview of storage devices, Organization of records into blocks, File organizations, The sequential and the indexed sequential file organizations. | 5hr |
-Practical -Discussion -Group work | Majumdar Chap 2, 3 | -Short
question -Long question -Multiple choice |
13. | -Recover data during crash. -Implementation of different recovery system |
Crash Recovery Introduction to crash recovery and its importance, Failure classification, Backup-recovery, Storage hierarchy, Transaction model, Log-based recovery, Shadow paging. | 4hr |
-Practical -Discussion -Group work | Majumdar Chap 7 - 9 | -Short
question -Long question -Multiple choice |
14. | -Familiarization of different transaction processing. -Handling of the system during deadlock. |
Concurrency Control Introduction, Transaction and Transaction processing, Scheduling and Serializability, Locking and Lock based protocols, Time-stamping-based protocols, Deadlock handling, Multiple Granularity. | 5hr |
-Practical -Discussion -Group work | Majumdar Chap 10 | -Short
question -Long question -Multiple choice |
15. | -Understand the recent database techniques. |
Advanced Database Model Extended Relational Model, Object-Oriented Model, Distributed Model. | 4hr |
-Practical -Discussion -Group work | Majumdar Chap 11 | -Short
question -Long question -Multiple choice |
16. | -Deals with the teaching methodology in the case of computer science teaching. |
Computer Science Teaching Methodology | 40hr |
-Practical -Discussion -Group work | Internet, Books | -Short
question -Long question -Multiple choice |
Laboratory:
There shall be 20 exercises in minimum, as decided by the faculty. The exercises shall encompass a broad spectrum of real-life and scientific problems, development of small program to the development of fairly complex subroutines, programs for practical applications and problem solving situations. Laboratory assignments will be offered in groups of two to four for evaluation purpose. In general, the Laboratory Work must cover assignments and exercises from the following areas:
Text Book:
|