DATABASE TECHNOLOGIES CLASS T.E. ( INFORMATION TECHNOLOGY) HOURS PER LECTURES : 04 WEEK TUTORIALS : -PRACTICALS : 02 HOURS EVALUATION THEORY 3 SYSTEM: PRACTICAL -ORAL -TERM WORK --
MARKS 100 -25 25
Objectives of the course: • This course aims to provide continuum to where the first course of databases left off. Design aspects of relational databases are covered. • Complex data models like OO OR parallel and distributed are introduced. • The course provides students a good overview of the ideas and the techniques, which are behind recent developments in the fields of data warehousing and Online Analytical Processing (OLAP). 1. Overview Review of relational database systems, ER diagram, SQL. 2. Integrity and Security Domain constraints; referential integrity, assertions; triggers; triggers and Assertions in SQL. Security and Authorization; Authorization in SQL. 3. Relational Database Design First Normal form; pitfalls in relational database design, functional dependencies; decomposition. Desirable properties of decomposition. Boyce – Code normal form; 3rd and 4th normal form. Mention of other normal forms. 4. The ER Model Revisited Motivation for complex data types, User Defined Abstract Data Types And Structured Types, Subclasses, Super classes, Inheritance, Specialization and Generalization, Relationship Types of Degree Higher Than Two. 5. Object-Oriented & Object relational databases Object Identity, Object Structure, and Type Constructors, Encapsulation of Operations, Methods, and Persistence, Type Hierarchies and Inheritance, Type extents and Queries, Database Design For An ORDBMS - Nested Relations and Collections; Storage And Access methods, Overview of SQL3. 6. Parallel and Distributed Databases Parallel Query Evaluation; Parallelizing Individual Operations, Sorting, Joins; Distributed Database Concepts, Data Fragmentation, Replication, and Allocation techniques for Distributed Database Design; Query Processing in Distributed Databases;...
Please join StudyMode to read the full document