OIT551 Syllabus - Database Management Systems - 2017 Regulation - Open Elective | Anna University

OIT551 Syllabus - Database Management Systems - 2017 Regulation - Open Elective | Anna University

OIT551	DATABASE MANAGEMENT SYSTEMS	L T P C

3003

OBJECTIVES:

• To learn the fundamentals of data models
• To learn conceptual modeling using ER diagrams.
• To study SQL queries and database programming.
• To learn proper designing of relational database.
• To understand database security concepts.
• To understand Information retrieval techniques.

UNIT I	DBMS AND CONCEPTUAL DATA MODELING	9

Purpose of Database System – Data independence - Data Models – Database System Architecture – Conceptual Data modeling: ER models - Enhanced-ER Model. Introduction to relational databases – Relational Model – Keys – ER-to-Relational Mapping. Modeling of a library management system.

UNIT II	DATABASE QUERYING	11

Relational Algebra – SQL: fundamentals – DDL – Specifying integrity constraints - DML – Basic retrieval queries in SQL - Complex SQL retrieval queries – nested queries – correlated queries – joins - aggregate functions. Creating a table, populating data, adding integrity constraints, querying tables with simple and complex queries.

UNIT III	DATABASE PROGRAMMING	7

Database programming with function calls, stored procedures - views – triggers. Embedded SQL. ODBC connectivity with front end tools. Implementation using ODBC/JDBC and SQL/PSM, implementing functions, views, and triggers in MySQL / Oracle.

UNIT IV	DATABASE DESIGN	9

Functional Dependencies – Design guidelines – Normal Forms: first, second, third – Boyce/Codd Normal Form – Normalization algorithms. Design of a banking database system / university database system.

UNIT V	ADVANCED TOPICS	9

Database security issues – Discretionary access control – role based access – Encryption and public key infrastructures – challenges. Information Retrieval: IR Concepts, Retrieval Models, Queries in IR systems.

TOTAL: 45 PERIODS

OUTCOMES: Upon completion of the course, the students will be able to:

• understand relational data model, evolve conceptual model of a given problem, its mapping to relational model and Normalization
• query the relational database and write programs with database connectivity
• understand the concepts of database security and information retrieval systems

TEXT BOOKS:

1. Ramez Elmasri, Shamkant B. Navathe, “Fundamentals of Database Systems”, Sixth Edition , Pearson, 2011.
2. Abraham Silberschatz, Henry F. Korth, S. Sudharshan, “Database System Concepts”, Sixth Edition, Tata McGraw Hill, 2011

REFERENCES:

1. C.J.Date, A.Kannan, S.Swamynathan, “An Introduction to Database Systems”, Eighth Edition, Pearson Education, 2006.
2. Raghu Ramakrishnan, ―Database Management Systemsǁ, Fourth Edition, McGraw-Hill College Publications, 2015.