IP-506 RDBMS Revised syllabus Industrial and Production Engineering(IP) RGPV / RGTU B.E. IP, 5th (V) Semester syllabus
Tags: RGPV, BE, IP syllabus, RDBMS syllabus, B.E. Industrial and Production Engineering, IP V Semester syllabus, IP 5th Semester syllabus, RGPV IP 506 syllabus
B.E. (IP) Industrial and Production Engineering FOURTH IV SEMESTER
IP 506 RDBMS SYLLABUS
Revised Syllabus and Scheme Effective from July 2007
ER model: basic concepts, design issues, mapping constraint, keys, ER diagram, weak and strong entity sets, specialization and generalization, aggregation, inheritance, design of ER schema, reduction of ER schema to tables.
UNIT-II Domains, Relations and keys: domains, relations, kind of relations, relational database, various types of keys, candidate, primary, alternate and foreign keys.
Relational Algebra & SQL: The structure, relational algebra with extended operations, modifications of Database, idea of relational calculus, basic structure of SQL, set operations, aggregate functions, null values, nested sub queries, derived relations, modification of Database, join relation, DDL in SQL.
UNIT-III Relational Dependencies and Normalization: basic definitions, trivial and non trivial dependencies, closure set of dependencies and of attributes, irreducible set of dependencies, introduction to normalization, non loss decomposition, FD diagram, first second, third Normal forms, dependency preservation, BCNF, multivalued dependencies and forms normal form dependeny and fifth normal forms. Distributed Database: basic idea, distributed data storage, data replication, data fragmentationhorizontal, vertical and mixed frangmentation.
UNIT-IV Emerging Fields in DBMS : object oriented Database-basic idea and the model, object structure, object class, inheritance, multiple inheritance, object identity, data warehousing-terminology, definitions, characteristics, data mining and it’s overview, Database on www, multimedia Database-difference with conventional DBMS, issues, similarity based retrived continuous media data, multimedia data formats, video servers.
Unit V: Storage structure and file organizations: Overview of physical storage media, magnetic disksperformance and optimization, basic idea of RAID, organization, organization of records in files, basic concepts of indexing, ordered indices, basic idea of B-tree and B+-tree organization.
Network and hierarchical models: basic idea, data structure diagrams, DBTG model, implementations, tree structure diagram, implementation techniques, comparision of the three models.
1. A Silberschatz, H.F. Korth, Sudersan “Database System Concept”=, MGH Publication.
2. C.J. Date “An introduction to Database System”=6th ed.
3. Elmasri & Navathe “Foundamentals of Database system”- III ed.