IP-506 RDBMS Revised syllabus Industrial and Production Engineering(IP) RGPV / RGTU B.E. IP, 5th (V) Semester syllabus

siteowner 5:38 PM
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

Rajiv Gandhi Technological University, Bhopal (MP)
B.E. (IP) Industrial and Production Engineering FOURTH IV SEMESTER
IP 506 RDBMS SYLLABUS
Revised Syllabus and Scheme Effective from July 2007

UNIT-I Introduction: Advantage of DBMS approach, various view of data, data independence, schema and sub-schema, primary concepts of data models, Database languages, transaction management, Database administrator and users, data dictionary, overall system architecture.
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.

References:
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.

Artikel Terkait

Previous
Next Post »