Page 149 - CatalogNEP-PS

Functions and Parameter Passing by Value, Passing Arrays to Functions, Call by Reference,
Recursion.

UNIT V (4 Hours)
Structures and Pointers, Self-Referential Structures and Introduction to Lists

PRACTICAL (30Hours)

1. Simple Programs
2. Decision making
3. Programs of Loops
4. Array processing
5. Functions and subprograms

SUGGUESTED READINGS:

1. E. Balaguruswamy, Programming in ANSI C, Tata McGraw-Hill
2. Byron Gottfried, Schaum's Outline of Programming with C, McGraw-Hill
3. Brian W. Kernighan and Dennis M. Ritchie, The C Programming Language, Prentice
Hall of India
4. Herbert Schildt C: The Complete Reference, McGraw Hill Education

Comp.222 Databases and SQL 2+1

LEARNING OBJECTIVES:

The primary objective of this course is:
 To equip them with basic data skills that will enhance their employability in general.
 To enable the student to create databases and extract meaningful data from databases

LEARNING OUTCOMES:

This course will enable the students to:
 to convert the ER-model to relational tables, populate relational database and formulate
SQL queries on data.
 to use database technology for data resource management.
 to organize, maintain and retrieve - efficiently, and effectively, information from a DBMS

THEORY (30 Hours)

UNIT I (8 Hours)

Introduction to Data and Database Management System, Relational Databases, Tables, Data types,
primary key.

UNIT II (10 Hours)

Structured Query Language (SQL), Create Table, SELECT Query with WHERE, SORT and
GROUP BY, UPDATE and INSERT commands. SQL JOINS

UNIT III (4 Hours)
Relational Algebra. Entity-Relationship Model, Normalisation of databases.

UNIT IV (4 Hours)

134