Page 137 - CatalogNEP-LS

P. 137

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)
Application Development. Case Studies. Storage and File Structure, Indexing and Hashing. Query
Processing
UNIT V (4 Hours)

Query Optimization. Transactions (Serializability and Recoverability)

PRACTICAL (30Hours)

1. Creation of Simple Database using MS Access
2. Queries using SQL
3. Creation of Relations in Database
4. Simple Joins with SQL