An introduction to programming from both design and programming standpoints. Syntax and semantics of programming languages, programming style, program debugging and testing, data representation, simple arithmetic expressions, decision and control statements, using arrays, introduction to standard libraries, structured and modular programming techniques will be covered using C language.
Implementation of abstract data types and structures. Dynamic data structures. Strings, stacks, queues, linked lists, trees and graphs. Multidimensional structures. Recursion. Implementation of basic searching and sorting methods. Binary File I/O.
Fundamentals of SQL, Views, Constraints, Triggers, Transaction Processing, User Privileges, programming with PL/SQL, Oracle forms and reports with practice in Oracle Database Management System. Relational Algebra. Logical database design: Relational Data Model, Entity-Relationship (E-R) Diagrams, Functional Dependency and Normalization.
